I going around in ever deceasing circles trying to use auto refresh to get data from a PostGreSql table on Amazon AWS database.
In the model I have a small number of static data files which are stopped from refreshing automatically.
The only table that I am trying to refresh is the PostGreSql table on the Amazon AWS server. The message I get is that the credentials are missing yet I cannot find out how to correct them.
It seems you already use PBI Gateway to connect to PostGreSQL. Can you try the 3 alternative ways to connect to PostGreSQL from Power BI? Also, on AWS, have you added a rule on the firewall to allow Power BI Service’s IP address to connect to AWS.
Apologies for reviving an old thread, but I couldn’t help but notice your post about the issue you’re facing with auto-refreshing data from a PostGreSql table on Amazon AWS. It can be quite frustrating when credentials go missing but fear not. There might be a solution out there. Recently, while browsing online, I came across some interesting Developing on AWS courses that could provide valuable insights and potentially help you troubleshoot your problem. It’s always great to expand our knowledge, especially in the world of technology. So why not give it a shot?