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

Power BI - Getting Data

Given this Power Query M code snippet:

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

What will this query return?

AA list of all customers in the USA

BA table of orders shipped to the USA

CAn error because ShipCountry is not a valid column

DA table of products filtered by USA suppliers

Step-by-Step Solution

Solution:

Step 1: Analyze the source
The OData.Feed connects to the Orders entity from Northwind.
Step 2: Understand the filter
Table.SelectRows filters rows where ShipCountry equals "USA".
Step 3: Determine output
The output is a table of orders shipped to the USA.
Final Answer:
A table of orders shipped to the USA -> Option B
Quick Check:
Filtering by ShipCountry returns matching orders [OK]

Quick Trick: Filtering OData tables returns matching rows [OK]

Common Mistakes:

Confusing Orders with Customers or Products
Assuming ShipCountry is invalid
Thinking the filter applies to suppliers

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:

Step 1: Analyze the source

Step 2: Understand the filter

Step 3: Determine output

Final Answer:

Quick Check:

Want More Practice?