Skip to main content

How to Rename a Query in Power Query

· 3 min read
Jagdish Kumawat
Founder @ Dewiride

A query's name becomes the name of its table in the semantic model, and every report shows it. A copied query called Expense Categories (2) says nothing about what it holds. Here's how to rename a query in Power Query.

The example renames Expense Categories (2), a copy of the Expense Categories query (How to Duplicate a Query in Power Query), to Category managers, because it will hold one row per category manager.

Step 1: Select Rename​

Under Queries, right-click the query and select Rename:

The shortcut menu of the Expense Categories (2) query under Queries [3], with Rename outlined in red below Copy, Paste and Delete

Step 2: Type the New Name​

The name becomes a text box. Type the new name, here Category managers, and press Enter:

The Queries pane with the third query's name being edited as Category managers, below Expense Categories and Expenses

Step 3: Check the Result​

The query is now Category managers under Queries and in Name under Properties in Query settings. Renaming a query doesn't add a step: Applied steps still shows Source and Navigation 1.

Queries [3] with Expense Categories, Expenses and Category managers selected, and Query settings showing the Name Category managers and the Applied steps Source and Navigation 1

The Name box in Query settings does the same job: select it, type the name and press Enter.

Common Mistakes​

MistakeWhat happensDo this instead
Leaving (2) in a copy's nameThe model gets a table no one can identifyRename the copy at once
Naming a query after its source rather than its contentTwo tables from one list look alikeName it after what each row is
Renaming tables after building reportsMeasures and visuals that use the table need checkingName queries before building on them

Troubleshooting​

SymptomLikely causeFix
The name doesn't changeEnter wasn't pressedType the name again and press Enter
The new name is rejectedAnother query already has itChoose a name no other query uses

FAQ​

Is the query name the table name in Power BI?​

Yes: each query that loads becomes a table of the same name in the semantic model.

Can I rename a column the same way?​

Columns are renamed from their header (How to Rename a Column in Power Query).

Conclusion​

Right-click the query, Rename, type the name, Enter, or use Name in Query settings. The example's copy became Category managers, the name its table will have in the model.

Additional Resources​