Relationship Display is not saving changes

Status: Needs Info
by DQuigg Regular Visitor on ‎11-14-2017 11:11 AM

Is the relationships display in Desktop supposed to save the current position.  In other words, if I drag the hierarchy the way that I want, isn't it supposed to save it?  I seem to get constant issues where I clean up the display only to come back in and it is all hosed up.  Sometimes it seems to save it properly.  What am I missing? I had the one below all nicely laid out and then come back in later and it is all messed up per below.


Relationship Display.PNG

Status: Needs Info
by freder1ck Member
on ‎03-05-2018 12:39 PM
by dcresp Member
on ‎03-09-2018 05:24 PM

Just spent half an hour setting up my data model correctly. Fingers crossed that this is the month that this issue is resolved.

by SHOOKANSON Frequent Visitor
on ‎03-10-2018 07:55 AM

Let us know how you make out....

by pat_energetics Member
on ‎03-11-2018 06:03 PM

Auto reformat seems to be triggered on addition of any new table to the data model.


The option to turn off this autoformat is required urgently.

by kcantor Super Contributor
on ‎03-12-2018 11:27 AM


Mine wasn't a new table. It was editing the query of an existing table. I have disabled detect relationships and other options. today, I opened a small pbix that I had removed duplicates from due to importing from a web page. The data layout was hosed.  This is very frustrating. 

Even more frustrating is the lack of admitting this is an issue on Microsoft's part.

by dcresp Member
on ‎03-15-2018 03:12 AM

No luck. The March release of PBI Desktop has not solved this issue. However, I think I am closer to finding a trigger. It seemed to happen when PBI and in particular the background SQLAS is using high levels of memory and processor. Possibly trying to save the PBI file around this time could be a trigger. Still can't replicate it but this seemed to be the trigger. 

by freder1ck Member
on ‎03-15-2018 09:49 AM

hmm. If the issue is related to saving the file, then autosave could be responsible for some of the intermittent/ hard to repro issues...

by dcresp Member
on ‎03-22-2018 06:32 AM

Grr just happened again. Nothing occurring around when it happened that I can put my finger on. 

by dcresp Member
on ‎03-23-2018 07:51 AM

I just had it happen again. I was using DAX Studio when it occurred. Has anyone else been using DAX Studio when the reset has happened?

by pat_energetics Member
on ‎03-25-2018 06:51 PM

Dax studio not a factor for me. The layout gets nuked for me anytime I'm making significant changes to the queries, Its like something in the background checking the relationships between tables, even though the automatic relationship is turned off..... 

Idea Statuses