Hello,I'm trying to connect my SSAS with powerBI but i'm getting this error:GatewayPipelineErrorCode=DM_GWPipeline_UnknownErrorGatewayVersion=InnerType=AdomdErrorResponseExceptionInnerMessage=<ccon>The following system error occurred: </ccon>InnerToString=<ccon>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The following system error occurred:em Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)em Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForError(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)em Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)em Microsoft.AnalysisServices.AdomdClient.XmlaClient.SupportsProperties(IList`1 propertyList)em Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect()em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.EstablishAdmodConnection(AdomdConnection connection)em System.Security.Principal.WindowsIdentity.RunImpersonated[T](SafeAccessTokenHandle safeAccessTokenHandle, Func`1 func)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.ImpersonatorHelper.RunImpersonatedInternal[T](String userName, SecureString password, Func`1 action)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()</ccon>InnerCallStack= em Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)em Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForError(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)em Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)em Microsoft.AnalysisServices.AdomdClient.XmlaClient.SupportsProperties(IList`1 propertyList)em Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect()em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.EstablishAdmodConnection(AdomdConnection connection)em System.Security.Principal.WindowsIdentity.RunImpersonated[T](SafeAccessTokenHandle safeAccessTokenHandle, Func`1 func)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.ImpersonatorHelper.RunImpersonatedInternal[T](String userName, SecureString password, Func`1 action)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()([1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException.StackTrace:)em Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)em Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForError(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)em Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)em Microsoft.AnalysisServices.AdomdClient.XmlaClient.SupportsProperties(IList`1 propertyList)em Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect()em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.EstablishAdmodConnection(AdomdConnection connection)em System.Security.Principal.WindowsIdentity.RunImpersonated[T](SafeAccessTokenHandle safeAccessTokenHandle, Func`1 func)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.ImpersonatorHelper.RunImpersonatedInternal[T](String userName, SecureString password, Func`1 action)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()--- End of inner exception stack trace ---([0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AdomdDataAccessErrorResponseException.StackTrace:)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ConnectionStrings.AdoNetDbFullConnectionString.<OpenConnectionAsync>d__17.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.AdoNetDbConnectionUtils.<CreateConnectionAsync>d__4.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.AdoNetDbConnectionPool.<>c__DisplayClass1_0.<<CreateObjectInstanceAsync>b__0>d.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivityAsync>d__7`1.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.Common.Pool.BasePool`3.<CreatePoolObjectAsync>d__25.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.Common.Pool.StatelessPool`2.<GetAsync>d__9.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass18_0.<<GetDatabaseConnectionAsync>b__0>d.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivityAsync>d__7`1.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1_0.<<EnsureConnectionAsync>b__0>d.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivityAsync>d__7`1.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<DispatchImplAsync>d__3.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<DispatchAsync>d__1.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<>c__DisplayClass12_0.<<DeserializeAsync>b__0>d.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivityAsync>d__7`1.MoveNext()--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<DeserializeAsync>d__12.MoveNext()DM.EnterpriseGateway Error: 0 : 2024-06-07T12:25:37.8362938Z DM.EnterpriseGateway fcde03c1-7fd3-476b-929a-845f17b55e42 c7ff5366-57c1-40ba-bc86-27d35b1e6667 MGCC 81683fe0-ec25-4b44-b89b-67cbfd95b03d 0a5020bf-d5cb-42e9-ada4-42375d97a723 0a5020bf-d5cb-42e9-ada4-42375d97a723 8B21C03B [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AdomdDataAccessErrorResponseException: AdomdException encountered while accessing the target data source.; ErrorShortName: AdomdDataAccessErrorResponseException[ErrorCode=-1056899072,HResult=-2146233088]/Wrapped(AdomdErrorResponseException)[ErrorCode=-1056899072,HResult=-2146233088]DM.EnterpriseGateway Error: 0 : 2024-06-07T12:25:37.8373606Z DM.EnterpriseGateway fcde03c1-7fd3-476b-929a-845f17b55e42 c7ff5366-57c1-40ba-bc86-27d35b1e6667 MGCC 81683fe0-ec25-4b44-b89b-67cbfd95b03d 0a5020bf-d5cb-42e9-ada4-42375d97a723 0a5020bf-d5cb-42e9-ada4-42375d97a723 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=885, err=AdomdDataAccessErrorResponseException, rootcauseErrorEventId=0)DM.EnterpriseGateway Error: 0 : 2024-06-07T12:25:37.8373606Z DM.EnterpriseGateway a50b14b2-5cf7-436f-b0d6-144227123524 c7ff5366-57c1-40ba-bc86-27d35b1e6667 MGGC 81683fe0-ec25-4b44-b89b-67cbfd95b03d 0a5020bf-d5cb-42e9-ada4-42375d97a723 0a5020bf-d5cb-42e9-ada4-42375d97a723 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=886, err=AdomdDataAccessErrorResponseException, rootcauseErrorEventId=0)DM.EnterpriseGateway Error: 0 : 2024-06-07T12:25:37.8373606Z DM.EnterpriseGateway 4d30e8f3-137b-43b7-856d-52f4eda06671 c7ff5366-57c1-40ba-bc86-27d35b1e6667 MGOC 81683fe0-ec25-4b44-b89b-67cbfd95b03d 0a5020bf-d5cb-42e9-ada4-42375d97a723 0a5020bf-d5cb-42e9-ada4-42375d97a723 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=886, err=AdomdDataAccessErrorResponseException, rootcauseErrorEventId=0)DM.EnterpriseGateway Error: 0 : 2024-06-07T12:25:37.8373606Z DM.EnterpriseGateway d56bd371-d59c-4726-85fa-07c567084a15 c7ff5366-57c1-40ba-bc86-27d35b1e6667 MGPP 81683fe0-ec25-4b44-b89b-67cbfd95b03d 0a5020bf-d5cb-42e9-ada4-42375d97a723 0a5020bf-d5cb-42e9-ada4-42375d97a723 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=887, err=AdomdDataAccessErrorResponseException, rootcauseErrorEventId=0)DM.EnterpriseGateway Error: 0 : 2024-06-07T12:25:37.8373606Z DM.EnterpriseGateway 43407ed4-666b-4857-a5ae-f97d595e272b c7ff5366-57c1-40ba-bc86-27d35b1e6667 MDSR 81683fe0-ec25-4b44-b89b-67cbfd95b03d 0a5020bf-d5cb-42e9-ada4-42375d97a723 0a5020bf-d5cb-42e9-ada4-42375d97a723 4C1EF73E [DM.GatewayCore] Error processing request: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AdomdDataAccessErrorResponseException: AdomdException encountered while accessing the target data source.Can ayone help me?ThanksVersions:SQL server:SSAS:SSIS:

Hi, HurleyWave First of all, sorry for my late reply. Thank you very much for your reply. I looked up information like this, and when connecting to SSAS data sources, the Power BI gateway only supports Windows authentication.The Windows account you enter must be a member of the Server Administrator role on the instance of Analysis Services you want to connect to. If the password for this account is set to expire, the user will receive a connection error unless you update the data source password. You open the link below and use the method mentioned in the document to get your correct account number. Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn Best Regards Jianpeng Li If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

HurleyWave

Frequent Visitor

2 years ago

Solved

Data Gateway (DM_GWPipeline_UnknownError)

Hello,

I'm trying to connect my SSAS with powerBI but i'm getting this error:

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
GatewayVersion=
InnerType=AdomdErrorResponseException
InnerMessage=<ccon>The following system error occurred: </ccon>
InnerToString=<ccon>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The following system error occurred:
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForError(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.SupportsProperties(IList`1 propertyList)
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect()
em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.EstablishAdmodConnection(AdomdConnection connection)
em System.Security.Principal.WindowsIdentity.RunImpersonated[T](SafeAccessTokenHandle safeAccessTokenHandle, Func`1 func)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.ImpersonatorHelper.RunImpersonatedInternal[T](String userName, SecureString password, Func`1 action)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()</ccon>
InnerCallStack= em Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForError(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.SupportsProperties(IList`1 propertyList)
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect()
em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.EstablishAdmodConnection(AdomdConnection connection)
em System.Security.Principal.WindowsIdentity.RunImpersonated[T](SafeAccessTokenHandle safeAccessTokenHandle, Func`1 func)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.ImpersonatorHelper.RunImpersonatedInternal[T](String userName, SecureString password, Func`1 action)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()
([1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException.StackTrace:)
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForError(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.SupportsProperties(IList`1 propertyList)
em Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect()
em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
em Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.EstablishAdmodConnection(AdomdConnection connection)
em System.Security.Principal.WindowsIdentity.RunImpersonated[T](SafeAccessTokenHandle safeAccessTokenHandle, Func`1 func)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.ImpersonatorHelper.RunImpersonatedInternal[T](String userName, SecureString password, Func`1 action)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()
--- End of inner exception stack trace ---
([0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AdomdDataAccessErrorResponseException.StackTrace:)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ConnectionStrings.AdoNetDbFullConnectionString.<OpenConnectionAsync>d__17.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.AdoNetDbConnectionUtils.<CreateConnectionAsync>d__4.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.AdoNetDbConnectionPool.<>c__DisplayClass1_0.<<CreateObjectInstanceAsync>b__0>d.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivityAsync>d__7`1.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.Common.Pool.BasePool`3.<CreatePoolObjectAsync>d__25.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.Common.Pool.StatelessPool`2.<GetAsync>d__9.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass18_0.<<GetDatabaseConnectionAsync>b__0>d.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivityAsync>d__7`1.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass1_0.<<EnsureConnectionAsync>b__0>d.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivityAsync>d__7`1.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<DispatchImplAsync>d__3.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessorDispatcher.<DispatchAsync>d__1.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<>c__DisplayClass12_0.<<DeserializeAsync>b__0>d.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.<ExecuteInActivityAsync>d__7`1.MoveNext()
--- Fim do rastreio da pilha da localização anterior em que a excepção foi emitida ---
em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
em Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.Serialization.GatewayDeserializer.<DeserializeAsync>d__12.MoveNext()
DM.EnterpriseGateway Error: 0 : 2024-06-07T12:25:37.8362938Z DM.EnterpriseGateway fcde03c1-7fd3-476b-929a-845f17b55e42 c7ff5366-57c1-40ba-bc86-27d35b1e6667 MGCC 81683fe0-ec25-4b44-b89b-67cbfd95b03d 0a5020bf-d5cb-42e9-ada4-42375d97a723 0a5020bf-d5cb-42e9-ada4-42375d97a723 8B21C03B [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AdomdDataAccessErrorResponseException: AdomdException encountered while accessing the target data source.; ErrorShortName: AdomdDataAccessErrorResponseException[ErrorCode=-1056899072,HResult=-2146233088]/Wrapped(AdomdErrorResponseException)[ErrorCode=-1056899072,HResult=-2146233088]
DM.EnterpriseGateway Error: 0 : 2024-06-07T12:25:37.8373606Z DM.EnterpriseGateway fcde03c1-7fd3-476b-929a-845f17b55e42 c7ff5366-57c1-40ba-bc86-27d35b1e6667 MGCC 81683fe0-ec25-4b44-b89b-67cbfd95b03d 0a5020bf-d5cb-42e9-ada4-42375d97a723 0a5020bf-d5cb-42e9-ada4-42375d97a723 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=885, err=AdomdDataAccessErrorResponseException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2024-06-07T12:25:37.8373606Z DM.EnterpriseGateway a50b14b2-5cf7-436f-b0d6-144227123524 c7ff5366-57c1-40ba-bc86-27d35b1e6667 MGGC 81683fe0-ec25-4b44-b89b-67cbfd95b03d 0a5020bf-d5cb-42e9-ada4-42375d97a723 0a5020bf-d5cb-42e9-ada4-42375d97a723 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=886, err=AdomdDataAccessErrorResponseException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2024-06-07T12:25:37.8373606Z DM.EnterpriseGateway 4d30e8f3-137b-43b7-856d-52f4eda06671 c7ff5366-57c1-40ba-bc86-27d35b1e6667 MGOC 81683fe0-ec25-4b44-b89b-67cbfd95b03d 0a5020bf-d5cb-42e9-ada4-42375d97a723 0a5020bf-d5cb-42e9-ada4-42375d97a723 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=886, err=AdomdDataAccessErrorResponseException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2024-06-07T12:25:37.8373606Z DM.EnterpriseGateway d56bd371-d59c-4726-85fa-07c567084a15 c7ff5366-57c1-40ba-bc86-27d35b1e6667 MGPP 81683fe0-ec25-4b44-b89b-67cbfd95b03d 0a5020bf-d5cb-42e9-ada4-42375d97a723 0a5020bf-d5cb-42e9-ada4-42375d97a723 590DBA9A [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=887, err=AdomdDataAccessErrorResponseException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2024-06-07T12:25:37.8373606Z DM.EnterpriseGateway 43407ed4-666b-4857-a5ae-f97d595e272b c7ff5366-57c1-40ba-bc86-27d35b1e6667 MDSR 81683fe0-ec25-4b44-b89b-67cbfd95b03d 0a5020bf-d5cb-42e9-ada4-42375d97a723 0a5020bf-d5cb-42e9-ada4-42375d97a723 4C1EF73E [DM.GatewayCore] Error processing request: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AdomdDataAccessErrorResponseException: AdomdException encountered while accessing the target data source.

Can ayone help me?

Thanks

Versions:
SQL server:

SSAS:

SSIS:

Need Help

Anonymous
2 years ago
Hi, HurleyWave

First of all, sorry for my late reply. Thank you very much for your reply. I looked up information like this, and when connecting to SSAS data sources, the Power BI gateway only supports Windows authentication.
The Windows account you enter must be a member of the Server Administrator role on the instance of Analysis Services you want to connect to. If the password for this account is set to expire, the user will receive a connection error unless you update the data source password.

You open the link below and use the method mentioned in the document to get your correct account number.

Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

10 Replies

HurleyWave
Frequent Visitor
2 years ago
Just and update:

In order to try to solve the problem, I have upgrade my things to this (but the same problem shows):

datagateway: 3000.222.5 (May 2024)
SSAS: BUILD 16.0.1000.6
SSIS: BUILD 16.0
SSMS: 20.1
SQL Server: Microsoft SQL Server 2022 (RTM-GDR) (KB5035432) - 16.0.1115.1 (X64) Mar 15 2024 01:13:46 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 19045: )
Anonymous
Not applicable
2 years ago
Hi, HurleyWave

Are the server names, database names, and credentials that you are connecting to SSAS on Power BI Service correct? Are you able to connect to your SSAS properly on Power BI Desktop?

Secondly, you should make sure that the above information is correct and that the current account has the relevant read permissions. Based on the error you provided, it is indicated: AdomdErrorResponseException. It is also possible that the communication between the SSAS and the gateway is blocked.

You can check if the steps in the official documentation below are consistent with your steps:

Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn

Troubleshoot gateways - Power BI | Microsoft Learn

Troubleshoot the on-premises data gateway | Microsoft Learn

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- HurleyWave
  Frequent Visitor
  2 years ago
  Hello Anonymous thank you for replying,
  I followed the url - Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn
  And i have no problem connecting the analysis service with PBI desktop, and i'm using my machine user, which is the admin of Analysis service itself
  
  i've already saw the other urls that you shared, and the error output is the output itself of gateway.
  
  As you can see my gateway is online and runing with no problem
  
  I just want to share my dashboard with other people an it appers the following error:
  - Anonymous
    Not applicable
    2 years ago
    Hi, HurleyWave
    
    Thank you very much for your reply. I saw the picture you provided, and on the management gateway connection interface, you get an error:
    1. There was an error while saving. An error occurred while trying to save the changes,
    2. There was an error accessing the data source and it is recommended to contact the gateway administrator
    I see that your gateway is online, you can check if your data source is online:
    
    When you share the dashboard with other users:
    All resources are busy. Please try again and refresh the gateway
    This error indicates that the dashboard resources you are trying to access are overloaded. Does your dashboard have many tiles that cause the gateway to be exceeded. Can you set up a dashboard with only one or two visuals to test if the current problem is caused by too many visuals being displayed in one dashboard.
    
    How to Get Your Question Answered Quickly
    
    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
    
    Best Regards
    
    Jianpeng Li
    
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SaiTejaTalasila
Super User
2 years ago
Hi HurleyWave ,

Is XMLA endpoint enabled for that capacity.
https://learn.microsoft.com/en-us/analysis-services/multidimensional-models-scripting-language-assl-xmla/developing-with-xmla-in-analysis-services?view=asallproducts-allversions

Thanks,
Sai Teja
- HurleyWave
  Frequent Visitor
  2 years ago
  Hello SaiTejaTalasila ,
  Thank you for your reply,
  Are you saying that there is no way round this problem?