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.

     

AbdulhadiNL2025's avatar
AbdulhadiNL2025
Regular Visitor
1 year ago

Is this going to update also colmun names in measures and visuals , so they will not collapse? 

Gabry's avatar
Gabry
Icon for Super User rankSuper User
1 year ago

Nope, the goal is to take the new column names from the source and rename them back to the old ones, so nothing breaks.
(To avoid breaking the query, a step needs to be added in PQ. However, the column names in the report will remain unchanged)