Forum Discussion
Advocate ISimple Way to Handle Column Renames in Power BI?
Hey,
I think it should be enough if you add a step in power query to rename the columns using the mapping table, you should try to add this step
= Table.RenameColumns(PreviousStep, List.Zip({MappingTable[OldColumnName], MappingTable[NewColumnName]}), MissingField.Ignore)I created an example PBIX file for you (attacched). Feel free to check it out.
Advocate II have a Power BI solution with reports connected to Databricks tables.
The backend team is planning to change the naming conventions, meaning all table and column names will be updated.
This will cause issues in the frontend (visuals, measures, and applied filters will break).
I already have mapping tables for all the changes.
Is there a way to apply these changes automatically to my reports, for example with a script that updates everything?
Thanks in advance!
Super UserHi Nazdac2024 ,
there isn’t a built-in “auto rename” feature in Power BI, but there are some ways to handle this:
Power BI External Tools – tools like Tabular Editor or ALM Toolkit let you script bulk changes across your model (rename tables/columns using your mapping).
Script with TOM (Tabular Object Model) – you can write a small C#/PowerShell script with TOM API to loop through fields and apply your mapping automatically.
Power Query – in some cases, apply renaming at the query step (using the mapping table), so visuals still see the “old names” even if backend changes.
Docs: Tabular Editor – Best Practice for renaming
👉 This avoids manually fixing every visual.
If this helps, please mark it as a solution ✅
— Nabha Ahmed (connect with me on https://www.linkedin.com/in/nabha-ahmed-166491221?utm_source=share&utm_campaign=share_via&utm_content=profile&utm_medium=ios_app(