Error in relationships

The error is telling you that if powerbi allowed the relationship to be created, it would have more than one way to get from 02 Data SAP to 02 Data BPCS ( follow the arrows of the relationships to test this yourself)  and that is not allowed because "it creates ambiguity" i.e. which route should powerbi take to link the tables.

So you have to go without the relationship or re-work your data model.

An observation : there are 2 m:n relationships and 2 bi-directional relationships.  These must be handled with care. I suggest looking at your model from the start and try to decide what you want to do with any visualisation. Then keep your model as simple as possible.

Hi KatkaS ,

You may needn't to create the relationship between the table 02 Data_BPCS_KPI and table 06 Report day , just change the Cross filter direction of the relationship between the table 04 FAMs and table 02 Data_BPCS_KPI from Single to Both, which will take all the tables above treated as a single table.

You can learn more about relationship :https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships.

Best Regards,

Amy

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