Forum Discussion

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Rename tables in datamodel (PowerQuery) without impact your existing visuals/measures/calc. tables

Hello,   I thought this was a given. I just oversee another report where I need to change all complicated and long table names (names of the cloud source). The creator already finished the report ...
Need Help
Show and Tell
Tips and Tricks
  • HashamNiaz's avatar
    HashamNiaz
    5 years ago

    Hi Applicable88 !

    I have tested this multiple times directly by changing table / column names in Power Query editor for both type of calculations, complex DAX and simple DAX. 

     

    Both got changed and the measure always show the new table / column names, so it never breaks.

     

    I am using Power BI Desktip April 2021 release. May be some other community member might come up with other ideas.

     

    Regards,

    Hasham

HashamNiaz's avatar
HashamNiaz
Icon for Solution Sage rankSolution Sage
5 years ago

Hi Applicable88 !

I have tested this multiple times directly by changing table / column names in Power Query editor for both type of calculations, complex DAX and simple DAX. 

 

Both got changed and the measure always show the new table / column names, so it never breaks.

 

I am using Power BI Desktip April 2021 release. May be some other community member might come up with other ideas.

 

Regards,

Hasham

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
5 years ago

Hi HashamNiaz v-xulin-mstf , thanks for the effort. It's really mind boggling, why it only changed the "simple measures" but not the table name for example in a Sumx(Table1,..... part. 

I will update the lates powerbi. 

Best.