a problem connecting wiht postgresql database

[IgorAtRydlab]

When creating a connection to a PostgreSQL DB always receive the following:

"Подробности: "При чтении данных от поставщика произошла ошибка: 'Не удалось загрузить файл или сборку "System.Runtime.CompilerServices.Unsafe, Version=4.0.4.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" либо одну из их зависимостей. Не удается найти указанный файл.'"

which means that it cannot find "System.Runtime.CompilerServices.Unsafe, Version=4.0.4.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

it happens after inserting data on connection, when all connection data is provided and it tries to get data from DB, as I see it.

What should I do to fix this?

[Anonymous]

Hi @IgorAtRydlab,

I think this issue more related to your environment and libraries, please check below links or try to use scan command to fix environment.

Sfc Command (System File Checker)

Microsoft .NET Framework Repair Tool

Regards,
Xiaoxin Sheng

[Tech_one]

Same issue, but on a fresh installation, everything looks good except for connecting to postgres on powerbi

[ianh]

I have this same issue.

Clean install of Windows 10 Pro, Power Bi Desktop (May 18), Npgsql 4.0.0.

I'm attempting to connect to Panoply.io (Postgres).

Ran the .NET repair tool and SFC, no apparent issues.

[IgorAtRydlab · Accepted solution]

it is IgorAtRydlab ...

moved forward from that problem by removing latest npgsql 4.* version and installing previous 3.*.

[ianh]

Thanks,

Also downgraded to Npgsql (3.2.7) and connected successfully.

Ian