question

AndrewLu81 avatar image
0 Votes"
AndrewLu81 asked CarrinWu-MSFT edited

SSAS deploy failure in final step.

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-servicessql-server-analysis-services
06.jpg (56.8 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AndrewLu81, we have not get a reply from you. Could below answers help you? If yes, please do "Accept Answer". If not, please feel free to let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·
AndrewLu81 avatar image
0 Votes"
AndrewLu81 answered CarrinWu-MSFT edited

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AndrewLu81, is it a same error message? Please try below steps:
1. please backup your project -> copy the project to another folder
2. change the compatibility level to 1500
129882-level.png
3. try to deploy your project again


0 Votes 0 ·
level.png (83.0 KiB)
CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered AndrewLu81 commented

Hi @AndrewLu81,

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.



server.png (72.4 KiB)
compatibility.png (83.0 KiB)
output.png (86.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Your SSAS server: Node1/SqlSever2019 local server or Azue server.
I want to deploy local server.

0 Votes 0 ·