PL-300 · Question #70
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. When using DirectQuery against an on-premises SQL Server, the Power BI service cannot reach the database directly-it requires an on-premises data gateway installed on a machine that can access the SQL Server. After installing the standard (enterprise) on-premises data gateway…
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
(37 responses)- A5% (2)
- B14% (5)
- C73% (27)
- D8% (3)
Explanation
When using DirectQuery against an on-premises SQL Server, the Power BI service cannot reach the database directly-it requires an on-premises data gateway installed on a machine that can access the SQL Server. After installing the standard (enterprise) on-premises data gateway, you must also register and configure the SQL Server data source in the Power BI service settings. Personal mode (option B) is not recommended for shared/service scenarios. ExpressRoute (option D) alone does not provide the gateway bridging required.
Topics
Community Discussion
No community discussion yet for this question.