Forum Discussion
Unable to create multiple relations between tables
I am using power BI for my dashboards.
I have two tables (meta data tables, say A and B) which will be joined with all the other tables.
The join works for the first two data tables and from then on I am able to either join with A or B.
When I try to create relation, it gives me error as attached.
I can create the same relation in a new Power BI file and even in the same file if I delete all the existing relations.
Is there a way I can fix this?
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.
2 Replies
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
