SSAS deploy failure in final step.

Andrew Lu 116 Reputation points
2021-09-02T16:13:53.15+00:00

I follow tabular , but final step deploy the SSAS, it appear error.
"The database compatibility level of 1200 is below the minimal compatability level of 1470 needed for [model 'Model']::[DiscourageImplicitMeasures] at AnalysisServices mode."
128831-06.jpg

conditons:
Solution: mssql local(Sql sever 2019)/VS 2019/

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,071 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,099 questions
Accepted answer
  1. Andrew Lu 116 Reputation points
    2021-09-07T09:20:34.563+00:00

    Hi, Carrie,
    Thank you answer, I selected workspace "Integrated workspace", it still error at last step.

    deploy-ssas-tabular-model-to-server-eoor-34ole-db.html

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,811 Reputation points
    2021-09-03T02:24:10.573+00:00

    Hi @Andrew Lu ,

    This error maybe cause by mismatch compatibility level. SQL Server 2019 is support compatibility level 1200, and I tested it successfully in my side. The project information as below:
    SQL Server 2019
    Visual studio 2019
    Compatibility level: SQL Server 2016 RTM (1200)
    Integrated workspace

    Before you change the compatibility level, please specified the server name and try it again:
    128913-server.png

    If it not works, maybe you could try to change the compatibility level to higher one:
    128923-compatibility.png

    By the way, you could download sample Adventure Works tabular and multidimensional model database backups, scripts, and projects from this link. If the sample can be deployed to your server successfully, the error maybe cause by some wrong settings. And you could check the output tab have any other error information.
    128829-output.png

    Best regards,
    Carrin

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.