Header promotion in Power BI - Step-by-Step Guide

Introduction

Header promotion changes the first row of your data into column headers. This helps when your data source has headers as the first row but Power BI treats them as data. It makes your table easier to read and use.

When your imported table shows the first row as data instead of column names

When you want to clean up data from Excel or CSV files that have headers in the first row

When you need to rename columns quickly using the first row values

When you want to prepare data for analysis and need proper column labels

When you want to avoid manually renaming each column after import

Steps

Step 1: Open

- Power Query Editor

Your data table appears with the first row still as data, not headers

Step 2: Click

- Home tab in Power Query Editor

Home tab options are visible

Step 3: Click

- Use First Row as Headers button in the Home tab

The first row of data becomes the column headers

Step 4: Check

- Data preview

Column headers now show the original first row values, and that row is removed from data

Step 5: Click

- Close & Apply button in Home tab

Changes are saved and data loads with new headers into Power BI

Before vs After

Before

Table shows columns named Column1, Column2, Column3 with the first row containing header names like Date, Sales, Region

After

Table shows columns named Date, Sales, Region with the first row removed from data

Settings Reference

Use First Row as Headers

📍 Home tab in Power Query Editor

Promotes the first row of data to be column headers

Default: Not applied

Common Mistakes

Clicking 'Use First Row as Headers' when the first row is not actually headers

This will promote wrong data as headers, causing confusion and errors

Verify the first row contains header names before promoting it

Not applying changes after promotion

Your data will not update in Power BI and old headers remain

Always click 'Close & Apply' to save changes

Summary

Header promotion changes the first row of data into column headers for clarity.

Use this when your data source has headers as the first row but Power BI treats them as data.

Always verify the first row contains headers before promoting to avoid errors.