Forum Discussion
Create Dataflow using Datasource under Gateway
Hi damit23183
If you have already created a Gateway datasource (Under GATEWAYS, SETTINGS, MANAGE GATEWAY). You can connect with Power BI Desktop, selecting the same database type location and credentials that you entered into the Gateway).
Power BI Desktop can't connect to a datasource via a Gateway, you need to select the database.
The normal process is the Gateway is only used for the Power BI Service. You normally connect to the server via Power BI Destkop internal to the network that has your Server. When you publish the workbook to the service, the service then uses the gateway to access the data (rather than an internal direct connection like used in Power BI Desktop).
Assuming your issue is you can't connect with Power BI Desktop to the server, I suggest first check you can connect to the server via SSMS or similar (you could also just use Excel). If that works, then it is most likely incorrect credentials stored in Power BI Desktop. Sign out (File\SignOut) and then clear your credentials cache (File\Options and Settings\Data Source Settings). Just delete the ones that could be causing the problem - then try again.
There is also a Power BI contruct called a Dataflow, it was that I thought you were using in my first response.
Hope this helps
Stuart
Hi damit23183
When you create the Dataflow, select "add new tables" in the Dataflow, then select the Database type from the Datasources available. Enter the Server and Database you want to connect to. If that server is gatewayed for you you'll see the Gateway credentials will fill in. If they don't auto fill you can try entering the Gateway and authentication details there.
Clicking "next" should connect you through the Gateway to the Database, select the Table(s) you want to query and click "transform data". This generates the following M code for my example SQL database.
Hi,
Thank you for your response Really appreciate it!
So, this will be the new dataflow and I need to start from scratch. As you said first step would be add tables but to add tables i need to connect somewhere (Datasource) that is what I am looking for.
I tried to SQL database, Blank QUery but none of that are working.
Is there any other datasource cateogry I need to use?
I am trying to connect DATA SOURCES created in GATEWAYS which you can see under SETTINGS --> MANAGE GATEWAY--> Under Gateway there is Datasource.
Thanks
Hi damit23183
If you have already created a Gateway datasource (Under GATEWAYS, SETTINGS, MANAGE GATEWAY). You can connect with Power BI Desktop, selecting the same database type location and credentials that you entered into the Gateway).
Power BI Desktop can't connect to a datasource via a Gateway, you need to select the database.
The normal process is the Gateway is only used for the Power BI Service. You normally connect to the server via Power BI Destkop internal to the network that has your Server. When you publish the workbook to the service, the service then uses the gateway to access the data (rather than an internal direct connection like used in Power BI Desktop).
Assuming your issue is you can't connect with Power BI Desktop to the server, I suggest first check you can connect to the server via SSMS or similar (you could also just use Excel). If that works, then it is most likely incorrect credentials stored in Power BI Desktop. Sign out (File\SignOut) and then clear your credentials cache (File\Options and Settings\Data Source Settings). Just delete the ones that could be causing the problem - then try again.
There is also a Power BI contruct called a Dataflow, it was that I thought you were using in my first response.
Hope this helps
Stuart