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.
I have a Power BI Desktop project that uses DirectQuery to access an on-premises
Microsoft SQL Server database.
From Power BI Desktop, you can query the database. But When I publish the Power BI Desktop project to the Power BI service, the visualizations cannot display the data. What should I do to resolve the issue?
1. Locate the published dataset for the project in the Power BI service and configure the
data source credentials.
2. Install the on-premises data gateway (personal mode) and republish the project.
3. Install the on-premises data gateway and configure a data source.
I think 1 is correct but why not 3..? Please can someone explain this?
Thank you!
Solved! Go to Solution.
@GilbertQ wrote:
Hi there
In order to use DirectQuery you need to install and configure the On-Premise data gateway in Enterprise mode.
Once that is done, then create a new data source in the Power BI Service to the SQL Server Database.
Once that is done, re-publish your PBIX file and once it has been published it should let you know that it has connected to the Gateway.
https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql
Thanks for your response. My question was which is correct from given options?
I have a Power BI Desktop project that uses DirectQuery to access an on-premises
Microsoft SQL Server database.
From Power BI Desktop, you can query the database. But When I publish the Power BI Desktop project to the Power BI service, the visualizations cannot display the data. What should I do to resolve the issue?
1. Locate the published dataset for the project in the Power BI service and configure the
data source credentials.
2. Install the on-premises data gateway (personal mode) and republish the project.
3. Install the on-premises data gateway and configure a data source.
@GilbertQ wrote:
Hi there
I thought that I had explained it in my response and the associated link?
Still not clear, just say option 1 is right or option 3..?
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.