An error happened while reading data from the provider. The remote certificate is invalid according to the validation procedure

Question

I'm trying to connect Postgres Database on AWS EC2 instance to Microsoft PowerBI. I tried various method available on internet but its showing the above error. Although I've done this connection on AWS RDS. I installed required dependencies (GAC) and all the certificates required for PowerBI.

Answer 1

Following worked for me:

File / Options and settings / Data source settings

then select data source

and Edit Permissions and uncheck encrypt connections

Answer 2

I've came across the same issue, unfortunately I didn't find solution to resolve it. But I found an alternative.

You can connect PostgreSQL using ODBC Connection.

Setup ODBC for PostgreSQL: https://www.postgresql.org/ftp/odbc/versions/msi/

After Installation, Select ODBC Connection under "Get Data"

Select "None" under Data Source Name and add following statement under connection string:

Driver={PostgreSQL ANSI(x64)};Server=<host>;Port=5432;Database=<dbname>

Click "Next"

Enter Username and Password, Click Connect. If credentials are correct, you will see list of tables available in database.

Follow this reference for detailed description: http://niftit.com/connecting-power-bi-to-postgresql/