search

liprec / vsts-release-aas

Repository for my Analysis Service Azure pipelines tasks related to Azure Analysis Service or Power BI Premium
Other
27 stars 28 forks source link

AAS deployment failing #73

Closed Silpa-Suresh closed 2 years ago

Silpa-Suresh commented 2 years ago

The model.bim file doesn't contain data source details. We were providing the details through the Azure DevOps task inputs, since we have multiple environments. Now we are getting the following error on trying the deployment without any changes to model.bim file:

The JSON DDL request failed with the following error: Failed to execute XMLA. Error returned: 'M Engine error: 'Microsoft.Data.Mashup; The given data source reference is not a valid data source.'.

'..

@liprec , Could you please help in understanding the solution to the above error?

liprec commented 2 years ago

Can you share the debug log (variable: System.Debug set to true) to provide me some more details? And also the yml with the datasource connection details?

Silpa-Suresh commented 2 years ago

task.txt tasklog_7.log

Attached yml and log file.

Tried the option of advanced datasource setting as mentioned in: https://github.com/liprec/vsts-release-aas/issues/70#issuecomment-1004617259

Still getting same error.

liprec commented 2 years ago

Can you try running the pipeline again? And check if the deploy task is version 1.5.3? That version should have an extra check regarding the data source input and hopefully solves this problem.

Silpa-Suresh commented 2 years ago

Great, It worked now. Thanks a lot.