Forum Discussion
Error while creating relationship (direct query)
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
1 Reply
- amitchandakSuper User
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/