Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

New Gateway setup timeout

Hi all,   My first post in this forum :smileylol:    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 sour...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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>
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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>