Forum Discussion

AishwariyaV's avatar
AishwariyaV
Helper IV
5 years ago

Error while scheduled refreshing

Hi All,   I am using postgresql db and the dataset size is in millions. We have published the report and scheduled for data refresh on all saturdays.    The automatic refresh fails all the time, ...
Need Help
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey AishwariyaV ,

 

where is the postgresql server? On premises or in the cloud?

If on premises did you set up the gateway properly? If in the cloud where exactly (Azure, AWS, VM)?

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • AishwariyaV's avatar
    AishwariyaV
    Helper IV
    5 years ago

    Hi selimovd ,

     

    The postgresql is in AWS.

    • selimovd's avatar
      selimovd
      Most Valuable Professional
      5 years ago

      Hey AishwariyaV ,

       

      did you set up the AWS environment like it's recommended from Amazon for Power BI Service?

      Check the following whitepaper from page 14 on ("Connecting the Microsoft Power BI service to
      AWS data sources"):

      https://d1.awsstatic.com/whitepapers/using-microsoft-power-bi-with-aws.pdf

       

      If you need any help please let me know.
      If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
       
      Best regards
      Denis
       

       

      • AishwariyaV's avatar
        AishwariyaV
        Helper IV
        5 years ago

        Hi selimovd ,

         

        I am not sure in which server the gateway resides, but then if there is something wrong with the setup, it shouldn't work on manual refresh also right?