powerbi postgres connector - remote certificate is invalid

[Anonymous]

Hello,

I keep getting errors trying to connect to a postgres SQL rds.amazonaws.com.
I have looked all around the places and tested but none seem to work. The only way i can get it working is by edit permission - untick encrypt connection and reconnect it again. The only issue with this is that not all the data/tables are shown. I been spending the last week trying to connect, restart PC , and installed drivers but nothing work. 

I can connect this on tableau postgres connector without any issues in less than 10 seconds - I just don't understand why it's so difficult with powerbi postgres connector. The only thing i noticed is that powerbi postgres connector doesn't require a port number so this might be the problem it causing? But i have no idea how to insert a port number if there is no box for this within powerbi progres connector.

Now through odbc driver.

[v-zhangti]

Hi, @Anonymous 

Please refer to the following link, hope it can help you.

https://community.powerbi.com/t5/Desktop/How-to-fix-Invalid-Certificate-on-postgresql-server/m-p/2170911 

https://community.powerbi.com/t5/Desktop/The-remote-certificate-is-invalid-according-to-the-validation/m-p/531475#M249069 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Veerendra-Uppar]

• But when we published in bi service it is considering that odbc rdbms is local connection not cloud 

[amitchandak]

@Anonymous , please refer to the steps in these solutions. do not miss any steps

https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/
https://niftit.com/connecting-power-bi-to-postgresql/