I am trying to connect Power BI Desktop to an AWS RDS PostgreSQL database. The setup works fine in the test environment where the database is publicly accessible with appropriate inbound rules. However, in the production environment, the database is private and not exposed to the public.
To connect to the private database from my local machine, I am using SSH tunneling to an EC2 instance. The SSH tunnel redirects the local port to the RDS PostgreSQL instance. Here are the details of my setup:
Current Setup:
- SSH Tunnel Command: ssh -i file.pem -L 5433:db_host:db_port ec2-user@IP
Additional Information:
-
I have installed the AWS RDS root certificate on my local machine.
-
I am able to connect to the database using pgAdmin with the same SSH tunnel and SSL settings.
-
However, when I try to connect using Power BI Desktop, I encounter the following error:
Troubleshooting Attempts:
- Verified the SSH tunnel works by connecting through pgAdmin.
- Downloaded and installed the AWS RDS root certificate on the local machine.
- Tried various permutations of entering connection details and SSL settings in Power BI.