Ambiguous path error

[U156531]

Can someone tell me how to get around this issue. 

[Anonymous · Accepted solution]

Hi @U156531 ,

Analyzing the screenshot of the error report you have given, there are two possible reasons for solving this issue:

1. please remember that bi-directional relationships can impact negatively on performance. Further, attempting to configure a bi-directional relationship could result in ambiguous filter propagation paths. In this case, Power BI Desktop may fail to commit the relationship change and will alert you with an error message. The link provides you with guidance on when to create bi-directional model relationships: Bi-directional relationship guidance - Power BI | Microsoft Learn.

2. There can only be one active filter propagation path between two model tables. However, it's possible to introduce additional relationship paths, though you must set these relationships as inactive. Inactive relationships can only be made active during the evaluation of a model calculation. Links to related documents:Model relationships in Power BI Desktop - Power BI | Microsoft Learn. In Power BI Desktop model view, you can interpret a relationship's active vs inactive status. An active relationship is represented by a solid line; an inactive relationship is represented as a dashed line.

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!