[Solved] Given this Power Query M code snippet connecting to an OData feed:let Source = OData.Feed("https://services.odata.org/V4/Northwind/Northwind.svc/Products"), Filtered = Table.... | Power BI

Power BI - Getting Data

Given this Power Query M code snippet connecting to an OData feed:

let
  Source = OData.Feed("https://services.odata.org/V4/Northwind/Northwind.svc/Products"),
  Filtered = Table.SelectRows(Source, each [CategoryID] = 1)
in
  Filtered

What will be the result?

AAn empty table because CategoryID is not a valid column.

BAn error because OData.Feed cannot filter data.

CA table of products where CategoryID equals 1.

DA list of all categories instead of products.

Step-by-Step Solution

Solution:

Step 1: Understand OData.Feed output
The OData.Feed() function returns a table of products from the OData service.
Step 2: Analyze filtering step
Table.SelectRows() filters rows where CategoryID equals 1, which is valid for this dataset.
Final Answer:
A table of products where CategoryID equals 1. -> Option C
Quick Check:
Filter by CategoryID=1 = filtered product table [OK]

Quick Trick: OData.Feed returns tables; filter with Table.SelectRows() [OK]

Common Mistakes:

Assuming OData.Feed cannot filter
Confusing products with categories
Thinking CategoryID column is missing

Master "Getting Data" in Power BI

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

More Power BI Quizzes

Given this Power Query M code snippet connecting to an OData feed:

Step 1: Understand OData.Feed output

Step 2: Analyze filtering step

Final Answer:

Quick Check:

Want More Practice?