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.

[lucasnbezerra]

I'm also having the same problem, but I don't use Azure, but rather Oracle. The data is being updated normally, but when I try to check the status in 'Manage connections and gateways', the message below appears.

New projects published, I can't schedule updates or change existing ones. I noticed on 09/16 when this started happening.

-------------------------------------------------

Status
Offline - Unable to retrieve the status. Check your connection and try again. Contact Microsoft support if the problem persists.

Here are some details about the reason for the "offline" connection status. Contact Microsoft support and include the information below in your ticket

----------------------------------------------

Error Code: DataAccessError
Connection error: Data access error
Cluster URI: https://api.powerbi.com
Session ID: XXXXXXXXXXXXXXXXXXXXXXXXXXX
Request ID: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

undefined: 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.'

[AndersonCruz]

Aqui também estou enfrentando esse mesmo problema. Reparei ontem também.

Alguem ja descobriu alguma solução?

[dasv]

Same issue as above, occured a few days ago for a client. During the same time it worked for me as well (in another tenant) when trying to re-create the issue, the next day it stopped working for me, so I am thinking it could be region/cluster specific.

Status code: 400
Time: Wed Sep 18 2024 11:51:51 GMT+0200 (Central European Summer Time)
Service version: 13.0.24209.56
Client version: 2409.2.20860-train
Cluster URI: (wabi north europe cluster)

Best regards 

[v-yetao1-msft]

Hi @zeromero 

We have seen on the internal platform that other engineers have reported this issue and submitted it. 

The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient!

Possible mitigation measures given by PG: 

1.  Reuse an existing shared Cloud connection to connect to PostgreSQL Create and share cloud data sources in the Power BI service - Power BI | Microsoft Learn
2. Create a new connection in Dataflows and use this new connection while connecting to PostgreSQL
3. Create a connection using a Data Gateway

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Junyi]

Hi Community Support Team _ Ailsa Tao,

The existing PostgreSQL connections do not work (they appear offline) and Power BI Service does not allow to create new PostgreSQL cloud connections (see attached image).

Do you have an ETA to solve the issue?

[brent_smith]

This is similar to what I'm encountering also. Trying to create a new shared connection fails  - 

Error Message: "Unable to create connection for the following reason: Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred... etc. " 

[annaboryla]

Is there any update on the issue?

[bgd]

Hello,

We are having the same problem.

Best regards,

[rish]

We’ve encountered the same issue. It’s puzzling because our current schedule completes successfully, and manual refreshes of the online Power BI reports work fine.

However, this problem prevents us from changing any schedule times or days.

I completely agree with @zeromero. This is the main reason we’re using Azure PostgreSQL—to avoid extra setup.

We sincerely hope this gets resolved soon.

[zeromero]

Same behavior here. Datasets that were previously configured and working until yesterday are still functioning fine, but any changes or the addition of a new dataset trigger the error.

[DSpotBI]

We are having the same issue while patching our datasets and reached out to the support team. After a long debug session and submitting all the diagnostic logs we finally heard back today that the Power BI product team is working on a fix.

[jknavarro]

We are experiencing same issue.

Any update on this?

[robinho55]

Hi,

We are also experiencing this problem. I am receiving the exact same error message:

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.'

Is there any update or workaround to resolve this?

[PeterYacoub]

Same behaviour suddenly today. What is the ETA to resolve this??

[durriya]

Any update on this?

[costa3smoney]

we have same issue since this morning.

[annaboryla]

We are experiencing same issue, until yesterday it worked perfectly... 

[v-yetao1-msft]

Hi @zeromero 

Please try and check the below things 

1) Install latest gateway (if not already installed)

2) Install PostgreSQL driver

3) Create a data source for PostgreSQL in gateway

4) Map data source to Dataset in the dataset settings page
In short, you have to install latest  version of NpgSQL and when installing, select the NpgSQL GAC option. The article I linked has a more detailed step-by-step guide.
https://powerbipoint.com/2024/01/22/fix-power-bi-refresh-error-could-not-load-file-or-assembly-or-on...

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[zeromero]

Hi @Ailsa Tao,

As I mentioned in my previous message, I am using the Azure PostgreSQL database precisely to avoid the need for an on-premises data gateway. When using the gateway, everything works as expected, but the advantage of Azure is to eliminate the need for this extra setup.

This same issue occurred a few years ago, and at the time, Microsoft identified the problem, provided a 15-day resolution window, and suggested using the gateway temporarily while they worked on a fix.

I have several clients connected to my database, and installing the gateway for each of them is not a viable solution.

The purpose of my message is to find out if others are experiencing the same problem and if Microsoft or the Power BI team is already aware of it. I’ve tried everything I can on my side. I’ve created a new database, tested with another tenant, and the issue persists.

Any insights from the team would be greatly appreciated.

Best regards,
Jose Romero

[MikeUpsideDown]

We use Azure PostgreSQL for us and our customers for this exact reason as well.  We had Microsoft run maintenance today which took long enough for 4 refreshes to fail and now can't get automatic refresh back on for a mission critical dashboard.  

Responses like use the gateway show a total lack of understanding of the problem.