Power BI: How to Use First Row as Header


Often you may want to use the first row as the header of a table in Power BI.

Fortunately this is easy to do by using the Use First Row as Headers function in the Power Query Editor.

The following example shows how to use this function in practice.

Example: How to Use First Row as Header in Power BI

Suppose we have the following table in Power BI named my_data that contains information about the first, middle and last names of various people:

Upon importing the data into Power BI, the column headers were supposed to be as follows:

  • First, Middle, Last

Unfortunately, these column headers were used as the first row in the table and the following names were used for the column headers instead:

  • Column1, Column2, Column3

To use the first row as the headers, click the Transform data icon on the Home tab:

This will bring up the Power Query Editor.

Click the icon named Use First Row as Headers in the Transform group:

Power BI use first row as header

This will cause the first row of the table to be used as the header row:

Once you exit out of the Power Query Editor, a message will appear that asks if you’d like to apply your changes.

Once you click Yes, the first row will be used as headers in the original table:

Additional Resources

The following tutorials explain how to perform other common tasks in Power BI:

How to Remove Column Headers in Table in Power BI
How to Count Number of Occurrences in Power BI
How to Write an IF Statement in Power BI

Leave a Reply

Your email address will not be published. Required fields are marked *