Cannot connect Power Bi Service to PostgreSQL hosted in Azure

Hello, same thing for me, since Tuesday (Mar 26th) too.
All my Dataflows using Postgresql connection returnes this error (Error: DataSource.MissingClientLibrary: Please install Npgsql version 4.0.10.0 or earlier)

The connection is directly in PowerBi Service (app.powerbi), online, so it's not possible to install or downgrade the Npgsql version.

Looking for a solution too !

Also an update from my side, I havber reached out to the powerbi team via our support contracts and showed the issue in a call. They are further investigating it indeed. Looks like the desktop app works fine, also the refreshes when you publish and refresh the report online, so that could be a temp workaround.
As soon as I get more info back from my support contact I'll add a reply to this thread.

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 (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

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... )

Please check if it helps.

Best Regards,
Community Support Team _ Caitlyn

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

I can relate, same issue here since Tuesday (Mar 26th) where one of my dataflows using Postgres returnes the same error (Error: DataSource.MissingClientLibrary: Please install Npgsql version 4.0.10.0 or earlier). As it was created in the MS Managed PowerBI environment (https://app.powerbi.com/) I cannot install anything.

Just got an update from the support team that they have fixed the issue, which I can confirm seeing my datafloiws running again. 

Hi,

Have you already check all the data format inside the program?

Hi HenriqueReis  Can you please elaborate more ?

Hello,

Has there been any update on this issue? I am receiving this same error when trying to connect to postgres through an on-prem data gateway using Power BI Online. 

I can connect on Power BI desktop using Npgsql, however, this doesn't appear to be an option on Power BI Online...

Anonymous Did you find the solution. I have been trying for days, but I could not succeed. Can you please let me know the details?