[Solved] You wrote this Power Query M code:let Source = Table.FromRecords({[A=1,B=2],[A=3,B=4]}), Transposed = Table.Transpose(Source) in TransposedThe code returns an error. What is the likely cause? | Power BI

Power BI - Data Cleaning with Power Query

You wrote this Power Query M code:

let
  Source = Table.FromRecords({[A=1,B=2],[A=3,B=4]}),
  Transposed = Table.Transpose(Source)
in
  Transposed

The code returns an error. What is the likely cause?

AThe table has records with different field names

BTable.Transpose cannot be used on tables created from records

CThe syntax of Table.Transpose is incorrect

DThe table has columns with numeric names

Step-by-Step Solution

Solution:

Step 1: Check the table structure
The table is created from records with fields A and B, consistent across records.
Step 2: Identify common transpose error
Transpose requires all rows to have the same number of columns and consistent column names. If records had different fields, transpose fails.
Step 3: Analyze given code
Since records have same fields, no error expected from that. But if in real case fields differ, error occurs.
Final Answer:
The table has records with different field names -> Option A
Quick Check:
Transpose needs consistent columns [OK]

Quick Trick: Ensure all rows have same columns before transpose [OK]

Common Mistakes:

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

You wrote this Power Query M code: