Analyzing Data with Microsoft Power BI (legacy) — Question 21

You have a Microsoft SharePoint Online site that contain 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 use Power BI Desktop to load only the manufacturing reports to a table for analysis.
What should you do?

Answer options

• 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. Select Combine & Transform, then filter by the folder path to the manufacturing reports library.
• C. Get data from a SharePoint Online folder and enter the site URL. Select Combine & Transform, then filter by the folder 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: B

Explanation

The correct answer is B because it specifies getting data from a SharePoint Online list, which is necessary for accessing structured data, and allows filtering by the folder path to target the manufacturing reports. Options A and D incorrectly suggest using Combine & Load, which does not allow for transformation and filtering. Option C incorrectly states to use a folder instead of a list, which fails to align with the data structure requirement.