Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
gzai
Frequent Visitor

How to solve ambiguity error in relationship database

Hello experts

 

I need to activate all relationship between country -> client -> booking ( active ) & country -> legal_entity -> booking ( not active )

How to solve this ambiguity error?

 

ambiguity.png

 

4 REPLIES 4
gzai
Frequent Visitor

Thanks for the reply @amitchandak 

 

May I know which one should be changed to 1-1?

@gzai , Please try if you can make this 1 to Many, single directional 

amitchandak_0-1675140034249.png

 

Also check other relationships too

I've tried and check other relationships, but still can't activate

amitchandak
Super User
Super User

@gzai , I think this caused bt bi-directional join.

If possible make that 1-1 as 1-Many single direction. 1 (in to M for 1-1 ) means what you want to treat as dimension or super dimension

 

Also, check other bi-directional joins

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.