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:
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
