Skip to main content
cancel
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.

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
v-shex-msft
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 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

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors