PL-300 · Question #298
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…
The correct answer is A. Get data from a SharePoint folder and enter the site URL Select Transform, then filter by the. The SharePoint Folder connector retrieves all files from a SharePoint site. By selecting Transform (instead of Load or Combine & Load), you enter Power Query Editor where you can filter the folder path to the specific document library containing manufacturing reports before…
Question
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?
Options
- AGet data from a SharePoint folder and enter the site URL Select Transform, then filter by the
- BGet data from a SharePoint list and enter the site URL. Select Combine & Transform, then filter
- CGet data from a SharePoint folder, enter the site URL, and then select Combine & Load.
- DGet data from a SharePoint list, enter the site URL, and then select Combine & Load.
How the community answered
(38 responses)- A76% (29)
- B13% (5)
- C5% (2)
- D5% (2)
Explanation
The SharePoint Folder connector retrieves all files from a SharePoint site. By selecting Transform (instead of Load or Combine & Load), you enter Power Query Editor where you can filter the folder path to the specific document library containing manufacturing reports before combining them. This ensures only the manufacturing Excel files are loaded. Option B (SharePoint List) is designed for SharePoint list items, not files in a document library. Option C (SharePoint Folder + Combine & Load without Transform) would load and combine all files across all libraries on the site-not just the manufacturing reports. Option D has the same problem as B: SharePoint List is the wrong connector for document library files.
Community Discussion
No community discussion yet for this question.