cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Issue with connecting PowerBI gateway to SAP BW server

Hi PowerBI supporters,

 

I have strange issue with connecting PowerBI gateway to SAP BW server.

With PowerBI desktop app running on the gateway server, we were successful to connect into SAP BW,
BUT with MS Gateway NOT.


We using the same login credentials, but gateway is still throwing the same error, do not know why:

--------------------------------------------------------------------------
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
Activity ID: 9b67fca7-cde9-43e2-8b7e-728500375e8c
Request ID: 99bd7e3b-f7fa-a1c8-965b-7ea3187cd201
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net
Status code: 400
Error Code: DMTS_PublishDatasourceToClusterErrorCode
Time: Tue Mar 26 2019 12:38:05 GMT+0000 (GMT Standard Time)
Version: 13.0.8885.144

powerbi.gw: Invalid connection credentials.
Underlying error code: -2147467259
Underlying error message: The credentials provided for the SapBusinessWarehouse source are invalid. (Source at xxx.)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: SapBusinessWarehouse
Microsoft.Data.Mashup.CredentialError.DataSourcePath: xxx
Microsoft.Data.Mashup.CredentialError.Reason: AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SapBusinessWarehouse","path":"xxx"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessUnauthorized

--------------------------------------------------------------------------
Note:
• xxx – replacing real login path in our company

 

--------------------------------------------------------------------------

all SW parts (OS, gateway, SAP connectors, runtimes..) are up-to-date.
OS was patched to: Microsoft Windows Server 2016 Standard (Version 10.0.14393 Build 14393)
Gateway version: 3000.2.47

--------------------------------------------------------------------------
Do you have any idea why this is happening?

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Issue with connecting PowerBI gateway to SAP BW server

Hi @Bartez 

Which authetication type do you select when adding  SAP BW data source under the on-premise gateway?

Do you use "single sign-on connectivity" for that data source?

Overview of single sign-on (SSO) for gateways in Power BI

 

If you have a pro account, you could create a free support ticket to get a more quick support.

https://powerbi.microsoft.com/en-us/support/

 

Best Regards
Maggie

Highlighted
Regular Visitor

Re: Issue with connecting PowerBI gateway to SAP BW server

Hi @Maggie,

 

we do not have SSO in our company, we using Basic authentication type + SAP BW user login.

 

I have Pro account, I thought this is support portal 🙂

 

I will try to create support ticket, thank you for your answer,

Bartez.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Kudoed Authors