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 !

When you change a table name or column name using Power Query editor, and Close & Apply changes, measure will automatically picks up the name table name & column name. You can see the measure DAX accomodates the new changes.

 

We didn't know what you mean by deactivate measure, is it like incorrect DAX comming for measure.

 

Regards,

Hasham

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

Hello HashamNiaz,

by "deactiveated" I mean they get a warning side in the dax editor, since they cannot find the table anymore.

 

You have to types of column references : 

1. is full qualified and 2. simple, like this:

First version: sumx( 'Tablename', 'Tablename' [Sales])

and

Second version: sum('Tablename'[Sales]) can actually be written even simpler: sum([Sales])

 

When I change table name in powerquery the tablename got change for not qualified ones like number two. But for sumx for example only the second part got renamed automatically , the first part of 'Tablename' didn't change after applying the changes.

 

 

 

  • 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.