Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

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:
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
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: SapBusinessWarehouse
Microsoft.Data.Mashup.CredentialError.Reason: AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SapBusinessWarehouse","path":""}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessUnauthorized


@tim_huang ,

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?


Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

@tim_huang ,

Please export gateway log following the guide in this article


Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



I got the same error messages in logs, 



PowerBI Desktop settings



Manage Data Gateway section in Power BI Web


Hi @tim_huang @v-yuezhe-msft were you able to resolve this one? as I have experienced the same error


thanks Ed

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors