cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kiranmayiyl Frequent Visitor
Frequent Visitor

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?

PBI Error.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: 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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


2 REPLIES 2
Super User
Super User

Re: 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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


kiranmayiyl Frequent Visitor
Frequent Visitor

Re: Unable to create multiple relations between tables

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