Analyzing and Visualizing Data with Microsoft Power BI — Question 109

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?

Answer options

• A. Locate the published dataset for the project in the Power BI service and configure the data source credentials.
• B. Install the on-premises data gateway (personal mode) and republish the project.
• C. Install the on-premises data gateway and configure a data source.
• D. Configure a Microsoft Azure ExpressRoute connection between the on-premises network and the Power BI service.

Correct answer: C

Explanation

The correct answer is C because installing and configuring the on-premises data gateway is essential for enabling the Power BI service to access on-premises data sources. Option A is incorrect as simply configuring data source credentials does not resolve the connection issue without a gateway. Option B suggests using a personal mode gateway, which is not suitable for shared datasets, and option D involves a more complex setup that is not necessary for this scenario.