Forum Discussion

Kat7's avatar
Kat7
Frequent Visitor
2 years ago
Solved

Connect Desktop Power BI to AWS RDS postgreSQL

I know there are many posts about this issue, but so far, none of the answers have fixed the issue for me.   I'm trying to connect Power BI to an AWS RDS postgeSQL instance.  I've tried from a comp...
  • Kat7's avatar
    2 years ago

    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!