Forum Discussion

joeljey's avatar
joeljey
New Member
2 years ago

Gateway refresh getting failed with below error

Hi All, 

 

 SAP BW (SNC) SSO has been configurated and works fine with Power BI destkop .  I am trying to setup SSO between PowerBI gateway and SAP BW system .  Getting the below error during refresh 

 

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the SapBusinessWarehouse source are invalid. (Source at hostname/SID/200/AAA-SID.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"SapBusinessWarehouse"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":" hostname/SID/200/AAA-SID"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SapBusinessWarehouse\",\"path\":\" hostname/SID/200/AAA-SID\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: WAA-BW-042 Interaction Records for Webi.
Cluster URI: AAAA-NORTH-EUROPE-G-PRIMARY-redirect.analysis.windows.net
Activity ID: 3f38f04c-f145-469e-a84e-86bc901f433d
Request ID: 411fda71-ff39-a04a-414c-2ac9e10303c3
Time: 2023-11-27 14:07:24Z

 

in gateway logs , i can see the message - could not find a suitable sap user for the snc name of the caller .

 

Please advice 

4 Replies