Skip to main content

How to Rename a Column in Power Query

· 4 min read
Jagdish Kumawat
Founder @ Dewiride

Column names from a data source aren't always the names you want people to see. Every SharePoint list, for example, has a Title column, whatever it holds. Renaming it in Power Query gives the model and every report a clearer name. Here's how.

Microsoft's Rename columns shows the ways to rename a column in Power Query. The example renames the Title column of an Expenses query, which holds each expense's description, to Expense (How to Get Data from a SharePoint List in Power BI in the Browser).

Step 1: Select Rename​

Right-click the column's header and select Rename...:

The shortcut menu of the Title column header, from Copy preview data and Remove columns to Group by and the Unpivot options, with Rename... outlined in red near the bottom, above Resize..., Move, Drill down and Add as new query

Step 2: Type the New Name​

The header becomes a text box with the old name selected. Type the new name, here Expense:

The Expenses query with the first column's header being edited, showing the text Expen as the new name is typed, over the rows Train ticket, Hotel room, Printer ink, Taxi and Client dinner

Press Enter.

Step 3: Check the Result​

The header reads Expense, and Applied steps gains Renamed columns:

Renamed columns
Table.RenameColumns(#"Changed column type", {{"Title", "Expense"}})
  • #"Changed column type" is the step before.
  • {{"Title", "Expense"}} pairs each old name with its new one; a step that renames several columns has one pair for each.

The Expenses query with the first column now named Expense, a Table.RenameColumns formula that renames Title to Expense, and the Renamed columns step outlined in red under Applied steps

Common Mistakes​

MistakeWhat happensDo this instead
Keeping SharePoint's Title nameReports say Title for whatever the column holdsRename it to what it holds
Renaming the same column in every reportEach report needs the change againRename it once in Power Query
Giving two columns the same nameMicrosoft's article says Power Query shows a Column Name Conflict errorA unique name for every column

Troubleshooting​

SymptomLikely causeFix
A shortcut menu without Rename...The right-click landed on a cellRight-click the column's header
Column Name ConflictAnother column already has the nameChoose another name
A later step shows an errorIt refers to the column's old nameRename after that step, or change the step to the new name

FAQ​

Is there a faster way?​

Microsoft's Rename columns lists two more ways: double-click the header, or select Rename in the Any column group of the Transform tab.

Can I rename a column only in one visual?​

Yes, a report can show a different name in one visual without changing the model (How to Rename a Field in One Power BI Visual).

Conclusion​

Right-click the header, Rename..., type the name, Enter. Power Query adds a Table.RenameColumns step; the example turned Title into Expense.

Additional Resources​