And select “SQL Server” connector. Select “Connect using on-premises data gateway” option to connect to your database on-premises. Provide server name, database name, authentication type, user name ...

As a result, if you’re using DirectQuery and a gateway, you should experiment with the StreamBeforeRequestCompletes property to see if it can help you too. That said, if you’re using DirectQuery mode ...