[Solved] Given this Power Query M code snippet:Source = SharePoint.Files("https://company.sharepoint.com/sites/marketing"),Filtered = Table.SelectRows(Source, each Text.EndsWith([Name], ".... | Power BI

Power BI - Getting Data

Given this Power Query M code snippet:

Source = SharePoint.Files("https://company.sharepoint.com/sites/marketing"),
Filtered = Table.SelectRows(Source, each Text.EndsWith([Name], ".xlsx"))

What does the Filtered table contain?

AOnly files named exactly '.xlsx'

BOnly Excel files in the root folder of the marketing site

CAll files in the marketing site ending with .xlsx

DAll files in the marketing site except Excel files

Step-by-Step Solution

Solution:

Step 1: Understand SharePoint.Files() output
SharePoint.Files() returns all files in the site and subfolders.
Step 2: Analyze the filter condition
Table.SelectRows filters rows where the file name ends with '.xlsx', so it keeps all Excel files.
Final Answer:
All files in the marketing site ending with .xlsx -> Option C
Quick Check:
Filter = files ending with .xlsx [OK]

Quick Trick: Text.EndsWith filters file extensions easily [OK]

Common Mistakes:

Master "Getting Data" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

Given this Power Query M code snippet: