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

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 55 members 1,072 guests
Please welcome our newest community members: