Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
captainlaw
Microsoft Employee
Microsoft Employee

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 screenshot below.

 

Thanks.

 

pbirelationship-question.JPG

4 REPLIES 4
KHorseman
Community Champion
Community Champion

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




That will be a limitation compared with Tableau and Qlik. 

Anonymous
Not applicable

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

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.