Forum Discussion
Error connecting to PostreSQL
Anonymous , Please makse sure you not missing driver, certificate or any other step
https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/
https://niftit.com/connecting-power-bi-to-postgresql/
- Anonymous4 years agoNot applicable
I have tried these steps previously and I still get the same error.
The database is hosted by a 3rd party, in order to access the database via PG Admin or DBeaver we have to use a different server string (port and database remain the same).
If I use this different string, I get the below:
"An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'"
This implies (to me) that I am missing a certificate in order to confirm that my connection is legitimate?
Thanks fo the earlier response.