Forum Discussion
OneWithQuestion
Post Prodigy
Post ProdigyAre compound keys (multi-column) supported?
I know previously it was not possible using PBI to join on multiple columns (or when using direct query).
Has that changed at all?
We have users who want to use direct query and have many tables that need to link on more than 1 column.
I'd like to be able to just let them drag and drop the tables without having to create a custom SQL view instead.
- They are still not supported and as far as I know, it's not going to change in near future. There is an idea you can vote for though - https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11682321-allow-compound-keys-in-relationships
4 Replies
- They are still not supported and as far as I know, it's not going to change in near future. There is an idea you can vote for though - https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11682321-allow-compound-keys-in-relationships
v-frfei-msftCommunity Support
Hi OneWithQuestion,
Based on my test, we can create relationship between tables by multi columns, However we can only make one active. You can use the USERELATIONSHIP function to work with the inactive relationship.Regards,
Frank
- v-frfei-msft
Hi OneWithQuestion,
Does that make sense? If so, kindly mark the answer as solution to close the case.
Regards,
Frank - v-frfei-msft
Hi Anonymous,
Has your issue be solved?
Regards,
Frank