Microsoft
70-778 · Question #131
You 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. When you publish the Power BI…
The correct answer is C. Install the on-premises data gateway and configure a data source. https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial
Configure Dashboards, Reports, and Apps in the Power BI Service
Question
You 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. When you publish the Power BI Desktop project to the Power BI service, the visualizations cannot display the data. What should you do to resolve the issue?
Options
- ALocate the published dataset for the project in the Power BI service and configure the data source
- BInstall the on-premises data gateway (personal mode) and republish the project.
- CInstall the on-premises data gateway and configure a data source.
- DConfigure a Microsoft Azure ExpressRoute connection between the on-premises network and the
How the community answered
(51 responses)- A10% (5)
- B6% (3)
- C82% (42)
- D2% (1)
Explanation
https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial
Topics
#on-premises data gateway#DirectQuery#data source configuration#publishing
Community Discussion
No community discussion yet for this question.