cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cparker4486 Member
Member

Why only one relationship per table pair?

Hi there,

 

I'm new to Power BI Desktop so I'm presuming that (1) I don't understand how it should work or (2) it's still just a new product and this issue will be improved later.

 

I am learning Power BI by creating visualizations with my Helpdesk data. The data is coming from Excel and I have a Tickets table and a Users table. Each ticket has multiple foreign key references to Users because each ticket has an assignee, a submitter, and a requester (among other similar fields) which are all defined in Users.

 

The problem is that I can only make one relationship between one of the fields in Tickets and Users.

 

 

Is there a specific reason for this behavior?

 

I did find a workaround by using Merge Queries but I think a relationship is more logical (or, at least, I'm more used to that kind of thinking.)

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Why only one relationship per table pair?

Easiest way around this is to import your Users table multiple times, Assignee table, Submitter table and Requester table, etc. and create the relationships between the appropriate fields to the appropriate user table. Same exact query, just change the name.


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

Proud to be a Datanaut!


3 REPLIES 3
Super User
Super User

Re: Why only one relationship per table pair?

Easiest way around this is to import your Users table multiple times, Assignee table, Submitter table and Requester table, etc. and create the relationships between the appropriate fields to the appropriate user table. Same exact query, just change the name.


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

Proud to be a Datanaut!


Power BI Team AlexGorev
Power BI Team

Re: Why only one relationship per table pair?

You can create multiple relationships between tables but only one of them would be active. In case of multiple relationships, you would need to specify which one to be used when creating report visual. Currently we do not support this capability and always use the active relationship.

 

Using Query View to create a single merged table is a proper workaround. Supporting multiple relationships is in our backlog. Feel free to add your vote in the forum: https://support.powerbi.com/forums/265200-power-bi

 

Thanks,

Alex.

Highlighted
cparker4486 Member
Member

Re: Why only one relationship per table pair?

Interesting idea. I'll give it a shot.