Forum Discussion
Issues with Connecting to SQL Server from a Dataflow in Power BI Service
Hi Everyone,
I am trying to connect to a SQL Server (express version) on my local machine from a Dataflow that is created in Power BI Service. I do have an On premises gateway established (personal mode) on the same PC as the SQL Server (express). However, when I try to connect to SQL Server from the Dataflow in Power BI Service, I am not able to choose the gateway from the dropdown because it says "none" as per below screenshot and no other options are available in the dropdown. I know that the gateway was established successfully because I am able to refresh a report on Power BI Service that is using a table from the same SQL Server on my PC, but I am not able to understand why the connection cannot be made from a Dataflow. Any suggestions would be highly appreciated. Thank you!
Hello Elena21 ,
You must create the connection at the Data Gateway level (best practice, and you will see that the database name is mandatory).Then
And then (in Gateway Cluster Name select your DataGateway)
Finally, once you are in DataFlow, simply enter the server name and database name, and it will find the previously recreated connection.
Please feel free to give me a kudo and accept my answer as the solution if it suits you.
Have a nice day,
Vivien
2 Replies
- vivien57
Super User
Hello Elena21 ,
You must create the connection at the Data Gateway level (best practice, and you will see that the database name is mandatory).Then
And then (in Gateway Cluster Name select your DataGateway)
Finally, once you are in DataFlow, simply enter the server name and database name, and it will find the previously recreated connection.
Please feel free to give me a kudo and accept my answer as the solution if it suits you.
Have a nice day,
VivienThank you very much Vivien, it did work indeed:-)
