Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

On Premises data gateway

I am using a direct query and I learned that I need to have on-premise data gateway as a service in enterprise mode- for the direct query. I used SSMS for the direct query (have remote access to the ...
Need Help
Show and Tell
Tutorial Requests
TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

Hi Anonymous ,

>> I used SSMS for the direct query (have remote access to the SQL server, not installed on my laptop), and I have the on-premises data gateway installed on the server with my power bi credentials(not my laptop).

SSMS is just a client of SQL Server, how did you configure it for the direct query? Besides, PowerBI Gateway can also been seen as a client, you need to configure it with the SQL Server credentials. Please refer to this document to configure the gateway: https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial.

By the way, PowerBI Gateway is a free tool.

Best Regards,

Teige