How to fix Invalid Certificate on postgresql server.

Hi croberts21 ,

The problem can arise for several reasons, and in my opinion, you can use the following alternatives.

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/

To learn more details ,refer:

https://stackoverflow.com/questions/53921336/an-error-happened-while-reading-data-from-the-provider-the-remote-certificate-i 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien