Forum Discussion

amitgawali's avatar
amitgawali
Frequent Visitor
8 years ago
Solved

Scheduled refresh does not work in Power Bi Pro

Hi,

 

I am using Power BI for reporting and I have AWS host in which my database resides. I have installed Data gateway and successfully configured it with Power BI, also I have set data refresh for frequent time interval. But after few hours, I see that data gateway goes offline and does not perform refresh task.

Below screenshot mentiones refresh failed message.

 

Also I get these emails for refresh failed:

Can anyone please help?

  • Today it is working fine for all time intervals. Letss. If any issues occurs I will put here..

    Thanks.

6 Replies

  • bajee's avatar
    bajee
    Icon for Kudo Kingpin rankKudo Kingpin

    amitgawali

     

    Are you able to Refresh DataSource from your Power BI Desktop.Check wheather AWS instance is running or not, If AWS instance is running check gateway configuration.

     

    Regards,

    Bajee.

    • amitgawali's avatar
      amitgawali
      Frequent Visitor

      Yes, I am able to refresh the data from Power BI Desktop(by click of Refresh button, as I dont see any scheduled refresh option in Desktop version).

      My AWS instance is also running.

      I have also checked Gateway configuration by Settigs->Manage Gateways. Everything seems fine, but after 2 hours the data gateway goes to sleep.

      • bajee's avatar
        bajee
        Icon for Kudo Kingpin rankKudo Kingpin

        amitgawali,

         

        We do not have scheduled refresh option in Desktop.

         

        Which version of power BI gateway are you using.Please download the latest version and try to re-configure the Gateway.

         

        Regards,

        Bajee.

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI amitgawali,

     

    Based on your screenshots, it obviously told us that: power bi can't reached your gateway.


    It may caused by follow reasons, server closed, gateway service stopped, network related issues...etc

    Please double check on above options to ensure power bi can access your gateway.

     

    Regards,

    Xiaoxin Sheng

    • amitgawali's avatar
      amitgawali
      Frequent Visitor

      Today it is working fine for all time intervals. Letss. If any issues occurs I will put here..

      Thanks.