In development: Model many-to-many relationships with Azure Analysis Services

Posted on Friday, April 26, 2019

Many-to-many relationships in Azure Analysis Services are based on M2M relationships in Power BI. They allow relationships between tables where both columns are non-unique.

A relationship can be defined between a dimension and fact table at a granularity higher than the key column of the dimension. This avoids having to normalize dimension tables and can improve the user experience because the resulting model has a smaller number of tables with logically grouped columns. For example, if Budget is defined at the Product Category level, it isn't necessary to normalize the Product dimension into separate tables; one at the granularity of Product and the other at the granularity of Product Category.

This feature is already in public preview in CTP 2.4 of SQL Server Analysis Services 2019. We plan to officially launch it in Azure Analysis Services soon.

Related feedback