Skip to main content

Power BI

New

Allow the definition of ambiguous data relationships when creating data models & force the super user to select the desired relationship

Vote (28) Share
Linda Sarace's profile image

Linda Sarace on 08 Jan 2020 09:59:17

This is a feature that other BI tools like SAP provide, but PBI does not allow it.

When creating relationships in a data model, PBI does not allow you to create an ambiguous relationship. We need to be able to create ambiguous relationships in a model. When a super user (report writer type) uses data associated with an ambiguous relationship, they should be prompted to choose the relationship they desire for their report.