Showing results for 
Search instead for 
Did you mean: 
rjain12 Regular Visitor
Regular Visitor

Cannot create a relationship : ambiguity error



I have few tables. 


table 1


id  abc def


table 2 


id  cid  fef


table 3 


id  cid  sdw



Now table 1 as unique values for "id" and it is connected to table 2 with id. 


Table 3 and Table 2 cannot be connected as it does not have unique values for id. So I merged column 'id' and 'cid' in both table2 and table 3 to create a unique column. 


Now when I try to create a relationship between table 2 and table 3. It shows me an error saying that if I make this relationship active it will introduce ambuigty between table 3 and table 1. So I need to decativate or delete rel bw 3 and 1 in order to make it active. 


But for me relationship between table 1 and table 3 is required as well. What should I do to make both of them active? 

v-yulgu-msft Super Contributor
Super Contributor

Re: Cannot create a relationship : ambiguity error

Hi @rjain12,


Based on my understanding, table1 has unique values for id, while table2 and table3 doesn't, right? That case, you just need to create a one to many relationship from table1 to table2 abd from table1 to table3. Then, a indirect relationship will be established between table2 and table3.


Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rjain12 Regular Visitor
Regular Visitor

Re: Cannot create a relationship : ambiguity error

@v-yulgu-msft: When I try to create to one to many rel it says the cardinality you selected isint valid for this relationship

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 45 members 840 guests
Please welcome our newest community members: