Having trouble with intermitten connectivity to a postgres instance hosted by AWS. It is similar to the outage experienced last week that was temporarily resolved. Can connect occasionally but not c...
I have the same issue with Postgres except it is not hosted on AWS. The dataset refreshes perfectly every time in Desktop.
Key findings:
In the service it refreshes correctly approximately 50% of the time.
It doesn't seem to matter whether the refresh is manual or scheduled.
Only one table is affected which is limited to 1000 rows retrieved rather than the full dataset. The rest of the tables come through complete.