Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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?




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 



Also check other relationships too

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

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors