Power BI
NewDatamarts - N-N Relationships Workaround - Bridge table - "Relationships between fields cannot be determined"
Vote
(9)
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.