Dynamically rename column based on a mapping table

[tranpeter]

Hi,

I currently have in my database a table that looks like this:

We also have another table that provides the descriptive mapping for each generic column name. For example, CUSTOMER_ATTR_1 can be GEOGRAPHY for one customer and it can be COLOR for another customer.

When I display on PowerBI the data from the VALID_CUSTOMER_DATA.CUSTOMER_ATTR_1, I want to display CUSTOMER_INDUSTRY_ID. For CUSTOMER_ATTR_2, I want to display CUSTOMER_SALES_SEGMENT and for CUSTOMER_ATTR_3, I want to display GUIDANCE_GROUP.

Is this dynamic renaming of columns based on a mapping table doable in PowerBI?

Thank you!

-Peter

[tranpeter]

A coworker pointed me to this solution. I'll have to give it a try and update this post on whether this worked.

[v-yiruan-msft]

Hi @tranpeter  ,

Did you get it worked? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[v-yiruan-msft · Accepted solution]

Hi @tranpeter ,

You can refer the following links to rename column names dynamically:

Dynamically rename columns from a column names table

Table.RenameColumns(
Source,
List.Zip( {fOldColumnNames("TableName"), fNewColumnNames("TableName") } )
)

Using M to dynamically change column names in PowerQuery

Dynamic Column Names in Power Query

Any comment or problem, please feel free to let me know.

Best Regards