Dataset not refreshing automatically

[Anonymous]

I have a problem with schedulled refreshing on https://app.powerbi.com/  I have 2 connections to PostgreSQL databases. On PowerBI Desktop version everything works well. However, when I am trying to connect these 2 databases appearing error. I entered correct credentials. Also, I have on-premises gatewat installed on my PC personal mode version. Error: Failed to update data source credentials: 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. 

 

[Anonymous · Accepted solution]

Hi @Anonymous ,

This error message indicates this is a connection problem between Gateway and remote server.

To test if the gateway has access to all the required ports, please run the network ports test. The test results list all the servers, ports, and IP addresses that your gateway requires. If the test results display "Closed" for any ports as shown in the error message, ensure that your network environment didn't block those connections. You might need to contact your network admin to open the required ports.

Generally, this problem is related to connectivity to Azure Service bus or a block port in your firewall, please test connectivity to Azure Service bus following the guide in this article and check your firewall with this .

A firewall might be blocking the connections that the Azure Service Bus makes to the Azure data centers. If that's the case, unblock the IP addresses for your region for those data centers. You can get a list of Azure IP addresses from this website. To find the current data center region you're in, see Set the data center region.

Hope it helps,

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Are you using a gateway?  Can the gateway cluster members see the database server and the database?

[Anonymous]

Yes, I use personal gateway. Nobody else can see the the database.

[lbendlin]

Is the gateway installed on the same PC as Power BI desktop?

[Anonymous]

Yes.

[lbendlin]

any kind of firewall installed on your PC that would prevent the gateway app from being able to reach the database?