Composite key using DirectQuery

[Jug]

I need to create a composite key to relate two tables, but I can't use concatenation by creating a new column because I use DirectQuery mode. How could I create the composite key?

[amitchandak · Accepted solution]

@Jug ,you can try combinevalues, that is allowed as new column

https://www.youtube.com/watch?v=rzbtXQrq43Y&list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA&index=8