[Solved] What is the expected output of this Power Query M code?let Raw = Web.Contents("https://api.example.com/users"), Json = Json.Document(Raw), Users = Json["users"], Table = Table.... | Power BI

Power BI - Getting Data

What is the expected output of this Power Query M code?

let
  Raw = Web.Contents("https://api.example.com/users"),
  Json = Json.Document(Raw),
  Users = Json["users"],
  Table = Table.FromList(Users, Splitter.SplitByNothing())
in
  Table

AAn error due to incorrect JSON parsing

BA single record containing all users concatenated

CA table listing each user as a single row

DA table with columns for user details automatically expanded

Step-by-Step Solution

Solution:

Step 1: Retrieve JSON data
Web.Contents fetches raw data, Json.Document parses it.
Step 2: Extract 'users' array
Json["users"] accesses the list of users.
Step 3: Convert list to table
Table.FromList creates a table with each user as a row.
Final Answer:
A table listing each user as a single row -> Option C
Quick Check:
List to table conversion creates rows [OK]

Quick Trick: Json.Document + Table.FromList creates row per list item [OK]

Common Mistakes:

Expecting automatic column expansion
Assuming concatenated string output
Misunderstanding JSON parsing steps

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

What is the expected output of this Power Query M code?

Step 1: Retrieve JSON data

Step 2: Extract 'users' array

Step 3: Convert list to table

Final Answer:

Quick Check:

Want More Practice?