Skip to main content

Power BI

Needs Votes

Add the ability for multiple relationships between table pairs

Vote (139) Share
's profile image

on 25 Nov 2015 01:19:49

Need the ability to create multiple relationships between table pairs. Example: Dynamics GP - SOP Sales Transactions and Sales Line Items have to be joined by SOP Type AND by SOP Number.

Comments (17)
's profile image Profile Picture

Power BI User on 05 Jul 2020 22:55:47

RE: Add the ability for multiple relationships between table pairs

I totally agree - this is a competitive disadvantage in the Microsoft BI stack today. Creating artificial keys could introduce unintended problems, not to mention it's non-value-added time and extra data to haul around.

's profile image Profile Picture

Andrew Tobin on 05 Jul 2020 22:44:38

RE: Add the ability for multiple relationships between table pairs

It'd be nice, but a simple alternative is to create another column on the dataset that concatenates fields to create a compound key.

's profile image Profile Picture

Francis Vachon on 05 Jul 2020 22:44:37

RE: Add the ability for multiple relationships between table pairs

Really guys this is a big shortcoming to let linger for like 2 years +. THere currently is no practical ways (other than writing & maintaining tons of replace queries) to switch values that are inputed into different labels for the dashboard, in case your source data isn't presentable directly/unformatted.

It would be sooooooooo simple to do that with a single value & labels lookup table, that would be referred to by each column from the data that are used to create the graph in the dashboard.

But not. You either have to create (and maintain) a bizzilion extra tables, or write a bunch of queries.... Please power bi....

's profile image Profile Picture

Power BI User on 05 Jul 2020 22:41:05

RE: Add the ability for multiple relationships between table pairs

Very valuable! Also vote on other 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/10321815-composite-key-support-in-power-bi

's profile image Profile Picture

Diego on 05 Jul 2020 22:38:19

RE: Add the ability for multiple relationships between table pairs

Is a pain that Power BI don't support multiple relationships between tables, is a mistake!

's profile image Profile Picture

Power BI User on 05 Jul 2020 22:32:59

RE: Add the ability for multiple relationships between table pairs

This looks the same as https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9115396-multiple-relationships-for-crm

's profile image Profile Picture

Jay Killeen on 05 Jul 2020 22:27:13

RE: Add the ability for multiple relationships between table pairs

This would be very valuable for models that have foreign keys for example:

Tickets that have many users using CreatedById -> UserId. As alias 'Creator' That is the default association.

Tickets that have many users using AssignedToId -> UserId. As alias 'Worker'.

Tickets that have many users using UpdatedById -> UserId as alias 'Editor'.

Merged Idea (2)