New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft Exam DA-100 Topic 16 Question 27 Discussion

Actual exam question for Microsoft's DA-100 exam
Question #: 27
Topic #: 16
[All DA-100 Questions]

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to load only the manufacturing reports to a table for analysis.

What should you do in Microsoft Power Bl Desktop?

Show Suggested Answer Hide Answer
Suggested Answer: C

Example:

My SharePoint site root url is https://powerbipanama.sharepoint.com/, but all of my files are actually in another site that starts with https://powerbipanama.sharepoint.com/sites/externalsales/ URL.

In order to use the correct URL, we need to be in the folder of the data that we're trying to get and check the url that our browser shows. If it has the if it starts with the format of Error! Hyperlink reference not valid. address>/sites/<sitename>/ then we need to use that url, otherwise we use the much simpler Error! Hyperlink reference not valid. address>

In my own case, I'll be using the https://powerbipanama.sharepoint.com/sites/externalsales url in order to connect to my site.


https://powerbi.microsoft.com/sv-se/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

by Thurman at May 07, 2022, 07:15 PM

Limited Time Offer

25%

Off

Get Premium DA-100 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!


Save Cancel