Cannot create multiples column relationship between two tables

[cal]

Hi,

I'm trying to connect two tables with 2 columns as a key

but it is not possible to select more then one column for a relationship.

*I dont want to create a new column that contains this 2 columns value in one cell

thanks,

[SamLester · Accepted solution]

Hi, composite keys are not supported in Power BI. As you suspected, you would need to create a new column in each data source that contains the combined values, then use this as the relationship column.

Here are previous threads on the topic:

http://community.powerbi.com/t5/Desktop/Create-relationship-between-with-two-columns/m-p/10786/highl...

http://community.powerbi.com/t5/Desktop/Is-it-possible-to-use-multiple-field-joins-in-a-table/td-p/2...

And here is the suggestion on the ideas site if you'd like to comment/vote:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9196284-use-composite-joins-in-ma...

Thanks,
Sam Lester (MSFT)