Power BI auto relationships

[kevcb226]

Hi,

Is there a way to stop Power BI auto assigning relationships?

I have been trying to swap the one to many relationship between the tables, but whenever I go into the relationship manager and change it, it always seems to switch it back again!

What I need is to swap the tables round, so that vw_pbi_Pipeline_Targets_2324 is under the 'From Table' column and the vw_pbi_Pipeline_Applications_2324 under the 'To Table' column. When I edit the relationship and swap it, it appears to update and swap the tables round, but then when I close and open the relationship manager again, it reverts it back again!

I should also mention, I have changed and unticked the setting in the Options, and still it automatically assignes the relationship.

Can anyone help.

Many Thanks

[kevcb226]

Thank you @johnt75.

After looking into this in more detail, the relationships are doing what they require in my model. But for my issue, I've realised that what I require is different.

[johnt75 · Accepted solution]

The order in that window doesn't matter, its how the relationship is defined when you go into the Edit window that matters.

You can also check that it is set correctly in the diagram in the Model view.