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

TMSL deployment of roles from DevOps pipeline failure #66

Closed RoelEvers closed 2 years ago

RoelEvers commented 2 years ago

Hi, today we noticed that our TMSL scripts that we have been using to deploy our analysis services model roles ( createorreplace command ) no longer work in our release pipelines in devops. The error we get is:

2022-01-03T10:33:19.7528525Z ##[error]Error during executing queries (Execute TMSL against '***' complete with errors.

The System.Object[] text node at line 7, column 31 cannot appear inside the Command element (namespace urn:schemas-microsoft-com:xml-analysis) under Envelope/Body/Execute. This element can only have text nodes containing white-space characters.

The error seems to refer to XMLA scripting judging by the namespace.

Any idea why this would happen ? We have been deploying our models this way for quit some time now.

Regards Roel

liprec commented 2 years ago

The extension has updated recently and that is the reason of this different behavior. Can you share the TMSL script (structure) you are using? And also which options?

And btw with the updated the deploy task got the options to retain roles and/or membership during deployment

RoelEvers commented 2 years ago

Model_Readers.txt

We are using the Folder with TMSL files option. We noticed the new features as well.

I added one of the files as an example

liprec commented 2 years ago

This issue is fixed in version v1.5.1which will be available anytime soon.

RoelEvers commented 2 years ago

We just tested the fix and it seems to be working again. Thank you for the very fast response !