Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Proud to be a Super User!
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-...
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |