Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am connected to a database through a gateway, and I want to create a dataset with the data from the gateway.
Ps: I have the pro license.
Regards.
Solved! Go to Solution.
If you cannot connect the the database from Power BI desktop it is more difficult to create a Dataset when you only have access through a Gateway. Check first that you can't connect in Power BI Desktop, go to Get Data and select the database type you have, then enter your database connections details (These should be the same as in the Gateway).
If however you can't connect to the database from Desktop, say the database is on a private server that only the Gateway has access to. You can still connect by going via a Dataflow.
In Power BI service in a Workspace, create a Dataflow and select the Database type you're using. The Dataflow will need the database server and name and the Data Gateway authentication details. This will then connect to the Database and allow you to create Dataflows on the data extracted from it.
Then in Power BI desktop, you can connect to these dataflows, and build your star-schema model with relationships etc. Then you can publish this Dataset to the Power BI service.
Hope this helps
Stuart
If you cannot connect the the database from Power BI desktop it is more difficult to create a Dataset when you only have access through a Gateway. Check first that you can't connect in Power BI Desktop, go to Get Data and select the database type you have, then enter your database connections details (These should be the same as in the Gateway).
If however you can't connect to the database from Desktop, say the database is on a private server that only the Gateway has access to. You can still connect by going via a Dataflow.
In Power BI service in a Workspace, create a Dataflow and select the Database type you're using. The Dataflow will need the database server and name and the Data Gateway authentication details. This will then connect to the Database and allow you to create Dataflows on the data extracted from it.
Then in Power BI desktop, you can connect to these dataflows, and build your star-schema model with relationships etc. Then you can publish this Dataset to the Power BI service.
Hope this helps
Stuart
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.