Forum Discussion
Issue with Power BI Online Connection to Azure PostgreSQL - Missing Assembly 'System.Runtime.Compile
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.
Good afternoon everyone! Check your reports because the error is solved. At least in my case where I connect to a base that is located on a web server.
Greetings!!
61 Replies
- gsmithAdvocate I
postgres is a core technology in modern cloud computing. This needs fixed ASAP. Causing a lot of problems for a lot of people.
- cpetroAdvocate I
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.
- annaborylaFrequent Visitor
We are experiencing same issue, until yesterday it worked perfectly...
- jostFrequent Visitor
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!
- cpetroAdvocate I
Instead of adding this issue to "known issues," couldn't Microsoft simply review what code changed and revert it? This is incredible. We're paying X thousands of dollars per month for PowerBI and Microsoft adds a previously working critical feature to known issues instead of prioritizing, reverting, and fixing.
- rishAdvocate I
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.
- zeromeroAdvocate I
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.
- DSpotBINew Member
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.
- lucasnbezerraRegular Visitor
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.' - JoseMorenoAdvocate I
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,
- sofsysNew Member
Mine doesn't run even on Power BI Desktop...
- AnonymousNot applicable
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: xxxxxxxxxxxThis 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- AnonymousNot applicable
this has been added to known issues
- maomNew Member
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.