Skip to main content

Power BI

New

Datamarts - N-N Relationships Workaround - Bridge table - "Relationships between fields cannot be determined"

Vote (9) Share
Alvaro Martin Martin's profile image

Alvaro Martin Martin on 14 May 2024 16:53:23

When using a bridge table (master) between 2 tables to get over the N-N relationship limitation in Power BI Datamarts, a problem shows up when trying to show two text-type fields (one from each table).


The message that appears when clicking "See details" is the following: "Relationships between fields cannot be determined"


Currently, there exists a workaround that consists on showing an aggrupation field, additionally to text-type fields, and the visual starts functioning.


Please, we would appreciate support on this issue.