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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
ArveM
Regular Visitor

gateway error when Get data on AWS

Hi

 

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 PowerBI.com,

(I log on to Powerbi.com with other user, but "map user name" back to powerbi@@ad.custdomain.com )

 

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 Powerbi.com was correct,,, and the username logged on to powerbi.com 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 powerbi@ad.custdomain.com to powerbi@@ad.custdomain.com.
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

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_DataSourceAccessError
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 powerbi@@ad.custdomain.com 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,,;)

1 REPLY 1
Anonymous
Not applicable

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 EffectiveUserName=xxxxx@xxxxxxx.com
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.

 

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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