Forum Discussion

cparker4486's avatar
cparker4486
Icon for Helper III rankHelper III
11 years ago
Solved

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    11 years ago

    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.

AlexGorev's avatar
AlexGorev
Icon for Power BI Team rankPower BI Team
11 years ago

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.