I am having problem with automatic refresh.

[Anonymous]

I am having problem with automatic refresh. On Desktop version everything works fine. However, when I am trying to set up automatic refresh in website, the error appears. I think there is the problem with PostrgeSQL database because with the other databases no problem with refreshing.

[Anonymous]

Hi @Anonymous ,

Unable to reproduce your issue and have not received feedback on a similar issue to yours.
Did you configure the gateway and credentials correctly?
It would be great if you could provide detailed error messages.

Best Regards,
Community Support Team _ Caitlyn

[Anonymous]

Не удалось обновить учетные данные источников данных: An error happened while reading data from the provider: '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. Gateway is working correctly and credentials also correctly entered.

[Anonymous]

Hi @Anonymous ,

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.

For more you can see this. 

Best Regards,
Community Support Team _ Caitlyn