PBI Desktop freezes when i try to change a table name in the query editor

[Ghuiles]

Hello

When i try to rename a table in the query editor, PBI freezes.

I suspect it comes while afterwards i am summarizing tables in DAX.

I am using the latest Version: 2.66.5376.1681 64-bit (Februar 2019)

The steps:

1 in the query editor i right click to rename the table (no special character). 

2 i validate the new name (Enter)

3 Close % apply

4 Get the error message below 

Why this error? How to avoid it?

BR, G.

[Ghuiles]

Hello!

I think i found a workaround.

Basically, in my model, i later on summarize the tables in DAX.

If i "pause" this summarization with commenting the function (/*) then i am able to change the table's name in Power Query, and afterwards to update the Summarize function.

Pity that i need this workaround, and i lost some time to find this out.

BR, G.

[v-yuezhe-msft]

@Ghuiles ,

Based on the above error message, there is a issue about the relationship between HFM FACT table and another table. Do you create relationship using Date column of HFM FACT table and delete the date column later? If so, you would need to delete the relationship.

Regards,
Lydia

[nedpbi]

@GhuilesI am facing the same issue but was not clear on how you paused this. I am doing a union of all my tables in DAX. When I try to rename some of the tables I get the same error above on relationship deleted etc. Appreciate if you could elaborate on your solution.

Thanks !

[Ghuiles]

Hi!

My problem was old.

My understanding is that basically Power BI does not like when we:

1. Create tables in Power Query

2. Create some link between these tables with DAX (e.g. functions summarize, union, etc)

3. Change the tables back in Power Query

My solution for this was:

1st temporarly deactivate the connections done with DAX

2nd rename the tables in PQ are wished

3rd reactivate the connections in DAX, while taking care the names used for the tables are the new names.

I hope this helps

Cheers

Gilles

[nedpbi]

Thank you @Ghuiles for getting back this was helpful ! I deleted all the relationships in my model and was able to rename the tables and had to recreate the relationships. Tedious but worked, thank you again !