Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 83 discussion

Actual exam question from Microsoft's 70-778

Question #: 83
Topic #: 1

DRAG DROP -
You have three Power BI Desktop projects named Report1.pbix, Report2.pbix, and Report3.pbix that have the following characteristics:
✑ Report1.pbix contains a custom visualization.
✑ Report2.pbix implements row level security.
✑ Report3.pbix connects to a Microsoft SQL Server database by using DirectQuery.
Which reports support Publish to Web, and which reports can be published to Power BI Report Server? To answer, drag the appropriate reports to the correct targets. Each report may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer

Suggested Answer:

References:
https
://docs.microsoft.com/en-us/power-bi/service-publish-to-web#custom-visuals

by exam_taker5 at July 9, 2019, 6:52 p.m.

Comments

Submit Cancel

TiaanR

Highly Voted 5 years, 11 months ago

Report 1, 2 and 3 can be published to report server. No such option available.

upvoted 16 times

coupet

5 years, 5 months ago

Agree, You can also use the DirectQuery connection or Live Connection to Power BI report server.

upvoted 1 times

...

Vermonster

5 years, 4 months ago

Agree. Check out this article - DirectQuery supported: https://docs.microsoft.com/en-us/power-bi/report-server/compare-report-server-service

upvoted 1 times

...

coupet

5 years, 1 month ago

Power BI Report Server: Row-level security (RLS) is Available in both DirectQuery (data source) & Import mode

upvoted 1 times

...

exam_taker5

Highly Voted 5 years, 11 months ago

I believe that both reports 1 and 2 can be published to the report server. https://docs.microsoft.com/en-us/power-bi/report-server/compare-report-server-service

upvoted 10 times

Hien

5 years, 9 months ago

I believe Power BI Report Server is not supporting Real-time Streaming and I guess SQL Server DirectQuery is real-time streaming, and it is not support. then the answer is Report 1 and Report 2 for Report server.

upvoted 3 times

JohnFan

5 years, 6 months ago

I Couldn't Agree With You More

upvoted 2 times

...

coupet

5 years, 5 months ago

Limitations - Publish to web : Reports using any Live Connection data source, including Analysis Services Tabular hosted on-premises, Analysis Services Multidimensional, and Azure Analysis Services.

upvoted 2 times

...

JaNieWiem

5 years, 1 month ago

Data can be imported or data can be queried directly using DirectQuery or a live connection to SQL Server Analysis Services. https://docs.microsoft.com/pl-pl/power-bi/report-server/data-sources

upvoted 1 times

...

jiawang6688

Most Recent 4 years ago

1 and 3, then 1, 2,3

upvoted 1 times

...

nemanjaandic

4 years, 3 months ago

Report server: i would choose report2 and report3 because these work. Report server also includes custom visualizations, BUT not all of them. Example: r visuals are not working (https://github.com/MicrosoftDocs/powerbi-docs/issues/671)

upvoted 2 times

...

FrdFrd

4 years, 4 months ago

Based on the current Microsoft docs, I would choose Publish to Web: Report1 and Report3 I find no reason not to choose Report3: reports not supported are based on live connection sources, not DirectQuery ones ( Limitations ... "Reports using any Live Connection data source" -- https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web#limitations) Power BI Report Server: Report1, Report2 and Report3 (custom visuals are supported, except for R and Python ones, RLS is suported and DirectQuery too - https://docs.microsoft.com/en-us/power-bi/report-server/compare-report-server-service)

upvoted 3 times

...

CDL

4 years, 7 months ago

Report 1: publish to web Report 1+2+3: publish to BI report server Publish to Web – Limitations: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web#limitations DirectQuery: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#directquery-connections BI Report Server(On-premises) vs. BI service (Cloud) https://docs.microsoft.com/en-us/power-bi/report-server/get-started#comparing-power-bi-report-server

upvoted 1 times

CDL

4 years, 7 months ago

https://docs.microsoft.com/en-us/power-bi/report-server/data-sources report-3

upvoted 1 times

...

CDL

4 years, 7 months ago

Real-time Streaming: PBI server NO, PBI service YES; RLS: both YES DirectQuery: Both YES. https://docs.microsoft.com/en-us/power-bi/report-server/compare-report-server-service https://docs.microsoft.com/en-us/power-bi/report-server/data-sources

upvoted 1 times

...

tinknerd

4 years, 9 months ago

exam ref pg 293: publish to web limitations: -R visuals -reports with RLS -reports that connect to live on prem AS tabular -reports shared with you

upvoted 4 times

PresidentK

4 years, 3 months ago

So helpful when people reference the book and exact page numbers!

upvoted 1 times

...

mahakr

4 years, 10 months ago

It clearly says in Limitation Section , You cannot use RLS in Publish To Web : https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web#custom-visuals there for For First option : Only Report 1

upvoted 1 times

...

pbia

4 years, 10 months ago

RLS is permitted in PBI report server https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server

upvoted 1 times

...

faini70

4 years, 11 months ago

https://docs.microsoft.com/en-US/power-bi/report-server/compare-report-server-service RLS is supported in Power BI Report Server.

upvoted 1 times

...

Cherryji

5 years ago

SQL server direct query is supported by PBI Report Server So second answer should be - all 3

upvoted 2 times

...

Cherryji

5 years ago

custom visuals are supported in publish to web https://community.powerbi.com/t5/Service/publish-to-web-option/td-p/642864 So for publish to web it should be reports 1 and 3

upvoted 4 times

...

rainbowstuf

5 years ago

1publishing to the web 1, 2-3 for a report server https://docs.microsoft.com/en-us/power-bi/report-server/data-sources

upvoted 2 times

...

Dirk

5 years, 3 months ago

Report Server: 1,2,3 it should be also possible for the Wol Level Security: https://docs.microsoft.com/de-de/power-bi/report-server/row-level-security-report-server

upvoted 2 times

gogetter

4 years, 10 months ago

No such option given in the answers.

upvoted 1 times

gogetter

4 years, 10 months ago

So which one should we choose?

upvoted 1 times

...

lozqt

5 years, 3 months ago

Publish to Web --> Report 1 & 3 "Custom visuals are supported in Publish to web" --> https://docs.microsoft.com/fr-fr/power-bi/service-publish-to-web "“Reports created using DirectQuery can be published to the Power BI service.” -->https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery Published to PBI Report Server : Report 1 & 2 Report 1 --> https://docs.microsoft.com/en-us/power-bi/report-server/compare-report-server-service Report 2 --> “Setting up row-level security (RLS) with Power BI Report Server can restrict data access for given users.” -->https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server

upvoted 2 times

Israel2

5 years ago

Publish to Web is different from Power BI service, so for the first part only Report 1 I guess.

upvoted 3 times

Echicken69

4 years, 11 months ago

To answer your question on regards to Report3 for Publish to Web...apparently someone tested it. https://community.powerbi.com/t5/Service/Publish-to-Web-and-directquery/td-p/143201#:~:text=Based%20on%20my%20test%2C%20the,is%20available%20in%20DirectQuery%20report.

upvoted 2 times

...