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 (12)
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.
RE: Composite Key support in Power BI
At a client that just asked for this.
RE: Composite Key support in Power BI
I'll say. In the meantime kludge city, workaround SELECT CAST(PrimaryKeyComponent1, nvarchar(32)) + CAST(PrimaryKeyComponent2, nvarchar(32)) AS KludgeKey... swell.
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
errr... Yeah.