Relationship issue with 3 tables

Hi @ JemB123,

Up to two relationships exist in the three tables, otherwise loops will be created.

In my testing, the following two relationships already exist between the three tables.

A one-to-many relationship ( single direction ) exists from Table 1 Date column to Table 3 Date column.

A one-to-many relationship ( single direction ) exists from Table 1 Date column to Table 2 Date column.

When I try to create a relationship from Table 3 Date column to Table 2 Date column, I get an error like yours.

There are ambiguous paths between ‘Table2’ and ‘Table1’: ‘Table2’ -> ‘Table1’ and ‘Table2’ ->’Table3’ ->’Table1’

According to the Microsoft documentation.
Model relationships in Power BI Desktop - Power BI | Microsoft Learn

You can delete or inactivate a path.

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.

Best Regards,

Dengliang Li

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

Hi Dengliang, 

thank you for your response, i dont want to delete or make anything inactive as i need these relationships, is there a way of getting around it?

as currently the Table_OEMList and Table_OEMFCST helps me with linking my forcast data to a OEM name.