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.
Hi all
I am doing a relatinship model between 3 tables. One contains the objetives, the other the name of the business unit, and the other is a catalog of facilities.
When I link the BU table with the facilities I get an error like this:
I cant activate the relationship because of an ambiguity between Bu table and complaints table. However complaints table is not linked to bu (seen on image).
How can I get the relationship active?
I attach the 3 sources.
Facilities https://www.mediafire.com/file/fzyv1ojoc237vef/facilities.csv/file
Bu https://www.mediafire.com/file/0d2j3d6zfdf7fv9/BU.csv/file
Objetivos https://www.mediafire.com/file/5gukp2b9zuxg6b7/matriz_objetivos_bu.csv/file
Thanks!
Solved! Go to Solution.
Your issues is not specifically between those 3 tables. The thing causing the ambiguity is the bi-directional one-to-one filter between objectives and date. If you change this relationship to a single direction one-to-many relationship the same as all the other relationships coming off date this would fix your issue and you would be able to activate the other relationship.
Your issues is not specifically between those 3 tables. The thing causing the ambiguity is the bi-directional one-to-one filter between objectives and date. If you change this relationship to a single direction one-to-many relationship the same as all the other relationships coming off date this would fix your issue and you would be able to activate the other relationship.
Thanksssss
Like this right?
Regards!
The screenshot is a bit cut off, but that looks like what I was thinking
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |