Microsoft Power BI Data Analyst — Question 100

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

Correct answer: A

Explanation

The correct answer is A because it correctly specifies obtaining data from a SharePoint folder, which is necessary for accessing files, and then allows filtering to isolate the manufacturing reports. Option B incorrectly suggests using a SharePoint list, which is not suitable for this scenario, while options C and D do not include the necessary transformation step to filter by the folder path.