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?
- 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. Correct
- 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.
Explanation
The SharePoint folder connector lists every file in all document libraries of the site. Selecting Transform lets you filter on the Folder Path column to keep only the manufacturing reports library before combining the files. Combine & Load straight away would try to combine every file on the site, not just the manufacturing reports. The SharePoint list connector reads list items, not the contents of files in a document library.
