nerdexam
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)
  • A
    10% (5)
  • B
    6% (3)
  • C
    82% (42)
  • D
    2% (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.

Full 70-778 Practice