Mar 22, 2017 - Microsoft released CU2 for SQL Server 2016 SP1
On Mar 22, 2017 Microsoft released Cumulative Update package 2 (CU2) fro Service Pack 1 (SP1) for SQL Server 2016
This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 Service Pack 1. This build number of this cumulative update package is 13.0.4422.0.
List of fixes related to SQL Server Analysis Services / Powerpivot 2016 (since SP1):
| CU# | VSTS bug number | KB article number | Description |
| CU2 | 9503252 | 4009839 | FIX: An MDX query returns incorrect results in SSAS 2014 or 2016 Tabular mode |
| CU2 | 9287975 | 4014013 | FIX: Unexpected error occurs when you process a table in a tabular model in SSAS 2016 |
| CU2 | 9237364 | 3208179 | FIX: MDX query returns errors if the value of MaxRolapOrConditions is greater than 256 in SQL Server Analysis Services |
| CU2 | 9367901 | 3198826 | FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server Analysis Services |
| CU2 | 9456824 | 4013122 | Improvement: Performance improvement for the "sequence point algorithm" step in an SSAS 2016 Tabular Model transaction |
| CU2 | 9367862 | 3025408 | FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS |
| CU2 | 9367872 | 3198356 | FIX: Error when you execute an MDX query on a Tabular model database in SQL Server 2016 Analysis Services |
| CU2 | 9367911 | 3211605 | FIX: Error occurs for queries on global measures that have previously been referenced by query scoped measures in SSAS 2016 tabular mode |
| CU2 | 9367868 | 3212916 | FIX: SSAS may crash on query execution if a predefined role is specified in the connection string |
| CU2 | 9367925 | 3209520 | FIX: SSAS stored connection strings become corrupted if extended properties are used incorrectly |
| CU2 | 9467732 | 4013206 | FIX: SQL Server 2016 Analysis Services crashes or hangs during processing of data in a Tabular instance |
| CU1 | 8198025 | 3025408 | FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS |
| CU1 | 9100068 | 3211605 | FIX: Error occurs for queries on global measures that have previously been referenced by query scoped measures in SSAS 2016 tabular mode |
| CU1 | 9097248 | 3198827 | FIX: KPIs return a non-translated caption when an MDSCHEMA_MEASURES request is issued and the restrictions request hidden members |
| CU1 | 9099937 | 3208178 | FIX: Access violation when invalid credentials or connection string is specified in SQL Server 2016 Analysis Services |
| CU1 | 9100139 | 3212541 | FIX: SSAS may crash when a numeric calculated column must change its encoding scheme during the ProcessRecalc phase |
| CU1 | 9100261 | 3198356 | FIX: Error when you execute an MDX query on a Tabular model database in SQL Server 2016 Analysis Services |
| CU1 | 9097256 | 3198826 | FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server 2012 or 2014 Analysis Services |
| CU1 | 8986617 | 3209520 | FIX: SSAS stored connection strings become corrupted if extended properties are used incorrectly |
| CU1 | 8808992 | 3209426 | FIX: Processing a partition in SSAS 2016 drops all data from other partitions that are in the "incomplete" state |
| CU1 | 9098036 | 3206912 | FIX: Credential settings are lost when you schedule data refresh for PowerPivot workbooks |
| CU1 | 9078847 | 3213709 | FIX: The SAMEPERIODLASTYEAR function does not work in DAX queries in SQL Server 2016 Analysis Services |
| CU1 | 9098040 | 3212916 | FIX: SSAS may crash on query execution if a predefined role is specified in the connection string |
| CU1 | 9097254 | 3183686 | FIX: MDX LastChild function returns incorrect result after ProcessUpdate a dimension in SSAS |
Tags: news