Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dataset not refreshing automatically

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 c...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.