Power BI Service and Scheduled refresh for Postgre SQL

Hi  Anonymous ,

 The PostgresSQL connector doesn't work out of the box, you need to do quite a few things first

1. Install Npgsql which allows .NET access to PostgresSQL.  I installed it using the Pakagae Manager Console in Visual Studio; detailed instructions are here: https://www.nuget.org/packages/Npgsql/

You need to connect over SSL to AWS which isn't setup by default

2. Download the AWS public key from here https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem

3. Convert that to a certificate using https://www.sslshopper.com/ssl-converter.html (convert to PKCS#7/P7B)

4. Import that certificate to the Trusted Room Certificate described here http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm

5. Test access from Power BI desktop using the PostgresSQL connector and it should work

OR:

You can connect PostgreSQL using ODBC Connection.

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

This is the related document, you can view this content:

https://stackoverflow.com/questions/60102636/power-bi-postgresql-data-import-error-the-remote-certificate-is-invalid-accord

https://www.adoclib.com/blog/an-error-happened-while-reading-data-from-the-provider-the-remote-certificate-is-invalid-according-to-the-validation.html

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.