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!
This is still a big issue in my company, not being able to use the native PBI PostgreSQL driver with our AWS RDS PostgreSQL instance.
This is because we need to use Direct Query but it's not possible due to this errors that i see on every post on this topic.
The error I see is:
Unable to connect
We encountered an error while trying to connect.
Details: "An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'"
I do not see why this driver should not work with AWS RDS PostgreSQL, does it only work with Azure Database for PostgreSQL?
It would be really disappointing.
Has anyone ever make this driver work or just using ODBC?
Thanks
Kat7 's solution works, use it