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.

     

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

Hi Nazdac2024  You can solve this issue with help of TMDL view. 

Step 1: Open TMDL window

Step 2: Bring your data table (which one causing issue) in the TMDL view

Step 3: Here, our gole is to not change column name, we need to update only sourceColumn 

Step 4: Now copy the TMDL script and give it to any gpt. also, share your mapping column data. and asked to only update sourceColumn name based on column name. 

Step 5: Pest your updated TMDL script here and click apply. 

Now, all your visual, measure will remain same with updated source column name. 

 

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!