Error while connecting PostGres to Power BI

[Gandhar09]

I'm trying to connect my Power BI Desktop to Post Gres SQL. 
I get the following error when I tried to connect. 

Details: "Loading assembly file 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'PostgreSQL'"

With the same credentials, im able to connect to the MY SQL workbench

[v-jianpeng-msft · Accepted solution]

Hi, @Gandhar09 

First, you can check if the current version and the NET Framework are compatible. To use this connector, you can check if you fulfill the current requirements:

Power Query PostgreSQL connector - Power Query | Microsoft Learn

In the case below there is feedback from other community members that there is an incompatibility when connecting at version 4 and above:

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

You can also check the case below:

Postgre SQL x Power BI - System.Runtime.CompilerSe... - Microsoft Fabric Community

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

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

Best Regards

Jianpeng Li

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

[d_o_]

Thank you for the solution. I unistalled the lastest version and re-installed previous version npgsql 4.0.10.

Re-starting the system after doing this was helpful. Thank you!