Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Devv

Deployment Pipeline - Unable to deploy due to database compatibility level

Submitted by on ‎11-29-2023 06:46 AM

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

Status: Needs Info
See more ideas labeled with:
5 Comments (5 New)
Comments
Anonymous
Not applicable
‎11-30-2023 01:53 AM

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

Devv
Regular Visitor
‎11-30-2023 02:04 AM

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

 

Devv_0-1701338270782.png

 

And the error from the datamart which gets automatically deleted after failure

Devv_1-1701338357528.png

 

 

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. 

Devv
Regular Visitor
‎12-12-2023 06:16 AM

Hi @Anonymous 

 

Do you happen to have an update for me?

 

Thanks

Crow2525
Helper I
Helper I
‎02-15-2024 09:19 PM

Hi Devv, did you ever get a fix to your problem?  I've got the same issue.

Devv
Regular Visitor
‎02-16-2024 02:38 AM

Hi @Crow2525 

 

Sadly I never got an update on the issue. So I'm not sure if they are even tracking the bug. The only solution would be completely remaking a new datamart.

Idea Statuses