Relationship issue with 3 tables

[JemB123]

Hi i Have three tables in my powerbi report and want to form a relationship between them but it wont let me. 

Table_OEMFCST --> OEM Name to have a relationship with Table_OEMList --> OEM Name 

Table_OEMFCST --> Revenue  to have a relationship with OEMSkuList --> SAP S4 Material No.

OEMSkuList --> OEM Name to have a relationship with  Table_OEMList --> OEM Name 

the green works however the red doesnt work and says there is ambigutory between paths 'Table_OEMFCST' and 'Table_OEMList' ; Table_OEMFCST -> Table_OEMList and TableOEMFCST -> OEMSkuList -> Table_OEMList. 

[JemB123]

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. 

[v-denglli-msft]

Hi @JemB123,

You can create a new table in Power Query as a reference to Table_OEMList.
Any changes in the data source will also be synchronized to this new table.

This new table can also be used as a slicer to filter the data in Table_OEMFCST.

You can also refer to the following link for more information.
How to manage ambiguous relationship in Power BI – Cloud BI

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.

[v-denglli-msft]

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.