FIX: Memory gets exhausted when you run Power BI report that executes DAX query on SSAS 2014, 2016 and 2017 Multidimensional mode

Applies to: Microsoft SQL Server 2016 Service Pack 1SQL Server 2016 DeveloperSQL Server 2016 Enterprise


When you create a Power BI report that executes a Data Analysis Expressions (DAX) query against Microsoft SQL Server 2014, 2016 and 2017 Analysis Services in Multidimensional mode (SSAS MD), you may notice that SSAS memory usage surpasses the configured HardMemoryLimit, and finally exhausts all the memory available.

The DAX query cannot be canceled, even at early stages.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Learn about the terminology that Microsoft uses to describe software updates.