Forum Discussion

Nazdac2024's avatar
Nazdac2024
Advocate I
11 months 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
    11 months 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.

     

Gabry's avatar
Gabry
Super User
11 months 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
11 months ago

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

  • Gabry's avatar
    Gabry
    Super User
    11 months 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)