Forum Discussion
Helper IIIWhy 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!
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.
3 Replies
- Greg_Deckler
Community Champion
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.
cparker4486Interesting idea. I'll give it a shot.
AlexGorevPower BI Team
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.