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!