Share via

SSAS Tabular model compatibility error

ali zubair 21 Reputation points
2021-02-06T23:32:18.477+00:00

Hi, When i am going to deploy SSAS tabular model, i got this error, can anybody please help me to solve this problem, i am using SQL Server developer 2014 edition and SSDT 2017. "Cannot deploy to server localhost. Reason: The destination server version is not compatible with the compatibility level of the current model."

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,297 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,821 Reputation points
    2021-02-09T02:19:17.36+00:00

    Hi,

    This error is due to the server version doesn't support your project compatibility level.

    You could see from Supported compatibility levels by version that SQL Server 2014 does not support 1200 and above compatibility level.

    You could set 1103 and 1100 level for your project and deploy to the SQL Server 2014 ssas server. You may need to redo you project design and do this : Set compatibility level

    Regards,
    Lukas

    0 comments

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.