Skip to main content

    Power BI

    New

    SSAS Tabular many-to-many (M2M) relationship

    Vote (25) 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

    6cb0085b 5eb7-4fb9-a7f5-b61e88f51902 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

    a3309361 99be-ea11-a812-000d3a8ddfb2 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

    a66f60ec 1493-4b30-98d0-db5ee990160c 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