Header promotion in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does Header promotion mean in Power BI?

Header promotion means turning the first row of data into column headers so the table has meaningful column names.

beginner

Why is header promotion important in Power BI?

It helps make data easier to understand and use by giving columns clear names instead of generic ones like Column1, Column2.

beginner

How do you promote headers in Power BI's Power Query Editor?

You click the Use First Row as Headers button in the Home tab of Power Query Editor.

beginner

What happens if you don't promote headers when needed?

Your columns will have default names like Column1, Column2, making it hard to understand and analyze the data.

beginner

Can you undo header promotion in Power Query?

Yes, you can remove the step from the Applied Steps pane to revert to the original data.

What does the 'Use First Row as Headers' button do in Power Query?

A Sorts the data alphabetically

B Deletes the first row of data

C Filters out empty rows

D Turns the first row into column headers

The button promotes the first row to be the column headers, giving meaningful names to columns.

If you forget to promote headers, what will your columns be named by default?

A The first row values

B Column1, Column2, etc.

C Empty

D Numbers from the first column

Without header promotion, Power Query assigns generic names like Column1, Column2.

Where do you find the 'Use First Row as Headers' option in Power BI?

A Home tab in Power Query Editor

B Model view

C Report view

D Data view

Header promotion is done in Power Query Editor under the Home tab.

Can you reverse header promotion after applying it?

A Yes, by removing the step in Applied Steps

B Only by restarting Power BI

C Only by reloading the data

D No, it is permanent

You can undo header promotion by deleting the step in the Applied Steps pane.

Why should you promote headers before doing data analysis?

A To reduce file size

B To speed up data refresh

C To make columns easier to identify and use

D To hide sensitive data

Promoting headers gives columns meaningful names, making analysis clearer and easier.

Explain what header promotion is and why it is useful in Power BI.

Think about how column names help you understand data.

Describe the steps to promote headers in Power Query Editor.

Look in the Home tab of Power Query Editor.

Practice

1. What does header promotion do in Power BI's Power Query Editor?

easy

A. It removes all empty rows from the data.

B. It turns the first data row into column headers.

C. It filters data based on header names.

D. It merges two tables based on headers.

Solution

1. Step 1: Understand header promotion concept

   Header promotion means using the first row of data as the column headers instead of default generic headers.

2. Step 2: Recognize its use in Power Query

   Power Query's Table.PromoteHeaders function performs this action to make data easier to read and analyze.

3. Final Answer:

   It turns the first data row into column headers. -> Option B

4. Quick Check:

   Header promotion = first row becomes headers [OK]

Hint: Remember: header promotion swaps first row to headers [OK]

Common Mistakes:

• Confusing header promotion with filtering rows
• Thinking it deletes the first row instead of promoting it
• Assuming it merges tables automatically

2. Which of the following is the correct syntax to promote headers in Power Query M language?

easy

A. Table.Promote(SourceHeaders)

B. PromoteHeaders(Table)

C. Source.PromoteHeaders()

D. Table.PromoteHeaders(Source)

Solution

1. Step 1: Recall Power Query function names

   The correct function to promote headers is Table.PromoteHeaders, which takes a table as input.

2. Step 2: Match syntax with options

   Table.PromoteHeaders(Source) uses the correct function and syntax: Table.PromoteHeaders(Source). Other options are invalid or incorrect syntax.

3. Final Answer:

   Table.PromoteHeaders(Source) -> Option D

4. Quick Check:

   Correct function name and syntax = Table.PromoteHeaders(Source) [OK]

Hint: Function starts with Table.PromoteHeaders and takes table input [OK]

Common Mistakes:

• Using incorrect function names like PromoteHeaders alone
• Calling promote headers as a method on source
• Mixing parameter order or names

3. Given this Power Query M code snippet:

let
  Source = Table.FromRows({{"Name", "Age"}, {"Alice", 30}, {"Bob", 25}}),
  Promoted = Table.PromoteHeaders(Source)
in
  Promoted

What will be the column headers of the resulting table?

medium

A. ["Alice", 30]

B. ["Column1", "Column2"]

C. ["Name", "Age"]

D. ["Bob", 25]

Solution

1. Step 1: Analyze the initial table rows

   The first row is {"Name", "Age"}, which looks like header names, followed by data rows.

2. Step 2: Understand effect of Table.PromoteHeaders

   This function uses the first row as column headers, so the columns become "Name" and "Age".

3. Final Answer:

   ["Name", "Age"] -> Option C

4. Quick Check:

   First row becomes headers = ["Name", "Age"] [OK]

Hint: First row values become headers after promotion [OK]

Common Mistakes:

• Thinking default headers remain after promotion
• Confusing data rows as headers
• Assuming column names are generic like Column1

4. You applied Table.PromoteHeaders but got an error saying "Expression.Error: The column 'Name' of the table wasn't found." What is the most likely cause?

medium

A. The first row does not contain valid header names.

B. The data types of columns are incompatible.

C. You used the wrong function name.

D. The table is empty with no rows.

Solution

1. Step 1: Understand error context

   The error "The column 'Name' of the table wasn't found" occurs when code tries to reference [Name] after promotion, but the column doesn't exist.

2. Step 2: Identify promotion effect

   Table.PromoteHeaders sets column names from the first row's values. If 'Name' is missing from the first row, no 'Name' column is created.

3. Final Answer:

   The first row does not contain valid header names. -> Option A

4. Quick Check:

   First row lacks expected header 'Name' [OK]

Hint: Ensure first row contains expected header names like 'Name' [OK]

Common Mistakes:

• Thinking empty table causes this specific column error (promotion fails differently)
• Blaming data types (causes type errors, not missing columns)
• Assuming wrong function (causes syntax error)

5. You imported a CSV file where the first two rows contain metadata, and the third row has actual headers. How do you promote the correct headers in Power Query?

hard

A. Remove the first two rows, then apply Table.PromoteHeaders.

B. Apply Table.PromoteHeaders directly on the original table.

C. Rename columns manually without removing rows.

D. Use Table.Skip to skip the third row, then promote headers.

Solution

1. Step 1: Remove unwanted metadata rows

   The first two rows are metadata, so remove them using Table.Skip(Source, 2) to start from the third row.

2. Step 2: Promote the third row as headers

   After removing the first two rows, apply Table.PromoteHeaders to use the third row as headers.

3. Final Answer:

   Remove the first two rows, then apply Table.PromoteHeaders. -> Option A

4. Quick Check:

   Skip metadata rows before promoting headers [OK]

Hint: Skip metadata rows first, then promote headers [OK]

Common Mistakes:

• Promoting headers without removing metadata rows
• Skipping wrong number of rows
• Renaming columns manually instead of promoting