Compatibility Level (SSAS Tabular SP1)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
You can specify Compatibility Level when creating new Tabular model projects, when upgrading existing Tabular model projects, when upgrading existing deployed Tabular model databases, or when importing Power Pivot workbooks.
It is common to install new versions and service packs on development and test computers prior to installing on production computers. In such cases, it is important to understand setting compatibility level for both new Tabular model projects as well as those that have already been deployed into a production environment.
A SQL Server 2014 Analysis Services instance supports the following compatibility levels (database version):
SQL Server 2012 (1100)
SQL Server 2012 SP1 (1103)
SQL Server 2014 (1103)
Set compatibility level when creating a new Tabular model project
When creating a new Tabular model project in SQL Server Data Tools (SSDT), on the New Tabular project options dialog you can specify the compatibility level. You can choose between creating a new project to be deployed to an SQL Server 2012 SP1 or later Analysis Services instance or to an SQL Server 2012 Analysis Services instance (without Service Pack 1).
You can also specify a default compatibility level by selecting the Do not show this message again option. All subsequent projects will use the compatibility level you specified. You can change the default compatibility level in SSDT in Options.
Upgrade an existing Tabular model project to 1103 compatibility level
You can upgrade a Tabular model project created in SSDT prior to installing SQL Server 2012 SP1 or later to be database version 1103 compatible by using the Compatibility Level property in the model Properties window. In order to upgrade a Tabular model project, the computer on which SSDT is installed must have SQL Server 2012 SP1 or later installed and the Analysis Services instance on which the workspace database resides must also have SQL Server 2012 SP1 or later installed. You cannot downgrade to an earlier version.
Upgrade a deployed Tabular model database to 1103 compatibility level
You can upgrade an existing deployed Tabular model database to database version 1103 compatible in SQL Server Management Studio (SSMS) by using the Compatibility Level property in Database Properties. In order to upgrade, the computer on which the SQL Server Analysis Services instance is installed must have SQL Server 2012 SP1 or later installed. You cannot downgrade a deployed Tabular model database to an earlier version.
Import from Power Pivot
When creating a new Tabular model project by importing from Power Pivot, you can specify if you want to upgrade the compatibility level to the default compatibility level (if previously configured in SSDT) or leave the compatibility level to that already specified in the Power Pivot workbook.
Check compatibility level for a Tabular model database in SSMS
You can check the compatibility level for a Tabular model database in SSMS by viewing the Compatibility Level property (new in SQL Server 2012 SP1) in Database Properties.
Check supported compatibility level for an Analysis Services instance in SSMS
You can check the supported compatibility level in SSMS by viewing the Supported Compatibility Level property on the Information page (new in SQL Server 2012 SP1) in Analysis Services Properties. A supported compatibility level of 1103 indicates SQL Server SP1 or later is installed. The supported compatibility level cannot be changed.