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 (31)
RE: Lock placement of tables in relationships pane
please add this simple but very useful function.
RE: Lock placement of tables in relationships pane
Very frustrating to organize two dozen tables with nearly 100 relationships only to have them revert back to a hodgepodge of nonsense upon close.
RE: Lock placement of tables in relationships pane
And in Modeling View, which has the same problem
RE: Lock placement of tables in relationships pane
Oh come on! please do something to stop it re-arranging the relationship diagram - it's not even if it improves it in anyway shape of form.
Getting really annoying now as my model is growing and don't have time to waste having to keep arranging it all (also see other request(s) for some sort of snap to grid would be nice).
RE: Lock placement of tables in relationships pane
Please do something here!
I sort my tables > Save > Close .... Re-open my .pbix and it's vomited them into it's own unhelpful order.
Please help! Some sort of Grouping or Fences would be awesome!!
RE: Lock placement of tables in relationships pane
Admin, please try to expedite it because it is really a pain in the ass every time we have to organize all over again. I assure to you this is pretty bad and take an important time frame from us!!!
RE: Lock placement of tables in relationships pane
So, this roadmap item looks related...
July – September ’18 – Public Preview Power BI Desktop • Model diagram and navigation – An improved modeling experience that scales to large and complex data models with many tables, calculations, and other objects.
http://download.microsoft.com/download/F/9/5/F955B25B-A706-4962-9BAC-0DD7F054EFE9/BusinessApps_ReleaseNotes_v18.1.2.pdf
RE: Lock placement of tables in relationships pane
Yes! This is super-frustrating and time consuming to have to re-arrange all of my tables every time I need to look at or modify the schema!
RE: Lock placement of tables in relationships pane
When creating large models, keeping track of the facts and dimensions is almost a discipline in itself. If the diagram gets scrambled (as I have just experienced on a large model), it takes a lot of effort to recreate it. Please look into fixing this issue. This is a core functionality, which is not stable. This doesn't fly well when I have to try to convince management to implement Power BI on a grand scale in the organisation - the program simply doesn't seem mature enough to be used in production!
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)