Skip to main content
Microsoft Idea

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

Jensine Raine on 24 Nov 2021 15:17:13

RE: Lock placement of tables in relationships pane

Hello - I can echo all of the frustration from prior posts. It is now almost 4 years since the original idea was submitted. Was there ever any work done to resolve this issue?

Melissa Coates's profile image Profile Picture

Anton Hugo Mueller on 06 Jul 2020 00:16:14

RE: Lock placement of tables in relationships pane

any update? the initial post is almost 3 years old and it's REALLY annoying ...

Melissa Coates's profile image Profile Picture

mister x on 06 Jul 2020 00:08:38

RE: Lock placement of tables in relationships pane

everything is ´to be done´, lot of missing features. M$ is really doing a poor job in this area

Melissa Coates's profile image Profile Picture

Shweta Sharma on 06 Jul 2020 00:07:22

RE: Lock placement of tables in relationships pane

Hi, It would really be of great help to have this feature specially when you need to work with big data.

Melissa Coates's profile image Profile Picture

Power BI User on 05 Jul 2020 23:58:25

RE: Lock placement of tables in relationships pane

Very bad for my OCD !!!! and also useful as when i have it structured i can see the patterns but when its auto arrange frankly its a mess and can see nothing its useless..... we need the feature to lock the tables please

Melissa Coates's profile image Profile Picture

Steve Honey on 05 Jul 2020 23:48:40

RE: Lock placement of tables in relationships pane

How is this still not fixed?? Seriously nothingyou have 'improved' in the relationships view functionality is actually better. Rolling back to how it functioned in Oct 18 would be better than the current state.

Melissa Coates's profile image Profile Picture

Power BI User on 05 Jul 2020 23:48:32

RE: Lock placement of tables in relationships pane

I completely agree and this issue has become even worse with the new model/relationship view that was released. I really dislike the new view. When I close and re-open a power bi desktop file, my tiles are microscopic and the model is completely re-arranged. The tiles are so microscopic I can't even see them. I have to zoom way in just to be able to grab them and move them back, but they are spaced so way far out I am scrolling forever just to drag and drop all of the tiles to the other end of my screen and then repeat the process over and over. It's a ridiculous waste of time. It's so frustrating!

RE: Lock placement of tables in relationships pane

Please!! pay attention to this improvement urgently!

Melissa Coates's profile image Profile Picture

Luis Gustavo Serra on 05 Jul 2020 23:41:39

RE: Lock placement of tables in relationships pane

Nice! Voted!

Melissa Coates's profile image Profile Picture

Jesse on 05 Jul 2020 23:40:44

RE: Lock placement of tables in relationships pane

It's very difficult to monitor/maintain relational integrity when the relationship diagram keeps scrambling. It helps greatly when I take the time to organize the table placement on the page, however that effort is wasted if it just re-scrambles everything.