Skip to main content

Power BI

Under Review

Lock placement of tables in relationships pane

Vote (417) Share
Melissa Coates's profile image

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)
Melissa Coates's profile image Profile Picture

Lee Witten on 05 Jul 2020 23:39:56

RE: Lock placement of tables in relationships pane

Is there an update on this?

Melissa Coates's profile image Profile Picture

Ofeliya Sofiyeva on 05 Jul 2020 23:39:42

RE: Lock placement of tables in relationships pane

please add this simple but very useful function.

Melissa Coates's profile image Profile Picture

Brian Wisnowski on 05 Jul 2020 23:39:35

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.

Melissa Coates's profile image Profile Picture

Fred Kaffenberger on 05 Jul 2020 23:38:03

RE: Lock placement of tables in relationships pane

And in Modeling View, which has the same problem

Melissa Coates's profile image Profile Picture

Lee Witten on 05 Jul 2020 23:36:16

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).

Melissa Coates's profile image Profile Picture

Nick Brooker on 05 Jul 2020 23:34:09

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!!

Melissa Coates's profile image Profile Picture

jsp.almeida1983 on 05 Jul 2020 23:23:12

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!!!

Melissa Coates's profile image Profile Picture

Fred Kaffenberger on 05 Jul 2020 23:20:50

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

Melissa Coates's profile image Profile Picture

Zachary Goldman on 05 Jul 2020 23:18:07

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!

Melissa Coates's profile image Profile Picture

Torben Kirk Wolf on 05 Jul 2020 23:18:01

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!