Error adding a new SAP BW Message Server DataSource

[icelander01]

Hi,

We're trying to create a new "SAP BW Message Server DataSource", in https://app.powerbi.com -> Manage Gateways.

But it gives error below, about not finding the entry of sapms<SID>.

 *** We're NOT using the PowerBI Desktop, we're using the server version (cloud one) ****

We use a server with Data Gateway and SAPGUI 750 installed and the C:\window\system32\drivers\etc\services file has the correct sapmsBP1 entry.

We already installed SAP NW RFC 7.5 libraries in C:\windows\system32 , in this server has 

If we add the same entry, but as "SAP BW Server" (without using Logon Group) it works, the entry is added sucessfully.

But we need to use the Logon Group type (SAP BW Message Server), to not hardcode the logons to one specific SAP application server.

Any ideias ?

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:	e92d2ad8-41e8-4ddc-8c79-652f4ce1606c
Request ID:	9c175691-5058-72d4-0388-d1ae76c31013
Cluster URI:	https://wabi-brazil-south-redirect.analysis.windows.net/
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Thu Jan 09 2020 19:50:46 GMT-0300 (E. South America Standard Time)
Service version:	13.0.11747.315
Client version:	1912.2.031

BkmPBIGateway-DEV:	Unable to connect to the data source undefined.
Underlying error code:	-2147467259
Underlying error message:	SAP Business Warehouse: RfcOpenConnection failed(RFC_COMMUNICATION_FAILURE): ERROR service 'sapmsBP1' unknown TIME Thu Jan 09 19:50:46 2020 RELEASE 753 COMPONENT NI (network interface) VERSION 40 RC -3 MODULE D:/depot/bas/753_REL/src/base/ni/ninti.c LINE 939 DETAIL NiPGetServByName: 'sapmsBP1' not found SYSTEM CALL getaddrinfo COUNTER 1
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:	SapBusinessWarehouse
Microsoft.Data.Mashup.ValueError.DataSourcePath:	sapedw.braskem.com.br/BP1/120/120
Microsoft.Data.Mashup.ValueError.ErrorCode:	-2147467259
Microsoft.Data.Mashup.ValueError.Reason:	DataSource.Error

Regards,

Kendy

[venal]

@icelander01 

Can you please refer the sap bw white paper and re-check the settings once.

Power BI and SAP BW whitepaper

If everything configured correctly and still the issue is persists. Please submit a support ticket to investigate.

don't forget to shar the support ticket number for quick traction on it.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

BR

venal.