ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam
Go to Exam

Exam 70-778 topic 1 question 133 discussion

Actual exam question from Microsoft's 70-778
Question #: 133
Topic #: 1
[All 70-778 Questions]

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 the Power BI service, get the data from SharePoint Online, and then click Connect.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
We need to click "Import", not "Connect".
References:
https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files
by 3water at Aug. 19, 2019, 3:14 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
coupet
Highly Voted 5 years, 5 months ago
Import: You can continue editing your workbook in Power BI. Connect: You can’t edit your workbook in Power BI.
upvoted 11 times
...
iaaqq
Most Recent 4 years, 5 months ago
The answer should be YES! If your workbook file is on OneDrive or SharePoint - Team Sites, choose Import or Connect.
upvoted 1 times
...
CDL
4 years, 7 months ago
https://docs.microsoft.com/en-us/power-bi/connect-data/service-excel-workbook-files#import-or-connect-to-an-excel-workbook-from-power-bi Here should be "Import" rather than "Connect" Becoz it required "editable" in PBI service(Cloud).
upvoted 1 times
...
eug45
4 years, 9 months ago
Answer is A read this https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/
upvoted 1 times
...
vcyc
4 years, 11 months ago
The answer should be YES. The Power View sheets turns up correct in Power BI service.
upvoted 1 times
...
r8d1
4 years, 11 months ago
in Power BI service: Get Data > Files > SharePoint - Team Sites > ...gives the options 1. enter site URL 2. Connect to see the content available at the root level. So the answer is YES, connect!
upvoted 3 times
...
Echicken69
4 years, 12 months ago
https://community.powerbi.com/t5/Service/From-Excel-Publish-to-Power-BI-to-recreate-the-Power-View-sheets/td-p/715718 I need to recreate the Power View sheets as reports in the Power BI service. Following steps can Solve the problem: From the Power BI service, get the data from SharePoint Online, and then click import (This is the solution when excel workbook is saved toMicrosoft SharePoint Online)
upvoted 1 times
...
amar111
5 years, 2 months ago
The Correct answer is "no" . Please read this article . https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files we need to click on Import to create powerview sheets as reports . clicking connect will put your workbook into powerbi - just like excel online.
upvoted 2 times
JeiLoa
4 years, 6 months ago
The illustration in the article appears to describe from Excel to PBI. Further down it covers PBI pull in Excel, however not explicit for Connect v Import. to me it seems connect is the only option when pulling SharePoint in from PBI.
upvoted 1 times
JeiLoa
4 years, 6 months ago
Even so, this pulls in as a workbook, not a Report, so does not meet objective. Answer is correct.
upvoted 1 times
...
...
...
Jrestrepo
5 years, 3 months ago
The answer is “YES” because when choosing to get data from SharePoint Online there is not an “Import Option” only *Connect* which leads you to enter the URL of the file you want to get into power BI
upvoted 2 times
FrdFrd
4 years, 5 months ago
Answer is not Yes. After you enter the URL for the sharepoint site and navigate and find your xls file you will be presented with the options to Import and Connect. Here we need to Import so that new reports can be built on top of the imported data.
upvoted 1 times
...
...
cs3122
5 years, 5 months ago
The key here is you need to click "Import", not "Connect"
upvoted 3 times
...
3water
5 years, 10 months ago
??? it should be 'Connect'?
upvoted 1 times
rhsdeal
5 years, 10 months ago
The answer should be YES "Import or connect to an Excel workbook from Power BI 1.In Power BI, in the navigation pane, click Get Data. 2.In Files, click Get. 3.Find your file. --SharePoint - Team Sites 4.If your workbook file is on OneDrive or SharePoint - Team Sites, choose Import or Connect. https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files
upvoted 3 times
rhsdeal
5 years, 10 months ago
This is also the same as question 52 on pg 11. ***Since the Import, rebuilds the power view sheets as reports the answer is YES, using Connect will not rebuild the power view sheets.
upvoted 2 times
...
Hien
5 years, 10 months ago
"No" is correct, as the constraint is "You need to recreate the Power View sheets as reports in the Power BI service." e.g. you have to import.
upvoted 13 times
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel