Forum Discussion
Relationship ambiguity
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
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
3 Replies
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
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
