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.
Dear all,
After searching arround and not finding a clear solution, then I decided to ask here.
I have two data tables with cost and cost forecast and then I would like to create a relationship with both tables to the look up table GL accounts. However, I am getting the Relationship ambiguity error as pictures attached. What am I doing wrong?
Best regards,
Beto
Solved! Go to Solution.
Hi @Anonymous ,
Would you please check your data model if your relationship map contains multiple active relationships to analytic summarize, it will confused which one should be the right one. So it only allow one activated major relationship link between linked tables for analytics and interactions.
As a workaround, I suggest you use LOOKUPVALUE function to get data from GL accounts table.
For more details, please refer to https://radacad.com/what-is-the-direction-of-relationship-in-power-bi
Best Regards,
Dedmon Dai
Thank you all!
I had a bi-directional relationship and that was the issue. It got fixed as soon as I changed it to "single".
Hi @Anonymous ,
Would you please check your data model if your relationship map contains multiple active relationships to analytic summarize, it will confused which one should be the right one. So it only allow one activated major relationship link between linked tables for analytics and interactions.
As a workaround, I suggest you use LOOKUPVALUE function to get data from GL accounts table.
For more details, please refer to https://radacad.com/what-is-the-direction-of-relationship-in-power-bi
Best Regards,
Dedmon Dai
@Anonymous , If there two paths getting created then you will get this type of error
That can because of bi-directional relation you some wrong join
Like A-> B -> C
A->C
There are two paths to C
A<-> B
A<-> C
Now if try have more D with both B and C you will get this error
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 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |