Ambiguity relationship

[misen13]

Hello,

I'm trying to create a relationship between 3 tables, Calendar, Confirmation and Affection. The thing is that the link between Calendar and Confirmation is inactive. I tried to do it in a sample data file and it worked, so I'm not sure why this is happening. It says "You can't create a direct relationship between Confirmation and Calendar because that would introduce ambiguity between tables Calendar and tEmploye. To make this relationship active, deactive or delete one of the relationship between Calendar and tEmploye first."

Is there any particular reason why this is happening?

Thanks.

Sample data file where I'm having no issue with relationships: https://files.fm/u/9re4p5p3

[v-shex-msft · Accepted solution]

Hi @misen13,

Relationship in power bi is different than other databases, it has direction for relationships(e.g, single filter direction, filter effect from one side to other side; cross filter direction, each side can effect correspond column).

Power bi will try to analytics data model and summary records through relationships.

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.

After play with your sample, I found your relationship map contains two available relationships tree.('date' and 'worker') I think power bi will confuse which relationship use to link tables when you try to active them at same time.

You can also take a look at following blog about 'power bi' relationship direction:

What is the Direction of Relationship in Power BI?

Regards,

Xiaoxin Sheng

[misen13]

Thanks! That worked!