Forum Discussion
SAP BW with On-premise Data Gateway Connection Error
I've installed on-premise data gateway and i'm trying to add a data source with SAP Business Warehouse but I get the error details as below
The same source has been verified in power bi desktop, the only different is that a language option setting in powerbi desktop and none in data source setting in power bi web
Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
Cluster URI: https://wabi-south-east-asia-redirect.analysis.windows.net
Status code: 400
Error Code: DMTS_PublishDatasourceToClusterErrorCode
Time: Tue Feb 26 2019 15:25:36 GMT+0800 (台北標準時間)
Version: 13.0.8482.125
my_laptop_win10_2: Invalid connection credentials.
Underlying error code: -2147467259
Underlying error message: The credentials provided for the SapBusinessWarehouse source are invalid. (Source at 172.20.97.66/00/100)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: SapBusinessWarehouse
Microsoft.Data.Mashup.CredentialError.DataSourcePath: 172.20.97.66/00/100
Microsoft.Data.Mashup.CredentialError.Reason: AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SapBusinessWarehouse","path":"172.20.97.66/00/100"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessUnauthorized
5 Replies
- AnonymousNot applicable
Anonymous ,
Which machine do you install on-premises gateway? Are you able to access SAP data source from the gateway machine? You can install SAP client in the gateway machine to test the connection.
In addition, what is your gateway version?
Regards,
Lydia- AnonymousNot applicable
I install the on-premise gateway on my laptop and I can access the SAP data source.
I have the SAP client, SAP Connector for Microsoft .NET 3.0 on my laptop too.
The connection between SAP BW and Power BI desktop works fine.
My on-premise gateway in version 3000.0.265
- AnonymousNot applicable
Anonymous ,
Please export gateway log following the guide in this article.
Reagrds,
Lydia