Skip to main content

Power BI

Needs Votes

Add the ability for multiple relationships between table pairs

Vote (139) Share
's profile image

on 2015-11-25 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) Merged Idea (2)
Vote 67
's profile image

on 2016-02-02 14:39:51

Power BI

Allow compound keys in relationships

Allow data modellers to define more complex relationships between tables. Currently, no compound key relationships are allowed, which hinders modelling and design, as now what should be a simple process becomes more complicated with users needing to manufacture unique non intelligent keys.

Merged
Vote 15
priyanka's profile image

priyanka on 2017-11-14 16:49:49

Power BI

Power BI table relationships

Please allow us to create relationship between two tables using a combination of 2 columns instead of single column, if none of the single columns have unique values. Sometimes it is not possible to create summary tables with unique values for any column.

Merged