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

Van toepassing: SQL Server 2016 Service Pack 1SQL Server 2016 DeveloperSQL Server 2016 Enterprise

Symptoms


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.

Resolution


This issue is fixed in the following cumulative updates for SQL Server:

       Cumulative Update 13 for SQL Server 2017

       Cumulative Update 5 for SQL Server 2016 Service Pack 2

       Cumulative Update 13 for SQL Server 2016 Service Pack 1

       Cumulative update 8 for SQL Server 2016 SP1

       Cumulative Update 13 for SQL Server 2014 SP2

Status


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

References


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