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

julienvdc's avatar
julienvdc
Icon for Helper III rankHelper III
4 years ago

Hey I think name changes work if the datamodel is within the report you're working on.

 

I am facing the same issue when I am working on a report that sources an already loaded and shared datamodel. If we change some table name in the datamodel, then any report using that datamodel will break on visuals that use those tables as they won't find the tables anymore (due to name change).

  • Mrtnkbg's avatar
    Mrtnkbg
    Icon for Advocate I rankAdvocate I
    3 years ago

    This was a piece of really important information, thanks for sharing.