Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 132 discussion

Actual exam question from Microsoft's 70-778

Question #: 132
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: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power BI, and the click Upload.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by Hien at Aug. 19, 2019, 6:10 a.m.

Comments

Submit Cancel

Nmak

4 years, 9 months ago

To publish your Excel workbook, in Excel, select File > Publish and select either Upload or Export. If you Upload your workbook to Power BI, you can interact with the workbook just as you would interact using Excel Online. You can also pin selections from your workbook onto Power BI dashboards, and share your workbook, or selected elements, through Power BI. If you select Export, you can export table data and its data model into a Power BI dataset, which you can then use to create Power BI reports and dashboards.

upvoted 2 times

Nmak

4 years, 9 months ago

So answer to this question is B.

upvoted 1 times

...

PowerLjubica

4 years, 11 months ago

When you do Export, not Upload, Power View sheets are converted into Reports in Power BI. So the answer is NO.

upvoted 1 times

...

Echicken69

4 years, 11 months ago

Here is a solution: https://community.powerbi.com/t5/Service/From-Excel-Publish-to-Power-BI-to-recreate-the-Power-View-sheets/td-p/715718

upvoted 3 times

wifaq

4 years, 10 months ago

So the answer is A yes.

upvoted 1 times

...

Echicken69

4 years, 11 months ago

https://docs.microsoft.com/en-us/power-bi/connect-data/service-publish-from-excel If you Upload your workbook to Power BI, you can interact with the workbook just as you would interact using Excel Online. You can also pin selections from your workbook onto Power BI dashboards, and share your workbook, or selected elements, through Power BI. If you select Export, you can export table data and its data model into a Power BI dataset, which you can then use to create Power BI reports and dashboards. If your Excel file resides on OneDrive for Business, you can only publish to your My Workspace. If your Excel file resides on a local drive, you can publish to My Workspace or a shared workspace to which you have access.

upvoted 1 times

...

Eric777

5 years ago

If all you do is "Upload" the workbook, the Power View sheets are not re-created in PBI.

upvoted 3 times

...

JessieJin

5 years ago

for you need to recreate the reports so need to export instead of upload

upvoted 2 times

...

CYRUSD

5 years, 1 month ago

If you Copy this to One Drive , You can publish it only to My workspace . Also the steps mentioned in answer is for the time you export from local excel files

upvoted 1 times

...

amar111

5 years, 2 months ago

any explanation why the answer is NO . Is it because , you need to "export" the "workbook" as a "data set" and then create reports from that dataset . Instead of publishing the "Workbook" . I don't see anything wrong with steps mentioned to publish the workbook . Its correct -> Click Publish to Power BI -> Upload

upvoted 1 times

mohacoldsnake

4 years, 7 months ago

I think you're right. it's because , you need to "export" the "workbook" as a "data set" and then create reports from that dataset . in the question they ask you to recreate the reports so you need to use "export" instead of "upload". The answer is Correct "NO".

upvoted 1 times

...

Hien

5 years, 9 months ago

in excel Power BI Add-in, it is pinned, not upload.

upvoted 3 times

HiJaak

5 years, 8 months ago

Is not about "Power BI Add-in" is native Excel - File\Publish so the correct answer is NO. With Export option could be achieved. https://docs.microsoft.com/en-us/power-bi/service-publish-from-excel

upvoted 3 times

...