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.

View Answer

Answer: B

Explanation:

We have to import Excel files from SharePoint, so we need the connector SharePoint folder which is used to get access to the files stored in the library. SharePoint list is a collection of content that has rows and columns (like a table) and is used for task lists, calendars, etc. Since we have to filter only on manufacturing reports, we have to select Transform and then filter by the corresponding folder path.

https://docs.microsoft.com/en-us/power-query/connectors/sharepointlist