Model Relationship "Errors"

[pawlowski6132]

Ok, well, not an error but, staring at this isn't getting me anywhere so, thought I'd reach out.

When I see the below warning/error/instructions, it really means nothing. Or, in other words isn't specific enough to allow me to focus on where the problem is. Just looking at this, this looks like a perfectly good start schema to me. Does anyone have a process or approach they use to problem solve/trouble shoot this kind of issue????

[v-luwang-msft]

Hi @pawlowski6132 ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regards

Lucien

[v-luwang-msft]

Hi @pawlowski6132 ,

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.

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

What is the Direction of Relationship in Power BI?

You also could read the following article :

you can't create a direct active relationship between Survey and Incident

Ambiguity relationship

Wish it is helpufl for you!

Best Regards

Lucien

[sayaliredij]

From Fact table to dimension table - if there is a possibility, change the relationship to one-directional instead of both directional. 

It should work then. In case you need to have both directions filtering,  instead of making it through model, try to solve it using DAX. 

Thanks,

Sayali 

If this post helps, then please consider Accept it as the solution to help others find it more quickly.