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 tab...
- 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-msft
Community Support
Community SupportHi 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