Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So, I seem to understand this all the time. I try to make an active relationship and receive an error that says, in part:
"A direct active relationship between [Table 1] and [Table 2] cannot be entrusted because that would introduce ambiguity between [Table 3] and [Table 1]"
For example.
So, is there an approach to root causing this and getting to the exact problem to address/fix?
Thank you
jrp
Solved! Go to Solution.
Hi @Syndicate_Admin ,
Based on your description, the issue you may have faced is getting error on creating relationship between 2 tables and when this new relationship makes a circular path in the model. It will realise an ambiguity in reaching to the third table because there are 2 paths, one directly and another via an intermediate table.
So I suggest that you may need to re-adjust the relationship between the three tables or create a new table as a bridge to connect these tables. It depends on how your model was created. Please refer to the link below, I think it is very clear.
1. How to manage ambiguous relationship in Power BI
2. Bidirectional relationships and ambiguity in DAX
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
Based on your description, the issue you may have faced is getting error on creating relationship between 2 tables and when this new relationship makes a circular path in the model. It will realise an ambiguity in reaching to the third table because there are 2 paths, one directly and another via an intermediate table.
So I suggest that you may need to re-adjust the relationship between the three tables or create a new table as a bridge to connect these tables. It depends on how your model was created. Please refer to the link below, I think it is very clear.
1. How to manage ambiguous relationship in Power BI
2. Bidirectional relationships and ambiguity in DAX
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |