Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 93 discussion

Actual exam question from Microsoft's 70-778

Question #: 93
Topic #: 1

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?

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.

Show Suggested Answer

Suggested Answer: C 🗳️
References:
https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial

by bilel_kaaniche at April 5, 2020, 7:12 p.m.

Comments

Submit Cancel

Mar_tin

4 years, 8 months ago

My thoughts based on the tutorial: https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial Given: 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. Assumption: There is no reason to chose gateway (personal mode) and its limitations Solution: C. Install the on-premises data gateway and configure a data source. Reason: "Install an on-premises data gateway on the same local computer as SQL Server (in production, it would typically be a different computer)." ->https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial ->Prerequisites

upvoted 2 times

...

Vinni14

4 years, 9 months ago

The correct answer is C. In Power BI Desktop, you connected directly to your on-premises SQL Server database, but the Power BI service requires a data gateway to act as a bridge between the cloud and your on-premises network.

upvoted 3 times

...

pbia

5 years ago

If you use import instead of directquery, you would see visualization. But in case of directquery no any data is passed to service until we install data gateway

upvoted 2 times

yess123

4 years, 11 months ago

OK for A

upvoted 1 times

...

Imadq

5 years, 1 month ago

C is the correct asnwer

upvoted 3 times

...

Imadq

5 years, 2 months ago

c is the correct

upvoted 2 times

...

CYRUSD

5 years, 2 months ago

As you see in Tutorial, One of the prerequisites are "Install an on-premises data gateway on the same local computer as SQL Server " So I believe C is right answer

upvoted 2 times

...

ACSC

5 years, 3 months ago

It is A. You can already query the database from Power BI desktop, so on-prem data gateway is already installed.

upvoted 1 times

coupet

5 years, 2 months ago

In Power BI Desktop, you connect directly to your on-premises SQL Server database, but the Power BI service requires a data gateway to act as a bridge between the cloud and your on-premises network.

upvoted 10 times

...

angelika

5 years, 3 months ago

so is it A or C, i have another source saying it is A?

upvoted 1 times

...

bilel_kaaniche

5 years, 3 months ago

I think is A If the used data source doesn't need the On-premises data gateway (Azure SQL Database, Azure SQL Data Warehouse, or Redshift), you must provide credentials before the Power BI service shows the published report. Follow these instructions to provide the credentials

upvoted 2 times

las

5 years, 3 months ago

It says in the question that the data source is "on-premises Microsoft SQL Server database", which implies that the data is not in the internet and needs the on-premises data gateway.

upvoted 11 times

bilel_kaaniche

5 years, 3 months ago

las,you are right, it is C

upvoted 4 times

...