topic Re: Error while connecting PostGres to Power BI in Report Server

Error while connecting PostGres to Power BI

Gandhar09 — Tue, 09 Jul 2024 20:16:48 GMT

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

Re: Error while connecting PostGres to Power BI

Anonymous — Wed, 10 Jul 2024 01:53:23 GMT

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.

Re: Error while connecting PostGres to Power BI

Anonymous — Fri, 09 Aug 2024 09:31:18 GMT

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!