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.

     

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

- Use your mapping table to automate renames instead of fixing everything manually.
- In Power Query, dynamically rename columns using the mapping table before loading data.
- In the model (measures/visuals), use tools like Tabular Editor to bulk rename columns based on your mapping—this avoids breaking visuals.
- Avoid manual edits in visuals or measures, as that’s error-prone and slow.