Forum Discussion
Nazdac2024
Advocate I
Advocate ISimple 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...
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.
Nazdac2024Advocate I
Advocate IHi all
Thanks a alot for fast help , I just added this not :
Note: I want the visuals and semantic model to display the new column names.
Sorry for the incomlete data 🙂
Regards