cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tim_huang
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: 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
v-yuezhe-msft
Microsoft
Microsoft

@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?

Regards,
Lydia

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

Reagrds,
Lydia

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.

@v-yuezhe-msft 

 

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 @tim_huang @v-yuezhe-msft were you able to resolve this one? as I have experienced the same error

 

thanks Ed

Helpful resources

Announcements
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