Skip to main content

Power BI

Under Review

Lock placement of tables in relationships pane

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

7626f6c5 de91-4681-906f-cada2e951c5e 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

979d1159 b42d-4e0d-86f3-9060b4607409 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

eda8537f 7f8c-4964-b4e8-58dde79ed6d0 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

d672f0ef 6f18-4966-ac0d-bf9cd2e8e2a8 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

9f266073 433e-4d8d-9c75-ad79a71ca27a 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

a7cf508c 55df-411e-9408-b548973bc6cb 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!

Melissa Coates's profile image Profile Picture

9ec28151 9abe-4e8d-aea4-e90a574edf9b on 05 Jul 2020 23:41:39

RE: Lock placement of tables in relationships pane

Please!! pay attention to this improvement urgently!

Melissa Coates's profile image Profile Picture

153aa35f d0c0-490c-9ffd-8de708af95c2 on 05 Jul 2020 23:41:39

RE: Lock placement of tables in relationships pane

Nice! Voted!

Melissa Coates's profile image Profile Picture

3ded7bb6 df7e-441a-af84-6d97b6ec9e7d 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.

Melissa Coates's profile image Profile Picture

35e1b385 4be1-4c18-96cb-051af92b5ea7 on 05 Jul 2020 23:39:56

RE: Lock placement of tables in relationships pane

Is there an update on this?