Help with Power BI Desktop Connection to PostgreSQL on Amazon RDS via SSH - Connection Failed Error

Hi, D17 

Make sure your SSH tunnel is configured correctly. You can use PuTTY or OpenSSH to create tunnels. Also check your security group settings again to make sure that inbound traffic from your local machine IP address to port 5432 is allowed. At the same time, make sure that there are no local firewall settings blocking the connection.
Amazon RDS for PostgreSQL enforces SSL connections. Make sure Power BI is configured to use SSL when you try to connect. 

Power BI requires an Npgsql driver to connect to PostgreSQL. Make sure the driver is installed and configured correctly on your machine. You can check this post:

Solved: Connecting to PostgresSQL hosted on AWS RDS? - Microsoft Fabric Community

When setting up a connection in Power BI, use the appropriate connection string format.  You can refer to the following post:

Solved: Connect Desktop Power BI to AWS RDS postgreSQL - Microsoft Fabric Community

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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