issue with relationship between "to" and "from" table

[M-P]

I tried to setup the relationship as the example shown below.

From Table 1 to Table 2

then "Close"

Then the manage relationship screen would look correct as shown below

However After I selected "Close" the relationship table got reversed. Intead of from Table 1 to Table 2, it is now From Table 2 to Table 1 as shown below

Obviously, I must have done something wrong, any help to fix this issue would be greatly appreciated.

Thanks,

MP

[v-yuezhe-msft · Accepted solution]

Hi @M-P,

It doesn’t matter that how the tables display in the following screenshot.

When you click “Edit” button in the above screenshot, you should get a snapshot indicating that the relationship from Table 2 to Table 1 is Many to One, the relationship is same as that in your first screenshot and it doesn’t change.

Thanks,
Lydia Zhang

[Anonymous]

Power BI newbie.  Having same issue.  Any resolution ?

[M-P]

Hello. I am new with power BI, so any help here would be appreciated. perhaps there is a bug? or does it matter which direction the table is linked to or from in pwoer BI?

[v-yuezhe-msft · Accepted solution]

Hi @M-P,

It doesn’t matter that how the tables display in the following screenshot.

When you click “Edit” button in the above screenshot, you should get a snapshot indicating that the relationship from Table 2 to Table 1 is Many to One, the relationship is same as that in your first screenshot and it doesn’t change.

Thanks,
Lydia Zhang

[Dan-O]

I'm running into this issue as well, and the direction does matter. 

In my case, I'm taking a list of projects and pulling in the most recent scorecard data. I want to see all projects so I can see who hasn't completed a scorecard (record does not exist in scorecard table). When the relationship is reversed from even though the cardinality is correct, the data is cross-filtered in the wrong direction and I end up missing projects with no scorecard data.

[wave]

I agree, the direcction does matter. Do you have any solution?

Thank you

[Anonymous]

I'm having the same problem. Were you able to figure out how to fix it?

[M-P · Accepted solution]

Thanks Lydia for your help. I have used other similar database management tools in the past, and my setting for "from" and "to" relationship did not get changed automatically as Power BI, but I guess this is how Power BI works, so it is what it is.

Thanks,