Power BI Gateway Unable to Refresh Datasets from SAP BW due to TIMEOUT

[RobertD]

We recently changed out SAP BW hosting from an on premises VM to an Azure VM. With the move some latency was introduced to our data movement. Now we're periodically (50% of the time) seeing our datasets fail to refresh on reports that usually take 10 to 20 minutes to refresh. The following error is reported by the gateway:

Underlying error code:	-2147467259
Underlying error message:	SAP Business Warehouse: LOCATION CPIC (TCP/IP) on local host XXXXX-XXXX with Unicode ERROR connection to partner 'xx.xx.xx.xx:3300' broken TIME Thu May 20 13:10:35 2021 RELEASE 721 COMPONENT NI (network interface) VERSION 40 RC -6 MODULE nixxi.cpp LINE 5088 DETAIL NiIRead: P=xx.xx.xx.xx:3300; L=xx.xx.xx.xx:56314 SYSTEM CALL recv ERRNO 10054 ERRNO TEXT WSAECONNRESET: Connection reset by peer COUNTER 4 RETURN CODE: 20
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:	SapBusinessWarehouse
Microsoft.Data.Mashup.ValueError.DataSourcePath:	xxxxxx/00/400
Microsoft.Data.Mashup.ValueError.ErrorCode:	101
Microsoft.Data.Mashup.ValueError.Message:	LOCATION CPIC (TCP/IP) on local host XXXXX-XXXX with Unicode ERROR connection to partner 'XX.XX.XX.XX:3300' broken TIME Thu May 20 13:10:35 2021 RELEASE 721 COMPONENT NI (network interface) VERSION 40 RC -6 MODULE nixxi.cpp LINE 5088 DETAIL NiIRead: P=XX.XX.XX.XX:3300; L=XX.XX.XX.XX:56314 SYSTEM CALL recv ERRNO 10054 ERRNO TEXT WSAECONNRESET: Connection reset by peer COUNTER 4 RETURN CODE: 20
Microsoft.Data.Mashup.ValueError.Reason:	DataSource.Error
Cluster URI:	WABI-WEST-US-redirect.analysis.windows.net
Activity ID:	54454858-f9a8-4f25-abc0-c4b5959ffce8

I need to figure out where the connection is being reset. I've looked at the Gateway server, the firewall, the AV exceptions. They all see the connection closing but don't take credit. If it's in SAP BW there's no way to tell. 

[v-easonf-msft]

Hi, @RobertD 

This  generic error  may not be related to PowerBI.

WSAECONNRESET: Connection reset by peer... 

It can be caused by a multitude of reasons.

1. Paramenters for timeouts may be set incorrectly.
2. The network has issues. (firewall ,routers, hubs, etc…)

3. connectivity problem in between Application Server and Database Server.

...

You'd better open a support ticket with MSFT/SAP engineer to check it, usually they will have better suggestions.

Best Regards,
Community Support Team _ Eason