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