[Solved] Consider this Power Query M code:let Source = Table.FromRows({{"Product", "Price"}, {"Pen", 1.5}, {"Book", 12}}), Promoted = Table.... | Power BI

Power BI - Data Cleaning with Power Query

Consider this Power Query M code:

let
  Source = Table.FromRows({{"Product", "Price"}, {"Pen", 1.5}, {"Book", 12}}),
  Promoted = Table.PromoteHeaders(Source)
in
  Promoted

What will be the column headers after this query executes?

A["Column1", "Column2"]

B["Product", "Price"]

C["Pen", "1.5"]

D["Book", "12"]

Step-by-Step Solution

Solution:

Step 1: Identify first row
The first row is {"Product", "Price"}.
Step 2: Apply Table.PromoteHeaders
This function uses the first row as column headers.
Final Answer:
["Product", "Price"] -> Option B
Quick Check:
Headers match first row values [OK]

Quick Trick: PromoteHeaders sets first row as headers [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

Consider this Power Query M code: