Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,694 questions
PivotTable Fields order different after upgrade to SQL 2022 SSAS tabular
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 98%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
WG
51
Reputation points
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:
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:
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!
{count} votes
-
WG 51 Reputation points
2023-06-14T12:55:47.3333333+00:00 We still haven't found an explanation/solution for this, anyone have any ideas/suggestions?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 5%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKH%3C/text%3E%3C/svg%3E)
KONO, Hiroshi 0 Reputation points2023-06-27T06:58:10.49+00:00 I am also stuck with the same problem.
It seems that this problem also depends on the version of Excel.
Excel on Windows Office 2204 doesn't seem to have any problems with SQL Server 2022.
I had a problem with version 2210.
Version 2304 also had problems.
In the SQL Server 2016 environment, there is no problem even with Version 2210.
SQL Server 2019 has not been confirmed because there is no verification environment at hand.
Sign in to comment