Srinivasan Turuvekere on 22 Oct 2015 21:59:36
Provide support for composite keys natively as a modeling feature. This would be useful to create relationships between tables that join on multiple columns without having to create a surrogate key by concatenating fields
- Comments (16)
RE: Composite Key support in Power BI
This is a feature supported in many other BI tools. It's crazy that it's still not possible in Power BI.
RE: Composite Key support in Power BI
This is really important. Please implement
RE: Composite Key support in Power BI
Really, tremendously important in Semantik modelling
RE: Composite Key support in Power BI
I can't believe something so basic is still in a "Needs Votes" status. This is CRITICAL
RE: Composite Key support in Power BI
In a DirectQuery model the concatenation strategy slows down performance tremendously because you're joining on string instead of integers. Please add this. thank you.
RE: Composite Key support in Power BI
Yes, Support it. It must be present in Manage Relationship tab.
RE: Composite Key support in Power BI
Its lame MS doesnot add such useful features in the tool. Not wonder why Tableau is still everyones favourite bi tool
RE: Composite Key support in Power BI
Very valuable! Also vote on similar ideas: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9196284-use-composite-joins-in-manage-relationships-setup
and
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10849149-add-the-ability-for-multiple-relationships-between
RE: Composite Key support in Power BI
yes, this is very important, specialy in directquery mode. I can understand how the in memory mode works, but in directquery, having more than 1 column in a join is a must have.
currently this limitation breaks the usage of my indexes and cause performance issues.
RE: Composite Key support in Power BI
This would be very handy. I'd like to avoid creating unnecessary concatenated fields and reduce the model size.