Forum Discussion
Desktop Edit Relationship - Cannot Select Multiple Columns
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 ...
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-bi
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
Thanks Lydia. I've just voted to help prioritize. Cheers.