Connecting PowerBI to PostgreSQL

[Anonymous]

Hi All,

I have been attempting to connect PowerBI to PostgreSQL, however I am receiving the error seen below.

I have followed the steps outlined below.

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)

1. Download the AWS public key from here https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem
2. Convert that to a certificate using https://www.sslshopper.com/ssl-converter.html(convert to PKCS#7/P7B)
3. Import that certificate to the Trusted Room Certificate described here http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm (easier to search for ‘certificates’ and launch ‘Manage computer certificates’)

Even after completing the following changes I am still receiving the error seen above.

Anyone else experienced something similar?

Thanks,

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[v-piga-msft]

Hi @Anonymous ,

Have you installed the PostgreSQL Client in your PC?

Please refer to this blog firstly which introduce the detail steps.

In addition, if you still have this issue, you may try ODBC as a workaround. Please have a reference of this blog.

Best  Regards,

Cherry