New Gateway setup timeout

[Anonymous]

Hi all,

My first post in this forum  

I am trying to set up a OleDb gateway (to a SAS metadata server), but receiving the following error:

Unable to connect to the data source undefined.
Underlying error code:	-2147467259
Underlying error message:	Timeout expired. The timeout period elapsed prior to completion of the operation.

When testing the gateway connection on the server itself it works. Additionally, when I put in dummy credentials I get an incorrect credentials error message - so the gateway server is definitely reaching the SAS server. Additionally we have similar gateway connections to other SAS servers that work (and I have opened all the necessary firewall ports).

Any ideas on a solution?

[v-cherch-msft]

Hi @Anonymous 

Please check if the below article could help you.

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot

Regards,

Cherie

[Anonymous · Accepted solution]

Unfortunately this article didn't help.

However I found the solution - it's true that even establishing the connection via Power BI desktop did take a long time - so the timeout was genuinely a timeout and not another issue.

SAS OleDb driver is generally very slow unfortunately.

Solution: go to <C:\Program Files\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config>, increase test connection timeout value (e.g, 00:02:50) and check if the issue still persists. Please note that after changing the timeout value, gateway service is required to restart.

<setting name="MashupDSRTestConnectionTimeout" serializeAs="String">
<value>00:00:50</value>
</setting>