Error while creating relationship (direct query)

[Anonymous]

Hello all,

Good day!
I am trying to use direct query in the pbi. My datasource is coming from 2 pbi datasets in the cloud.
The SAP table is from a dataset
Both of the Cheat Sheet table comes from another dataset

I trying to create relationship between this table, the 'Cheat Sheet (clean)' to 'SAP' =blue line, it is successfull. But when I tried to do the same with 'Cheat Sheet (not clean)' to 'SAP' =red line it throw the error in the pop-up.

Please let me know what this mean, and how to workaround this?

Thanks

[amitchandak]

@Anonymous , Bi-directional relation can create loop (both relationship might be bi-directional your case) . First all check why you have Many to Many relationship, if need can it make single directional

refer if needed

https://www.seerinteractive.com/blog/join-many-many-power-bi/