Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 51 discussion

Actual exam question from Microsoft's 70-778

Question #: 51
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.
You need to recreate the Power View sheets as reports in the Power BI service.
Solution: From Excel, click Publish to Power BI, and then click Export.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by rhsdeal at Aug. 22, 2019, 2:01 a.m.

Comments

Submit Cancel

Lhouss

4 years, 5 months ago

For me It's A. https://docs.microsoft.com/fr-fr/power-bi/connect-data/service-publish-from-excel Local file publishing Excel supports publishing of local Excel files. They do not need to be saved to OneDrive for Business or SharePoint Online. Important You can only publish local files if you're using Excel 2016 (or later) with a Microsoft 365 subscription. Excel 2016 standalone installations can Publish to Power BI, but only when the workbook is saved to OneDrive for Business or SharePoint Online.

upvoted 2 times

...

CDL

4 years, 6 months ago

A is correct. https://docs.microsoft.com/en-us/power-bi/connect-data/service-publish-from-excel we have a Excel workbook with query+model+visual done & Stored in OneDrive, we just publish to BI.com and select "Export". Attention, here asking from Excel, not from power BI.com, if from power BI.com , just "upload" file and then select "onedrive", make sure direction clear.

upvoted 1 times

CDL

4 years, 6 months ago

Correct my self: it's B, no. just tested, for Sharepoint data source, we need a URL/permission. https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sharepoint-scenario-setup

upvoted 1 times

CDL

4 years, 6 months ago

still yes. and go back and forth to Double check. from BI service side, need a URL, from excel side, just publish, and export. https://docs.microsoft.com/en-us/power-bi/connect-data/service-get-data-from-files#where-your-file-is-saved-makes-a-difference

upvoted 1 times

...

Vi1125

4 years, 7 months ago

Answer is B - question 52 proves this.

upvoted 1 times

...

Vi1125

4 years, 7 months ago

I would say B - for reason Twaine mentioned - the steps given are correct for an Excel file - but this is an Excel file saved on Sharepoint - so it would make sense this is not the correct procedure, the solution starts "From Excel, click Publish" - but the question is telling us the file is save to Microsoft SharePoint Online - so that should be the logical starting point, not Excel.

upvoted 1 times

...

wayneseh217

4 years, 8 months ago

No confusion, answer is A

upvoted 3 times

...

Mo2011

4 years, 8 months ago

Guys I am really confused and don't know what is the correct answer A or B? Yes Or No? Why not from sharepoint we open the excel workbook and publish to BI service by choosing export? what's wrong with that?

upvoted 2 times

...

thulstrup

4 years, 9 months ago

A is the correct answer. Aim is to have Power View sheets shown as Reports. That's done via Publish -> Export. https://docs.microsoft.com/en-us/power-bi/connect-data/service-publish-from-excel Export workbook data to Power BI When you choose the Export option, any supported data in tables and/or a data model are exported into a new dataset in Power BI. Any Power View sheets in the workbook are re-created in Power BI as reports.

upvoted 3 times

...

borut

4 years, 9 months ago

I agree with RutRut. Correct answer is definitely A. Because the excel file is located at SharePoint, we don't need Excel with Office 365 subscription. All we need is Excel 2016 and later.

upvoted 1 times

...

PowerLjubica

4 years, 10 months ago

A is correct. When you do export from excel Power View sheets are shown as Reports in Power BI.

upvoted 1 times

...

Stopher04

5 years, 2 months ago

A or B?

upvoted 1 times

prokocim

5 years ago

B. export from Share Point not possible

upvoted 1 times

...

RutRut

5 years, 2 months ago

Correct answer is A. You can Publish > Export form Excel stored in OneDrive or SharePoint Online. Only Excel 2016 with an Office 365 subscription will see the experience to publish with local files. Excel 2016 standalone installation will still have the "Publish" only behavior which requires the excel workbook be saved to OneDrive for Business or SharePoint Online. https://docs.microsoft.com/bg-bg/power-bi/service-publish-from-excel You can do this same from Power BI service: Get Data > Files > Import

upvoted 3 times

manofiron

5 years, 2 months ago

are we going to assume the user has an Office 365 subscription?

upvoted 1 times

...

rhsdeal

5 years, 8 months ago

I think this should B, can anyone help with this one.

upvoted 2 times

twane

5 years, 8 months ago

Yes: From Excel, click Publish to Power BI, and then click Export. (This is the solution when excel workbook is saved to OneDrive for Business). For SharePoint, you need to import from PowerBI service.

upvoted 18 times

PowerBIconsultant12

4 years, 7 months ago

You are correct: "If your workbook file is on OneDrive or SharePoint - Team Sites, choose Import or Connect." https://docs.microsoft.com/en-us/power-bi/connect-data/service-excel-workbook-files#import-or-connect-to-an-excel-workbook-from-power-bi

upvoted 3 times

...

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 51 discussion

Comments

Lhouss

CDL

CDL

CDL

Vi1125

Vi1125

wayneseh217

Mo2011

thulstrup

borut

PowerLjubica

Stopher04

prokocim

RutRut

manofiron

rhsdeal

twane

PowerBIconsultant12

SY0-701