Exam PL-300 topic 1 question 8 discussion

We have to import Excel files from SharePoint, so we need the connector SharePoint folder which is used to get access to the files stored in the library. SharePoint list is a collection of content that has rows and columns (like a table) and is used for task lists, calendars, etc. Since we have to filter only on manufacturing reports, we have to select Transform and then filter by the corresponding folder path.

The Correct Answer is A. To load only the manufacturing reports (Microsoft Excel Files) from a specified SharePoint document library into Power BI Desktop for analysis, we should do, Geta data from a SharePoint folder and enter the site URL. Select Transform, then filter by the folder path to the manufacturing reports library. Option B is not the right answer choice because "SharePoint list" is selected, and you need to access files in a document library, not a list. Option C and Option D both include "Combine & Load", which typically combines multiple queries or tables and loads them into Power BI. However, since we only want to load files from a specific folder within the SharePoint library, we should use the "Transform" option to filter and select the desired data before loading it into Power BI.

Since all manufacturing reports are Excel files with the same structure and are stored in a specific document library, the best way to load them into Power BI is to use the "SharePoint folder" connector, Select Transform, then filter by the folder path to the manufacturing reports library. SharePoint lists store structured data, but manufacturing reports are stored as Excel files in a document library, making this option B incorrect.

Answer can be C As it is not mentioned there to transform we have to only load the files from folder

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.

Cant we directly give the path of the original sharepoint folder. i.e. the one that contains the Manufacturing Report excel file? So we wont need to again filter by that library. Just Combine and Load? I think C is right.

Correct the answer A Explanation: Since the manufacturing reports are saved as Excel files in a specific document library within SharePoint Online, the best option is to use Power BI Desktop to get data from the SharePoint folder that contains the manufacturing reports. After entering the site URL, select Transform to open Power Query Editor, and then filter the folder path to the manufacturing reports library so that only the Excel files in that library are loaded to the table for analysis. Option A is the correct choice for this scenario. No confusion, and no need to discuss further

A is the correct one. You need to select sharepoint folder as source, then insert the sharepoint URL and, as every source, select Transform: 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. OK

Someone please explain this to me, B says combine and transform which is mentioned in the explanation but why is that not the answer?

I guess answer is b, but not sure why it is A. Can someone please assist me with explanation

Why not C ? are the same stes as what is explained as solution,,,

A is correct.

I gree the expication.

The answer is A. Once you import the Sharepoint folder in Power BI, you can clean the data by transforming it and then filter it to show only the data you need based on the specific path.

A is correct answer.

A is correct

Answer is 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.