NEW! FREE 45 Minutes Excel VBA Loop Course for Beginners Watch now 

Power BITutorials

Learn How to Rename A Column Using Power Query

1 Mins read

One of the important and most needed features of Power Query is the Renaming Column Headers. Many people facing issues to rename column names using Power Query. We show you step by step process, how you can rename a column in Power Query very easily. To get in-depth knowledge related to Power Query and its Tips & Tricks then check our self paced Power Query Training with certification.  

Rename A Column With Power Query

Let’s observe the below steps to rename column headers-


Step 1: Load Data in Power Query

When you load the data in Power Query, you will observe that the column headers are named as Column1, Column2 etc. The original column headers are placed in the first row as shown in the below picture. Therefore, we need to change the position of these column headers.


Step 2: Use First Row as Headers

To use the first row as headers in Power Query, go to-

Transform  >  Use First Row as Headers  >  Use First Row as Headers option


Step 3: Close & Apply

As you can see in the below picture, the column headers are changed to the original column names. You can now click on the Close & Apply button to save the changes.



You can learn more :

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…