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

New Gateway setup timeout

Hi all,

 

My first post in this forum Smiley LOL 

 

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?

1 ACCEPTED SOLUTION

Accepted Solutions
ollywolly Frequent Visitor
Frequent Visitor

Re: New Gateway setup timeout

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>

View solution in original post

2 REPLIES 2
v-cherch-msft Super Contributor
Super Contributor

Re: New Gateway setup timeout

Hi @ollywolly 

 

Please check if the below article could help you.

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

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ollywolly Frequent Visitor
Frequent Visitor

Re: New Gateway setup timeout

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>

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 55 members 1,279 guests
Please welcome our newest community members: