cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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>
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>

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 275 members 3,121 guests
Please welcome our newest community members: