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,
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.