Skip to main content

    Power BI

    Needs Votes

    SSAS Tabular many-to-many (M2M) relationship

    Vote (26) Share
    hilbert's profile image

    hilbert on 22 Jul 2017 02:45:15

    Need support for many-to-many (M2M) relationship. I have many bridge tables in my tabular model and can’t use these at the moment. (SQL 2016 SSAS). Please at support for this relationship with SSAS Tabular.

    Comments (3)
    hilbert's profile image Profile Picture

    Lotta on 05 Jul 2020 23:28:37

    RE: SSAS Tabular many-to-many (M2M) relationship

    Needed is actual M2M handling in Tabualar, as in Multidimensional.
    Bidirectional filters doesn't solve the issue completly.

    hilbert's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:14:09

    RE: SSAS Tabular many-to-many (M2M) relationship

    I think it's available in SSAS 2017

    hilbert's profile image Profile Picture

    Marty Piecyk on 05 Jul 2020 23:13:51

    RE: SSAS Tabular many-to-many (M2M) relationship

    Alexei Stoyanovsky has a workaround that worked for me to allow a SSAS Tabular many-to-many relationship here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/97d82a9a-abab-4e8d-ba1a-81c7984d9164/manytomany-relationship-error-for-tabular-aas-model-and-power-bi?forum=sqlanalysisservices