Skip to main content
Microsoft Idea

Power BI

New

Many to many relationships in Datamart

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

Alvaro Martin Martin on 08 Nov 2023 08:14:54

Many to many relationships in Datamart are not currently supported:


{"batchRootActivityId":"c2b64502-94cc-4d19-a127-a942f8cbce46","exceptionDataMessage":"Many to many relationship 'd7ab1ba7-069b-cfe3-6990-87dba5245617' is invalid. Only one to many cardinality is supported."}


We would need to be able to use N-N relationships in Datamarts in the same way we can do it in Power BI Desktop.


Best regards.