Home » Microsoft » PL-300 » What should you do in Microsoft Power Bl Desktop?
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?
A. Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
B. Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
C. Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
D. Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.
Correct Answer: C
Explanation/Reference:
Explanation:
Example:
My SharePoint site root url is https://powerbipanama.sharepoint.com/, but all of my files areactually 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// 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.
Reference:
https://powerbi.microsoft.com/sv-se/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
