Are compound keys (multi-column) supported?

[OneWithQuestion]

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.

[v-frfei-msft]

Hi @Anonymous,

Has your issue be solved? 

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

[_donev · Accepted solution]

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-r...

[v-frfei-msft]

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