Forum Discussion
Connect Desktop Power BI to AWS RDS postgreSQL
For anyone experiencing this issue, this is how I got it working:
1. Install the latest version of psqlodbc (https://www.postgresql.org/ftp/odbc/versions/msi/). Originally I had an older version of this software, and it didn't have the required drivers.
2. Open ODBC Data Sources (64-bit)
3. Under User DSN, add a new source, and select the PostgreSQL ANSI(x64) driver.
4. Configure the connection:
-The database value was not the db-identifier listed in the AWS RDS console, but the individual database name within the instance.
- The server and port values are the endpoint name and port listed in the RDS console.
- The username and password are an account that has the ability to access the database.
5. Save and test the connection to make sure it works.
6. In Power BI, add a new source using the ODBC connection.
6. Select the data sourcce you just created in ODBC.
7. When it asks for credentials, use the same ones you entered in ODBC.
8. Power BI should then load the database in the Navigator window.
Hope this helps!
Hi, Kat7
You can check your firewall settings and make sure that you don't have any local firewall settings blocking connections between Power BI and RDS in addition to AWS security groups.
Try using PostgreSQL's command-line tool to connect to RDS from the same machine to troubleshoot issues specific to Power BI.
If encryption is turned off in Power BI, make sure that the RDS instance is also configured as a non-encrypted connection.
Hopefully, the links below will be helpful to you:
Connecting Power BI to AWS RDS PostgreSQL - Saurabha Joglekar
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.
I turned the firewall off on the server with Power BI to ensure that wasn't an issue.
I am able to connect to the database through SQL Shell, but I'm still getting the same error message in Power Bi.