Can't connect Gateway to dataset -Timeout expired. The timeout period elapsed

[jfenico]

Have not been able to get our gateway working correctly. Here is the scenario:

Newest gateway installed

Connection is good - using HTTPS

Gateway is on server 1 - It connects to two datasets, one dataset on server 1, another on server 2.

The gateway can talk to the dataset on server 2 but not server 1 (itself).

When trying to connect to the dataset on server 1 - I get the following error: "A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"

Both servers are on the same network, I can run a query within Power Bi Desktop and connect to both sources without an issue.

[v-yulgu-msft]

Hi @jfenico,

What is the data source hoseted on server1?

Please use the Fiddler to monitors HTTP traffic, to get more detailed error messages when establishing the connection between gateway and server1.

Regards,

Yuliana Gu

[jfenico]

Hello @v-yulgu-msft

Both data sources are from separate MySQL databases.

I will take a look at the Fiddler program to see if it shows anything.

[jfenico]

@v-yulgu-msft

Not seeing anything out of the ordinary as of yet but will keep looking.

Side question - is there a way to change the default timeout time of 60 seconds for the gateway? I know you can within Power Bi Desktop when querying but I don't think the two are related.

[jfenico · Accepted solution]

 I believe I figured out the issue but wanted to post the solution for others who run into the same problem have something to try.

Go to the station that has the gateway installed

Go to C:\Program Files\On-premises data gateway (or the appropriate location of your gateway install)

Open Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config (you may want to create a copy and save it on your desktop just in case we need to revert settings)

Look for the following setting, it is towards the bottom -     

<setting name="MashupDSRTestConnectionTimeout" serializeAs="String">

<value>00:00:50</value>

Change the value from 00:00:50 to 00:01:50

Restart the gateway.

Try adding the data source to your gateway.

[Anonymous]

What does MashupDSRTestConnectionTimeout actual do?

[jfenico]

Hi Rob,

It was my impression that this would increase the timeout amount allowed for when the Power Bi Gateway would talk to your on-premise data source, however after further testing I'm not so sure it does much. Your mileage may vary however. Always keep an initial copy of the config file if you're going to make changes.

[Anonymous]

Thank you for the response. I will give this a try. I just feel that MS with possibiliy due to the recommendation of not touching the config files, does not have any documentaiton about the timeout parameters mentioned within the file.