Error connect gcp postgresql to power bi

[Doomemy]

I try to connect my DB, host on GCP cloud sql but i got this error.

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

[v-luwang-msft · Accepted solution]

Hi @Doomemy ,

This was resolved after following the steps below ( Original link on - https://community.powerbi.com/t5/Integrations-with-Files-and/Connecting-to-PostgresSQL-hosted-on-AWS... )

@v-yuezhe-msft 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 (on my Windows 10 machine anway)

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

In conclusion it's possible to connect to PostgresSQL on AWS RDS databases but it isn't easy

To learn more details ,you could read the following articles:

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

Best Regards

Lucien

[amitchandak]

@Doomemy , Have you imported SSL certificate to windows.

do not miss any of the step listed in these solutions

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/