Forum Discussion
Connect Desktop Power BI to AWS RDS postgreSQL
- 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!
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!
Thank you very much, it works