DevOps Error when try to release SSAS Tabular Model

0
votes

We are using SSIS packages and SSAS tabular models for our Business Intelligence project and Azure DevOps is the CI/ CD environment. Our databases are in SQL server 2016 and using Visual Studio 2017 and SSDT tools for building pakages.

We can successfully build and release SSIS packages from Azure DevOps but when it comes to analysis service,Tabular models are failing when try to release even after successful build, due to the following error:

##[error]Task_InternalError The following exception occurred while retrieving member "SaveChanges": "Encountered an invalid type for a default value."

enter image description here

If anyone has encountered or resolved this issue, please share thoughts.

1
azure-devopsssasssas-tabulardevops-services

1 Answers

0
votes

I saw a recent thread in #github regarding same issue "Deployment broken #2" and realized that this is caused due an agent upgrade in DevOps. You have to install new version of agent in DevOps and can create a new Task under the Release.

See article: Deployment broken #2