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

 

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 ğŸ˜‚