Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamic Column Header change as per Lookup table

Hi ,

I have a fact table and one lookup table. I am trying to change the Column name of Fact table based on Lookup table. Using power query, it is changing perfectly. 

 

I am using table visual/graph with the column name from FACT table. If any name change in lookup table, the visual and PBI break. Is it any way to achieve this task.


Regrads,

 

Nikhil

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Unfortunately Power BI doesn't take kindly to meta data changes.  It's even worse in the service.

     

    Find another way to accomplish your goal.  Leave the column names alone.