Invoke-ASCmd problem when deploy a tabular model with XMLA

[danielelgary]

We always deploy a tabular model with module SqlServer using Invoke-ASCmd

We have been having troubles deploying with this task Invoke-ASCmd 6 days ago.

The pipeline throws an exception that said: "##[error]When interactive authentication is not supported, an external access-token is required; either provide it in the connection-string or by setting the AccessToken property." But we didn't make any change in our tabular model. We debug our script and said this exception: "Invoke-ASCmd : Unable to obtain authentication token using the credentials provided. At .\Test3.ps1:168 char:12

• ... $output = Invoke-ASCmd -InputFile "$modelPath\bin\CustomisedModel.x ...

•             ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : InvalidResult: (:) [Invoke-ASCmd], AuthenticationException
  • FullyQualifiedErrorId : ExecutionFailed,Microsoft.AnalysisServices.PowerShell.Cmdlets.ExecuteScriptCommand" I don't know what happen with the library, can you tell me what's wrong or if there is something that I need to do to solve this issue?

I already do my own test with the module SQLServer in version 22.2.0, and the issue didn´t happen

Can you check this in the last updated (Version 22.3.0) ? Thank you!

[Khayoann2]

Hello, I have a similar issue on my side with the last version. (22.3.0 and no issue on 22.2.0) Do you have an idea about this ?

Thank you

[danielelgary]

Hi,

Yes I solved it changing the authentication method directly into the Invoke-ASCmd and now its ok with that

[Matteo-T]

I'm assuming you guys are good, right?

If not, please let me know and I'll have somebody in the "SSAS-land" look into this.