I have problems with connection to a SSAS server from my Power Automate Desktop.
I did not have any problems doing it in WinAutomation, I used: Open SQL Connection, with this Connection String:
Provider=MSOLAP.8;Persist Security Info=False;Data Source=xx;Initial Catalog=yy;User ID=zz;Password=qq;
But if I use a Open SQL connection in Power Automate Desktop with the same connection string it fails with this error:
Anybody can help?
COM error: COM error: Microsoft.AnalysisServices.AzureClient, The 'AuthenticationContext.AcquireToken(String, String, Uri, PromptBehavior)' method is missing from the embedded ADAL assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory, Version=5.2.7.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'..: Microsoft.Flow.RPA.Desktop.Robin.SDK.ActionException: Can't connect to data source COM error: COM error: Microsoft.AnalysisServices.AzureClient, The 'AuthenticationContext.AcquireToken(String, String, Uri, PromptBehavior)' method is missing from the embedded ADAL assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory, Version=5.2.7.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.. ---> System.Data.OleDb.OleDbException: COM error: COM error: Microsoft.AnalysisServices.AzureClient, The 'AuthenticationContext.AcquireToken(String, String, Uri, PromptBehavior)' method is missing from the embedded ADAL assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory, Version=5.2.7.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'..
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Microsoft.Flow.RPA.Desktop.Modules.Database.Actions.DatabaseActions.OpenConnection(Variant connectionString, SqlConnectionVariant& connection)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.Database.Actions.OpenConnection.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)
