Microsoft Certified: Power BI Data Analyst Associate Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A1

  ✅ A. SharePoint Folder → Transform → Filter Folder Path → Manufacturing Reports → Combine Connect using SharePoint Folder Choose Transform Data Filter the Folder Path Keep only the Manufacturing Reports library Combine the remaining Excel files This minimizes processing and avoids importing unnecessary files.

• Chose A2

  * Answer: 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 * Explanation: - Using SharePoint folder lets you combine multiple Excel files with the same structure. - Enter the site URL (not the library URL) so Power BI can access all files. - Then Transform and filter by the folder path to include only the manufacturing reports library before combining. * Other options: - B and D (SharePoint list) → Lists are for structured list data, not document libraries. - C (Combine & Load) → Loads everything without filtering, which doesn’t meet the requirement.

• Chose A1

  A. SharePoint Folder (Transform then filter) – Correct. Lists all files in document libraries. You can filter to just the manufacturing reports and then combine them. B. SharePoint List – Wrong. Returns list items, not files. Won’t pull Excel files from a document library. C. SharePoint Folder (Combine & Load) – Loads everything without letting you filter first. D. SharePoint List (Combine & Load) – Same problem as B. Not for files.