Bug: Table relationship lines working incorrectly

[FlavioMeneses]

For a few months now the model view has been unusable as the lines aren't highlighted correctly when hovered over - this is important to quickly check relationships between tables and this behaviour easily leads to mistakes.

On a similar note, perhaps related, the lines now go behind tables, adding to the confusion - I don't remember this being the behaviour of the model view in the past.

[v-xiaoyan-msft]

Hi @FlavioMeneses ,

Have you updated Power BI Desktop to the latest version? Can you tell us your version details? I did a simple test but it didn't reproduce your problem.

Best regards.
Community Support Team_Caitlyn

[FlavioMeneses]

Hi @v-xiaoyan-msft, thanks for having a look.

I'm running Version: 2.124.2028.0 64-bit (December 2023). 

This requires a model of some complexity so the effect can been seen. I've replicated it on a fresh .pbix:
https://www.dropbox.com/scl/fi/6t9futmmwxb9ki62ucrux/Model-view-test.pbix?rlkey=ox3oqwysrdd430t4910f...

You should be able to see that in some circumstances the lines will not highlight as expected:

[FlavioMeneses]

Hi, @v-xiaoyan-msft any news on this please?

[v-xiaoyan-msft]

Hi @FlavioMeneses ,

We have reported this issue and submitted it to the product team.
They have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient. 

Best regards.
Community Support Team_ Caitlyn

[FlavioMeneses]

@v-xiaoyan-msft, thank you.

[v-xiaoyan-msft]

Hi @FlavioMeneses ,

We got the feedback from PG team：

Since there are too many relationships close to each other, the svgs for the relationship-lines overlap with each other and on clicking on them, it could lead to a wrong relationship being selected. This behavior is by design.

There are alternatives to clicking on relationship-lines to select the relationship - such as using the Manage Relationship dialog to edit/create relationship or using Keyboard navigation to cycle through the relationships.

Best regards.
Community Support Team_Caitlyn

[FlavioMeneses]

@v-xiaoyan-msft thanks for the reply but I don't understand how selecting the wrong lines can be by design and what purpose that behaviour serves?

I have done further investigation and confirmed this behaviour was introduced sometime in the last year - this didn't happen before.

The following is the same data model opened on two different Power BI Desktop versions:

October 2022 version (2.110.1161.0 64-bit):

Working flawlessly, right lines selected, no tables overlapping lines.

April 2024 version (2.128.751.0 64-bit):

Random lines selected and tables going over lines, adding to the confusion.

Searching through long lists of relationships in the Manage Relationship dialog or cycling relationships with the keyboard are just not practical in large models - instead of a workaround we need to quickly and accurately be able to tell what's connected to what as before. 

This needs to be acknowledged as an item for action - I'm happy to provide further information or have a discussion with the team if needed.

Thanks,

Flavio

[FlavioMeneses]

@v-xiaoyan-msft any news on this please?

[FlavioMeneses]

@v-xiaoyan-msft I've gathered feedback from the community and dozens of people are facing the same issue, please see here:

https://www.linkedin.com/posts/flaviomeneses_question-for-power-bi-users-are-you-also-activity-71892...

Please advise, the solution is NOT delivered as marked on this thread.

[PBIPete]

This doesnt appear to be resolved and delivered as stated, it is also reported in /3379746.

With complex models lines passing behind tables makes it near impossible to use the 'Model View' - we could perhaps live with the bad selection using the relationship editor as suggested but what relationship are you looking for when you cant interpret the model?

I have also wound back my install thorugh every previous availble version to see if the problem can be resolved but unfortunately not. This bug is rendering PBI unsuable for complex models.

6 reationship lines pass behind the table in the above image and they didnt do this previously as the oringal post clearly demonstrates.

Can confirm reverting to PBI June 2023 Update corrects the file on open