Forum Discussion

Nazdac2024's avatar
Nazdac2024
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Simple Way to Handle Column Renames in Power BI?

Hi all, I asked something similar before but the answers were a bit too advanced for me, so I’ll try to explain it in a simpler way. I have an Excel file imported into Power BI. In Power Query I a...
Need Help
Show and Tell
  • Gabry's avatar
    Gabry
    1 year ago

    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.

     

Nazdac2024's avatar
Nazdac2024
Icon for Advocate I rankAdvocate I
1 year ago

I 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!

 

Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
1 year ago

To automate Power BI updates after Databricks renaming:
- Use Tabular Editor or TOM scripting to rename tables/columns in your model using your mapping table.
- Validate broken visuals/measures post-renaming.
- Deploy updated PBIX via Power BI REST API or Power Automate.
- For future-proofing, connect Power BI to stable views in Databricks instead of raw tables.