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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

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 5
Anonymous
Not 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

Anonymous
Not 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

Anonymous
Not applicable

@Anonymous ,

Please export gateway log following the guide in this article

Reagrds,
Lydia

Anonymous
Not applicable

@Anonymous 

 

I got the same error messages in logs, 

Image_2019_03_04_2.pngImage_2019_03_04_3.png

 

PowerBI Desktop settings

Image_2019_03_04_8.png

 

Manage Data Gateway section in Power BI Web

Image_2019_03_04_10.pngImage_2019_03_04_11.png

Hi @Anonymous @Anonymous were you able to resolve this one? as I have experienced the same error

 

thanks Ed

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors