Forum Discussion
Power BI auto relationships
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
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.
2 Replies
johnt75Super User
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.
