Exam 70-778 topic 1 question 108 discussion

Actual exam question from Microsoft's 70-778

Question #: 108
Topic #: 1

You attempt to publish a Microsoft Excel file to Power BI, and you receive the error message shown in the exhibit. (Click the Exhibit button.)

The file is in c:\data\.
You need to ensure that you can publish the file to Power BI.
What should you do first?

A. Save the file in a Microsoft SharePoint document library.
B. Decrypt the workbook.
C. Add a digital signature to the workbook.
D. Set the file attributes to read-only.

Show Suggested Answer

Suggested Answer: B 🗳️
References:
https://docs.microsoft.com/en-us/power-bi/service-publish-from-excel

by VrajBhavsar at Jan. 6, 2020, 10 p.m.

Comments

Submit Cancel

VrajBhavsar

5 years, 5 months ago

The file definitely needs to be decrypted and the answer makes sense, buuuuut...... Shouldn't the excel file also fist need to get uploaded to OneDrive rather than C:/Data/ ? Would saving it to Sharepoint to the job?

upvoted 2 times

Dirk

5 years, 3 months ago

That's right, but they ask what to do first... probably the first thing to fix it

upvoted 1 times

...

goalguy

5 years, 2 months ago

Starting in the February 2017 update, Excel 2016 supports publishing of local Excel files. They do not need to be saved to OneDrive for Business or SharePoint Online. https://docs.microsoft.com/en-us/power-bi/service-publish-from-excel

upvoted 10 times

...

asgafsaf

3 years, 9 months ago

You can directly publish the excel file from your local as well. But the advantage of keeping the workbook in Sharepoint One Drive Business will be that file will be in sync with the Power BI service since both are in the cloud. So It will refresh the content every one hour.

upvoted 1 times

...