Melissa Coates on 30 Nov 2017 02:01:31
The ability to 'lock' where tables are manually placed on the relationships pane would be very helpful. We have created a data model with security tables, secured dimensions, unsecured dimensions, and secured fact tables. When I lay out the tables in a specific way, the design is far more understandable than when placement is auto-generated. A 'lock' type of functionality to 'freeze' the table layout would be very helpful because I can more easily locate/verify (a) specific types of tables, (b) bidirectional relationships where they should be (and shouldn't be), and (c) relationship directions are accurate.
Administrator on 01 Feb 2018 08:47:24
Thanks for submitting. We are looking to make some improvements in this area.
- Comments (32)
RE: Lock placement of tables in relationships pane
That is good news Amir. At the moment my workaround for this is to take a screenshot of my good layout, print it off and write on the paper(!) - otherwise when it resets I'm lost in a jungle of relationships. I'm getting really desperate for a fix (that sounds all wrong :p)
RE: Lock placement of tables in relationships pane
OK folks. We hear you and we have work on going to dramatically improve the modeling diagram experience. This will also include making sure that the tables don't move on you by themselves.
RE: Lock placement of tables in relationships pane
If this will solve this issue please bring it on asap. https://community.powerbi.com/t5/Issues/Relationship-Display-is-not-saving-changes/idi-p/303123
RE: Lock placement of tables in relationships pane
"Under review"?! This is clearly a issue that should be sorted asap, not an idea that could be implemented at some point. It is something wrong with the core functionality of the relationships view. See the link to the issue below that was posted in November 2017. Really annoying.
RE: Lock placement of tables in relationships pane
Just wasted another two hours reformatting the relationship view after addition of a new table triggered an autoformat. Please give us the option to lock this view down. An update on any progress since 1 Feb would be appreciated, as it doesn't appear to be resolved in the March update.
RE: Lock placement of tables in relationships pane
Please fix this.
RE: Lock placement of tables in relationships pane
This is a really major bug currently in Power BI and hopefully will get a solution soon. The diagrams resetting themselves is the only something that recently started to occur and is really frustrating. Please MS fix this soon.
RE: Lock placement of tables in relationships pane
Very frustrating when you have more than 5 facts and 30 some dimensions...it literally takes me an hour to redo it every time it changes.
RE: Lock placement of tables in relationships pane
There's also an issue for this. Currently, looking to reproduce the issue of auto-arrangement.
https://community.powerbi.com/t5/Issues/Relationship-Display-is-not-saving-changes/idi-p/303123
RE: Lock placement of tables in relationships pane
This is slowly doing my head in, can this be given some attention? I like my dimensions at the top and my fact tables at the bottom and I want that to ALWAYS stay the way i left it. Thank you.