Forum Discussion
WBackOffice
4 years agoFrequent Visitor
Connect AWS RDS postgresql base to power bi
Hello Community, I am trying to configure the update schedule of the datasets of the reports that have been uploaded to the workspace. However, when I try to configure a DataSource, which in PowerBI...
ibarrau
4 years agoSuper User
Hi. I had some issues for that connection too some years ago. You need to configure a certificate in the VM hosting a gateway. I know that postgres can get rid of gateway nowadays, but I'm not sure you can get rid of it if it is hosted in AWS.
This is what I have done years ago. I had created an EC2 with a Standard Gateway and configure it:
https://blog.ladataweb.com.ar/post/187904496250/conectar-power-bi-a-rds-postgres-en-aws
Then I was able to connect Power Bi Service to RDS Postgres.
I hope that helps,