Desktop Edit Relationship - Cannot Select Multiple Columns

[captainlaw]

Hello Community, I'm trying to select multiple columns (Name & Team), but the Desktop tool only allows me to select one.  Is there limitation to the tool to allow multiple columns for the join?  See screenshot below.

Thanks.

[KHorseman]

A relationship can only be formed between two columns. If you want a relationship based on multiple columns per table you will need to create compound key columns.

[captainlaw]

That will be a limitation compared with Tableau and Qlik. 

[Anonymous]

Hi @captainlaw,

There is a limitation in Power BI relationship that we can’t create relationship with two or more columns, some ideas about this issue have been submitted in the following links, please vote them.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15013392-multi-select-columns-in-...
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10321815-composite-key-support-in...

To work around this issue, you can create a new column in both tables using the following formula , then create a relationship based on these new fields.

Newcolumn = [Name] & [Team]

Thanks,
Lydia Zhang

[captainlaw]

Thanks Lydia.  I've just voted to help prioritize.  Cheers.