Issue with Power BI Online Connection to Azure PostgreSQL - Missing Assembly 'System.Runtime.Compile

[zeromero]

I am experiencing an issue when trying to connect Power BI Online to my Azure PostgreSQL database. The error message I receive is:

Failed to update data source credentials: An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.' Activity ID: ff4337ed-2f6e-4865-9c33-5c843b9568ae Request ID: a6dc0300-c46a-f794-1488-7d735cecfb51 Status code: 400 Time: Tue Sep 17 2024 01:28:57 GMT-0300 Service version: 13.0.24209.56 Client version: 2409.2.20860-train Cluster URI: 

The error seems to indicate that a required assembly or dependency is missing in the connection between Power BI Online and Azure PostgreSQL. As this is a cloud service, I do not have control over installing drivers or managing dependencies.

Could you please provide guidance on how to resolve this issue in the Power BI Online environment?

Thank you for your assistance.

[ehasin_atd]

Same issue, when trying to connect to a PGSQL DB hosted on AWS...

Microsoft, please advise.

[GL_1978]

Same issue,
I'm using Power BI Desktop dataset connected to Azure Database for PostgreSQL.
I can refresh my data in Power BI Desktop dataset with same credentials to PostgreSQL PRD and I can SELECT same database from Azure Data Studio with same DB user credentials. 
In this dataset I have also connection to other PBI dataset via Direct Query to specific table from it .
After publishing of same dataset to Power BI Services I'm recieving same error: 
 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'
@Microsoft @support 

[KNO]

Same issue, tried installing npgsql  v4.1.14  but with out luck. The error now shows up in desktop. Before it showed up in App service.

"Assemblyfilen 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' blev ikke indlæst for datakildetypen 'PostgreSQL'"

[boble2302]

Has Microsoft published something about this issue? It looks the issue is coming from the backend of PowerBI Service. @Microsoft @support

[costa3smoney]

might be something to do with CA certificates update for postgre services in august, if they use certificate pinning they will not be able to connect in case they forgot to update it

[prashantsurana]

We are experiencing the same issue, Any update on this?

[maom]

I'm facing the same issue. In Power BI Desktop, the connection works perfectly. However, when I try to schedule the refresh in Power BI Service, I encounter an error related to the connection with the PostgreSQL database.

[JoseMoreno]

Hello,

We have been experiencing the same issue since last week, and our clients are concerned because they cannot access the BI Dashboard. Microsoft has not provided a solution for this problem, which raises concerns that they may be pushing our clients towards Tableau.

Best regards,

[hildebolt]

We are currently having the same issue and would greatly appreciate an update as to when this will be addressed. 

[abhinav-gupta-s]

Facing same issue I guess

An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.'

[Danito90]

Tengo el mismo problema para realizar las actualizaciones automáticas hacia una base de datos PostgreSQL alojada en un servidor web. Las actualizaciones manuales sin embargo si funcionan, solo fallan las automáticas:
* Error: No se pudieron actualizar las credenciales de origen de datos: An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=6.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxxx' or one of its dependencies. The system cannot find the file specified.'

Espero pronto aparezca la solución... Saludos!

[lucasnbezerra]

@v-yetao1-msft 

Do you have any news about the solution to this problem we are facing?

[makishimu]

same here - please fix ASAP!

---

Failed to update data source credentials: An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=6.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxx' or one of its dependencies. The system cannot find the file specified.'Hide details

---

[jost]

It's insane, that this problem still persits, when can we expect a solution?

This is very urgent to many customers, nobody can activate or change the refresh policy for PG connections in semantic models atm!

[Rohith_Kanathur]

About a week ago, I was able to connect to Azure Database for Postgres - Flexible Server from app.powerbi.com (Power BI Service) with no issues.

The Power BI report published was in direct query mode and I did not have to use a gateway.

Now I am getting this error:

Failed to update data source credentials: An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=6.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxxxxxx' or one of its dependencies.

The system cannot find the file specified.'Hide details
Activity ID: xxxxxxxxxxx
Request ID: xxxxxxxxxxx
Status code: 400
Time: xxxxxxxxxxx
Service version: xxxxxxxxxxx
Client version: xxxxxxxxxxx
Cluster URI: xxxxxxxxxxx

This problem does not occur if a data gateway is used. However, this is not an option for me.
Plus microsoft itself claims this:

Could you please look into this?
Thanks

[amrashrafyw]

Known issue - PostgreSQL data source connections additions or updates fail - Microsoft Fabric | Micr...

this has been added to known issues

[gsmith]

postgres is a core technology in modern cloud computing. This needs fixed ASAP. Causing a lot of problems for a lot of people.

[cpetro]

Both of my postgres connections in a report are broken with this same error.  They refresh fine in PBI Desktop.  Adding another datapoint.  Please fix.  Thank you. 

[JoseMoreno]

Hi Team,

I've been facing the same issue since Monday this week. While I can successfully connect via Power BI Desktop, the connection from Power BI on Azure Web continues to fail. I suspect this may be related to a platform issue on Microsoft's side.

Could you please look into this?

Best regards,

[sofsys]

Mine doesn't run even on Power BI Desktop... 

[rob_9]

Began receiving the same message this morning also via the service, I got an encrypted error if refreshing via desktop. Have you been notified of any solutions yet? Or is this a PBI issue awaiting a fix?