PL-300 · Question #42
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 C. Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the. The 'SharePoint Online folder' connector retrieves all files in a SharePoint site. By entering the site URL and then editing the query to filter by the folder path (the specific document library path), you can narrow the results to only the manufacturing reports. Selecting…
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 load only the manufacturing reports to a table for analysis. What should you do in Microsoft Power Bl Desktop?
Options
- AGet data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
- BGet data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path
- CGet data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the
- DGet data from a SharePoint Online list and enter the site URL.
How the community answered
(46 responses)- A7% (3)
- B11% (5)
- C80% (37)
- D2% (1)
Explanation
The 'SharePoint Online folder' connector retrieves all files in a SharePoint site. By entering the site URL and then editing the query to filter by the folder path (the specific document library path), you can narrow the results to only the manufacturing reports. Selecting 'Combine & Load' immediately (option A) skips the filtering step and would import all files. The 'SharePoint Online list' connector is for SharePoint lists, not document libraries.
Topics
Community Discussion
No community discussion yet for this question.