Deployment Pipeline - Unable to deploy due to database compatibility level
I'm trying to deploy a datamart using the deployment pipeline from our development workspace to our test workspace but the deployment seems to fail.
The deployment UI gives a generic error ( Something went wrong, Deployment couldn't be completed. )
I managed to open the datamart in the test workspace before it get deleted and the error displayed is
Tabular databases do not support CompatibilityLevel downgrade. Current CompatibilityLevel: '1604'. Requested CompatibilityLevel: '1561'.
It seems that the newly created datamart is set to level 1604 and the development datamart is level 1561.
Is this a known issue? It makes it impossible to deploy the datamart to the next stage which seems to be a huge issue long term.
Thanks
5 Comments
- AnonymousNot applicable
Hi Devv
There is currently no such known issue. So when you deploy test workspace , you didn't synchronize the datamart deployment over, right? Can you provide a screenshot of the reported error?
Best Regards,
Community Support Team _ Ailsa Tao - DevvRegular Visitor
Hi Anonymous
I'm not sure what you mean with 'synchronize the datamart deployment over'. I use the deployment pipelines functionality which is included in Power BI
The error from the Deployment Pipeline is as follows
And the error from the datamart which gets automatically deleted after failure
When the deployment pipeline starts deploying the datamart to the test environment there is a small window in which the datamart becomes visible and you can watch the deployment from the datamart itself and you can actually see the steps the deployment pipeline is taking but after the failure it immediatly deleted the datamart from the test environment.
- DevvRegular Visitor
Hi Anonymous
Do you happen to have an update for me?
Thanks
- Crow2525
Helper I
Hi Devv, did you ever get a fix to your problem? I've got the same issue.