Forum Discussion
Desktop Edit Relationship - Cannot Select Multiple Columns
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.
That will be a limitation compared with Tableau and Qlik.
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-relationship-view
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10321815-composite-key-support-in-power-biTo 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 ZhangThanks Lydia. I've just voted to help prioritize. Cheers.
