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.

     

v-venuppu's avatar
v-venuppu
Icon for Community Support rankCommunity Support
1 year ago

Hi Nazdac2024 ,

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.