Forum Discussion

raymond's avatar
raymond
Post Patron
5 years ago
Solved

Automated Refresh with Gateway to AWS PostgreSQL not working

Hi everyone,

 

I have a couple of Databasis on AWS. Due to cost issues I have a script to automatically start the databases, update everything, and stop them afterwards. The timewindow is approx. 3 hours.

 

Within those 3 hours I want to schedule a refresh. However it is not working. There is a corrctly configures Gateway to AWS. If I manually start the database I can easily jump to the power bi Service and update the dataset manually without any issues. 

 

BUT if I schedule a refresh to the time window where the Database comes online, it wont work. Every time I get an error message that the gateway or server did not respond?

 

Does anyone experience the same? How did you treat that issue?

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi raymond ,

     

    Could it be that your self-start script execution time conflicts with the Power BI scheduled refresh time?

    You need to perform plan refresh after the script is executed.

     

    Best regards,
    Lionel Chen

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

     

2 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi raymond ,

     

    Could it be that your self-start script execution time conflicts with the Power BI scheduled refresh time?

    You need to perform plan refresh after the script is executed.

     

    Best regards,
    Lionel Chen

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