Forum Discussion

raeldor's avatar
raeldor
Advocate I
8 years ago

Create Relationship on Compound Key

So, can someone tell me why I can't join tables on more than one key?  This seems like one of the most basic query functions yet it can't be done.  I see people saying 'create a calculated column', b...
Need Help
v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

raeldor

 

In current Power BI, there exists a limitation for relationship that you can’t create relationship based on more than one column. 

 

To workaround this limitation, we can concatenate these related columns into one calculated column, then create relationship based on this concatenate column. Please refer:

 

 

 

Reference: Relationship in Power BI with Multiple Columns 

 

Thanks,
Xi Jin.

raeldor's avatar
raeldor
Advocate I
8 years ago

So, I know HOW to do it.  The question is really... why do I need to?

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Solution Sage
    8 years ago

    raeldor

     

    This is the limitation for relationship in current Power BI and it is by design. :smileysad:

     

    Thanks,
    Xi Jin.

    • raeldor's avatar
      raeldor
      Advocate I
      8 years ago

      A little odd considering every relational database I've ever seen allows multi-field joins.  Seems a little unfair making users jump through hoops to do something so common. :(

      • databass's avatar
        databass
        New Member
        1 year ago

        I agree. it's crazy that 6 years after this original post you still can't create a table relationship on multiple keys 😂