You have a table where the first row contains data, and the second row contains the actual headers. How can you promote the second row as headers in Power Query?

hard📝 Scenario Q8 of 15

Power BI - Data Cleaning with Power Query

ARemove the first row, then apply <code>Table.PromoteHeaders</code>.

BApply <code>Table.PromoteHeaders</code> directly without changes.

CUse <code>Table.Skip</code> to skip the first row, then promote headers.

DTranspose the table, promote headers, then transpose back.

Step-by-Step Solution

Solution:

Step 1: Skip the first row
Use Table.Skip(Source,1) to remove the first data row.
Step 2: Promote headers
Apply Table.PromoteHeaders on the resulting table so the second row becomes headers.
Final Answer:
Use Table.Skip to skip the first row, then promote headers. -> Option C
Quick Check:
Check if headers match second row values [OK]

Quick Trick: Skip first row before promoting headers [OK]

Common Mistakes:

Promoting headers without skipping
Removing first row instead of skipping
Using transpose unnecessarily

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More Power BI Quizzes

You have a table where the first row contains data, and the second row contains the actual headers. How can you promote the second row as headers in Power Query?

Step 1: Skip the first row

Step 2: Promote headers

Final Answer:

Quick Check:

Want More Practice?