Forum Discussion
postgreSQL RDS Not refreshing on power bi web
It seems to be a specific problem with postgresql. As soon as I switched to RDS's mysql, the problem was fixed.
Hi. Working with RDS postgres and powerbi has some tricks for remote certificates at the VM with the Gateway. You need a gateway because of the certificate. You can check this post out in order to follow the process.
https://blog.ladataweb.com.ar/post/187904496250/conectar-power-bi-a-rds-postgres-en-aws
I hope that helps,
Thanks for the answer.
The problem with Gateway is that I need it to be based on my computer. How can I make it not be based on my desktop?The best approach here would be turning on an EC3 over AWS. If you are already working with AWS then a VM on the same cloud would help to keep the data flowing fast over the cloud.
I hope that helps,
If I switch to MySQL it should solve the problem and I won't have to use Gateway?
I'm not sure. But i would say no. The certificate requested here is because you are using AWS RDS database, it's not something about postgres specially. If you are working in an analytics project, the alternatives for non gateway at AWS are redshift and databricks. If you are working for a transactional database I honestly don't know which one could work without a gateway.
I hope that make sense
It seems to be a specific problem with postgresql. As soon as I switched to RDS's mysql, the problem was fixed.