Forum Discussion
Unable to create multiple relations between tables
Basically what this is saying, I believe, is that you are creating your relationships in such a way that you are creating multiple query paths between tables such that the data model is not certain how one table relates to another table (which path it should follow). You can generally get around this by editing the cross-filter direction to be "Single" versus "Both". I'd have to see a picture of your table relationships and the proposed relationship you are trying to create to know for sure.
Basically what this is saying, I believe, is that you are creating your relationships in such a way that you are creating multiple query paths between tables such that the data model is not certain how one table relates to another table (which path it should follow). You can generally get around this by editing the cross-filter direction to be "Single" versus "Both". I'd have to see a picture of your table relationships and the proposed relationship you are trying to create to know for sure.
Thanks. Changing cross-filter direction to Single worked. However, I had to do it for all the relations in my Power BI.
I was earlier trying to create somehting similar to this
select *
from AppV_PublishPackageContainer A
Left outer join AppvErrors B on A.AppVError = B.AppVError
Left outer join AppV_PackageIdVersionIdPackageName C on A.PackageVersion = C.PackageVersion
