Skip to main content




Let's see how to rename columns in Power BI Desktop with an example. Generally, when you load data from a data source, you get the column names that are available from a data source. As you design your report, you may need more meaningful names. In these situations, you can use the Power BI column renaming option.

How to rename columns in Power BI

To demonstrate this option to Rename column names, we are going to use the Text Employee table that we imported in Enter Data and modified in the split column article.

To rename the columns in an existing table, click the Edit queries option under the Home tongue.

how-to-rename-column-names-in-power-bi-1-8334993

Clicking Edit queries The option opens a new window called Power BI Power Query Editor. In the screenshot below, you can see that the columns in this table have a common name.

how-to-rename-column-names-in-power-bi-2-8206724

There are a couple of ways to rename columns in Power BI table report

To rename columns in a table, right-click the column you want to change to open the context menu. Please select the Rename option.

how-to-rename-column-names-in-power-bi-15-1630833

Allows you to change the name of the column. Let me rename it to EmpID.

how-to-rename-column-names-in-power-bi-4-4320558

Now you can see the column named EmpID

how-to-rename-column-names-in-power-bi-5-1084067

Alternatively, you can double-click on the column header.

how-to-rename-column-names-in-power-bi-6-8789481

As you can see, we renamed it as Name

how-to-rename-column-names-in-power-bi-7-7856496

Similarly, we rename the remaining columns

how-to-rename-column-names-in-power-bi-8-6903357

Whatever changes you've made, they won't affect you until you hit Apply. Let me hit the Close and apply option under the Home tongue.

how-to-rename-column-names-in-power-bi-9-3478593

Please wait until the changes are applied

how-to-rename-column-names-in-power-bi-10-1660210

Now you can see the most significant names

how-to-rename-column-names-in-power-bi-11-4461211




Let's see how to rename columns in Power BI Desktop with an example. Generally, when you load data from a data source, you get the column names that are available from a data source. As you design your report, you may need more meaningful names. In these situations, you can use the Power BI column renaming option.

How to rename columns in Power BI

To demonstrate this option to Rename column names, we are going to use the Text Employee table that we imported in Enter Data and modified in the split column article.

To rename the columns in an existing table, click the Edit queries option under the Home tongue.

how-to-rename-column-names-in-power-bi-1-8334993

Clicking Edit queries The option opens a new window called Power BI Power Query Editor. In the screenshot below, you can see that the columns in this table have a common name.

how-to-rename-column-names-in-power-bi-2-8206724

There are a couple of ways to rename columns in Power BI table report

To rename columns in a table, right-click the column you want to change to open the context menu. Please select the Rename option.

how-to-rename-column-names-in-power-bi-15-1630833

Allows you to change the name of the column. Let me rename it to EmpID.

how-to-rename-column-names-in-power-bi-4-4320558

Now you can see the column named EmpID

how-to-rename-column-names-in-power-bi-5-1084067

Alternatively, you can double-click on the column header.

how-to-rename-column-names-in-power-bi-6-8789481

As you can see, we renamed it as Name

how-to-rename-column-names-in-power-bi-7-7856496

Similarly, we rename the remaining columns

how-to-rename-column-names-in-power-bi-8-6903357

Whatever changes you've made, they won't affect you until you hit Apply. Let me hit the Close and apply option under the Home tongue.

how-to-rename-column-names-in-power-bi-9-8007635

Please wait until the changes are applied

how-to-rename-column-names-in-power-bi-10-1660210

Now you can see the most significant names

how-to-rename-column-names-in-power-bi-11-3015545
R Marketing Digital