Forum Discussion
error
Hi everyone ,
How do I fix an "ambigous path error" , what is the cause of such an error?
Thank you
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 YuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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
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 YuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
