SAP BW Data source unable to be added in Power Bi Enterprise Gateway

[Anonymous]

Hi I have successfully connected by SAP BW database using SAP Message Server connector by Single sign on. I am able to pull data from my SAP landscape and build reports. The authentication used is windows with SNC partner name and Kerberoes as authentication method.

Now when i am trying to setup the data source in Enterprise gateway I am getting the below erro though I have provided the correct details and selecting the right choice:

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:	d94d5432-f581-4622-9a11-b2e3c1f8c96d
Request ID:	951634ef-f200-6dc3-20f9-95e945b655a2
Cluster URI:	https://wabi-north-europe-redirect.analysis.windows.net
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Tue Nov 27 2018 20:01:27 GMT+0530 (India Standard Time)
Version:	13.0.7382.168

PowerBIGateway:	Invalid connection credentials.
Underlying error code:	-2147467259
Underlying error message:	SncLibrary was not specified and the SNC_LIB_64 environment variable is empty or missing.
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:	SapBusinessWarehouse
Microsoft.Data.Mashup.CredentialError.DataSourcePath:	saps04.abcl.coo/s04/215/LLE
Microsoft.Data.Mashup.CredentialError.Reason:	CredentialInvalid
Microsoft.Data.Mashup.MashupSecurityException.DataSources:	[{"kind":"SapBusinessWarehouse","path":"saps04.abcl.coo/s04/215/LLE"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:	CredentialInvalid

[v-qiuyu-msft]

Hi @Anonymous,

I would suggest you create a support ticket to get dedicated support. 

Best Regards,
Qiuyun Yu 

[meenakp]

Hi,

Please advise if this was resolved. I am also getting same error(even after installing the latest Gateway update of Nov 2018).

[Anonymous]

hi @v-qiuyu-msft

i raised a support ticket and I got below response. I strongly doubt this but would like to get a confirmation: can you please confirm the same

Hope you are doing good.

Apologies, there is critical a mistake in our documentation. We do not support Gateway SSO for SAP BW Message Server. SAP BW Application Server has Gateway SSO support under gsskrb5. Unfortunately gsskrb5 doesn't work with connections using load balancers, which is a major difference between an Application Server and a Message Server. Fixing this would require changes in the gsskrb5 library, and as it's a third party library which has been marked as no longer being supported, it's unlikely we'll ever be able to support it.

Currently we are working with SAP to enable other forms of Gateway SSO for Application Servers. Once developed and tested for Application Server we will re-evaluate if those methods also work for Message Servers.

[v-qiuyu-msft]

Hi @Anonymous,

Please contact your case owner to see if there is a documentation error in this article: https://docs.microsoft.com/en-us/power-bi/service-gateway-sso-kerberos#setup-gsskrb5-on-client-machines-and-the-bw-server

As you already created a support ticket, please collaborate with the support engineers to get better help. 

Best Regards,
Qiuyun Yu