Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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,
Power BI newbie. Having same issue. Any resolution ?
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?
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
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.
I agree, the direcction does matter. Do you have any solution?
Thank you
I'm having the same problem. Were you able to figure out how to fix it?
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,
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |