error

[Anonymous]

Hi everyone , 

How do I fix an "ambigous path error" , what is the cause of such an error?

Thank you

[Anonymous · Accepted solution]

Hi @Anonymous ,

Bi-directional relationships can introduce multiple, and therefore ambiguous, filter propagation paths between model tables. When evaluating ambiguity, Power BI chooses the filter propagation path according to its priority and weight.

If Power BI detects multiple paths that have the same priority and the same weight, it will return an ambiguous path error. In this case, you must resolve the ambiguity by influencing the relationship weights by using the USERELATIONSHIP function, or by removing or modifying model relationships.

For more details, you can read related document: Model relationships in Power BI Desktop - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu

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

[Idrissshatila]

Hello @Anonymous ,

it's because another table has a relationship with the table you're trying to link to that has a relationship with the table you're trying to link from.

try building your model as a star schema data model where you have dimension table that will be linked to fact tables

check the concept https://youtu.be/7ciFtfi-kQs?si=EJBhRLXfnUkJJC2A