Help with cloud connection to PostgreSQL RDS

[ls_useradmin]

I solved the same error locally by installing CA from my database (rds-ca-rsa2048-g1), but how can I do it on a new connection (cloud)?

[Anonymous]

Hi @ls_useradmin 

May I ask if my reply above helped you? If it helped you solve your problem, please accept my reply as a solution which will benefit others.

If any other help is still needed, please feel free to contact me.

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

[Anonymous]

Hi @ls_useradmin 

May I ask if your problem has been resolved? If not, I suggest you check the following:

1. Verify credentials, double-check that the username and password you are using are correct. Ensure there are no typos or extra spaces.
2. If your PostgreSQL RDS instance requires SSL, make sure you have the correct SSL certificates installed. You might need to download the AWS public key and convert it to a certificate format that Power BI can use.
3. Update all necessary drivers (like Npgsql for PostgreSQL) and reconfigure connection.

Please refer to this blog to configure the connection from scratch: Connection of Power BI with RDS PostgreSQL on AWS from Scratch | by Vikas Thamke | Medium

Here are simialr cases for your reference:

Solved: How to connect to a postgreSQL instance on AWS RDS - Microsoft Fabric Community

Solved: PowerBI RDS PSQL Connection - Microsoft Fabric Community

Solved: The remote certificate is invalid according to the... - Microsoft Fabric Community

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

[djurecic]

Hi @ls_useradmin ,

 This thread might be helpful to you:

https://community.fabric.microsoft.com/t5/Desktop/Connect-Desktop-Power-BI-to-AWS-RDS-postgreSQL/td-...