Share via

How do I change SSAS 2022 default compatibility level from 1200 to 1500

Shaw, Bryan 20 Reputation points
2024-01-03T14:03:15.0066667+00:00

I installed SQL Server Analysis Enterprise 2022 and the default compatibility level is 1200. How do I change it to 1500?

Thanks for the help!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,992 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,290 questions
Accepted answer
  1. Konstantinos Passadis 19,246 Reputation points MVP
    2024-01-03T14:14:22.9466667+00:00

    Hello @Shaw, Bryan!

    Welcome to Microsoft QnA!

    Please have a look :

    https://www.mssqltips.com/sqlservertip/4214/how-to-change-compatibility-level-of-a-ssas-tabular-database-using-ssdt/

    Open SQL Server Management Studio (SSMS).

    Connect to your SSAS instance.

    In Object Explorer, right-click on the SSAS database for which you want to change the compatibility level.

    Select "Properties."

    In the Properties window, navigate to the "Compatibility Level" property.

    Change the value to "1500."

    4214_Compatibility_Level

    https://learn.microsoft.com/en-us/analysis-services/tabular-models/compatibility-level-for-tabular-models-in-analysis-services?view=asallproducts-allversions

    I hope this helps!

    Kindly mark the answer as Accepted and Upvote in case it helped!

    Regards

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.