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.
I've encountered numerous situations where this would have been needed as there are e.g. multiple roles between a transaction table and an entity table. This becomes specially crucial if the entity instances (e.g. Departments) are part of a hierarchy you need to be able to filter by using a higher level common nominator (e.g. Business Unit) and any of the related departments separately -- this an actual business case unsolvable by hierarchy model supported by Power BI :( I've actually have had PowerBI disqualified by the end users due to this limitation in few occasions, simply making copies of the large and complex hierarchies to server few different roles isn't simply going to cut it, end users want to pick the hierarchy level from one simple selection.
