PivotTable Fields order different after upgrade to SQL 2022 SSAS tabular

WG 51 Reputation points
2023-05-11T09:29:32.82+00:00

Hello,

 

We have upgraded one of our SSAS Tabular environments to SQL 2022, and are noticing changes in the way the measures and dimensions are shown in the “PivotTable Fields” section in Excel when connecting to models on this server.

The tabular model we are using has compatibility level 1500, and when we deploy this on an SQL 2019 SSAS tabular server and connect to it via Excel everything works as expected: on top of the “PivotTable Fields” list you first get the measures, and below that an alphabetical list of the dimensions with their attributes:

 old

If we deploy the exact same tabular model (compatibility level 1500, connected to the exact same dataset) to the SQL 2022 SSAS tabular server and connect to it (via the same Excel on the same pc as before), we see that the “PivotTable Fields” section is now different: The measures no longer have a separate section on top, but are shown together with the dimension attributes, and everything has different icons:

 new

 

Seeing the SQL 2022 SSAS tabular version is the only difference between the 2 cases, we assume it has something to do with this new server version, and thus our question: is there a way to get the old layout back where the measures are shown separately on top of the list?

Thanks in advance!

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,605 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
{count} votes