Can't connect to posgresql databases

[dudea]

Hello,

I have been unable to connect to any postgresql databases after my windows 11 updated 2 weeks ago, I was able to connect to postgres databases before that. I get this error whenever I try to connect: 

Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)'"

[v-yangliu-msft]

Hi  @dudea ,

You can try the following:

Ensure that the .NET Framework is up to date, Windows Updates can sometimes cause a mismatch if the .NET Framework version does not match that of the application.

Try reinstalling Npgsql to ensure that all of its dependencies are properly aligned. The Npgsql library is the .NET data provider for PostgreSQL and updates or other changes may have corrupted its installation.

This may be related to the rollout of registry key:

Solved: Latest Update Creates Login Error - Page 2 - Microsoft Fabric Community

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

Error connecting to PostGresSQL db - Page 2 - Microsoft Fabric Community

Solved: Unable to start Power BI Desktop. Could not load f... - Microsoft Fabric Community

Solved: Could not load file or assembly 'Newtonsoft.Json, ... - Microsoft Fabric Community

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.

[amitchandak]

@dudea , You might have these step again

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/