Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

gateway error when Get data on AWS



I've installed SQL-server 2017 std with SSIS and SSAS and On-premises gateway on an AWS-hosted server.

the installation seems fine,

- Gateway is configured and is reporting "online - you are good to go"

- Datasource is reporting "connection successful"

- and I've been able to create a report in PowerBI desktop on that instance - and publish it to,

(I log on to with other user, but "map user name" back to )


But when trying to load the report I get error "there was a data source access error. Please contact the gateway administrator."

Uhen trying to "get data"/Databases/SQLserverAnalysisServices -> the datasource and gateway presents itself, but when clicking on it i get this message; error.png



i also checked the On-premises gateways log, to verify that the effective username mappings in was correct,,, and the username logged on to had been replaced with the one with ssas/server permissions but it seemd as it was trying to replace it once more,, ?.

DM.EnterpriseGateway Information: 0 : 2018-07-12T13:00:16.1217390Z DM.EnterpriseGateway 'info-replaced' 'info-replaced' MGCC 'info-replaced' 1E2E2A20 [DataMovement.PipeLine.GatewayDataAccess] Replace effective user name in adomd connection string from to
DM.EnterpriseGateway Error: 0 : 2018-07-12T13:00:16.4264085Z DM.EnterpriseGateway 'info-replaced' 'info-replaced' MGCC 'info-replaced' BAA79098 [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]


the error-message following is

ErrorCode=-1056899072 --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: AdomdErrorResponseException:<pi>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The following system error occurred: The security database on the server does not have a computer account for this workstation trust relationship.



The user is used to create and publish the report - so it has access to the data (admin-role  in/on SSAS)



any ideas for troubleshooting woud be apriciated,,;)

Community Support
Community Support

Hi @ArveM,


I'd like to suggest you to test with below method to confirm if this issue related to SSAS:

use SSMS to test a connection to SSAS using the parameter
If this test with SSAS fails, then you need to talk with the SSAS dba for the reason of the failure.


If test successed, I think this issue may related to gateway, please open a support ticket for this this scenario.



Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors