Forum Discussion

mkaffo's avatar
mkaffo
New Member
8 years ago
Solved

Dynamically Add titles to columns

Hi,   I am looking to dynamically add titles to column headers, specified by user.    I have a data sheet (excel) where there are several columns titled, class level 1-10. This is imported into P...
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI mkaffo,

     

    AFAK, power query not support auto update column names.
    Original table structure will cached in power query steps, if you modify original source, power bi will return error for it can't find the specific columns.

     

    In my opinion, I'd like to suggest you create specific table to store column names, them you can follow below MarcelBeug's solution to dynamic generate column name.

    Dynamic column name from its value

     

    Regards,

    Xiaoxin Sheng

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI mkaffo,

 

AFAK, power query not support auto update column names.
Original table structure will cached in power query steps, if you modify original source, power bi will return error for it can't find the specific columns.

 

In my opinion, I'd like to suggest you create specific table to store column names, them you can follow below MarcelBeug's solution to dynamic generate column name.

Dynamic column name from its value

 

Regards,

Xiaoxin Sheng