cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aibatalov
Advocate I
Advocate I

Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe while refresh in service

Yesterday all working fine, but today refresh failed in all our reports in PowerBI service (we haven't changed reports since yesterday).

 

Same error in all reports:

An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)'

 

Reports contains PostgreSQL and web contents datasources.

What can we do to fix this?

37 REPLIES 37
shubhamamilkant
Helper II
Helper II

Workaround for now: 

1) Install 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

lguima
Frequent Visitor

Same issue here. 09/01/2021

SomeBIguy
New Member

Still running into this issue (8/30/2021)

ysanabria
Frequent Visitor

Me too and still waiting for Microsoft support request 😥

Same, I am still having this issue. 

any solutions? 

grayl
Regular Visitor

Same issue here running postgres via postgres for azure service.

Aweptimum
Helper II
Helper II

Thanks MS for the fix,

But, hey! Since we all use Postgres, I want to make everyone aware of the TimescaleDB extension we have available. Timescale recently released v1.7, but as of v1.5 they implemented native database compression with a ratio of about 20:1. You can learn about it here.

 

Unfortunately, Azure's Postgres Service only supports v1.3.2 - please upvote this idea if you want to massively increase your PostgreSQL server's performance. If you're using a VM - get it already!

LinqLover
Frequent Visitor

Update for everyone other who did not observe the service page: The issue has been fixed until last night. Postgres datasets updates works again. 🎉

felipepereira
New Member

This is unbelievable. It seems they are always trying to sabotage Postgres users. I am facing the same issue and it started on the same day.

periyasingh
New Member

Hi,

Same issue is coming for me too. The on-demand and scheduled data refresh in power bi server was working fine beforehand, now getting issue since monday. Still no issue in loading and refreshing data from the same source in Power BI desktop.

 

I am using postgresql azure PaaS database. The issue i am getting is :

An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=x.x.x.x, Culture=neutral, PublicKeyToken=xxxxxxxxxx' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)' 

I'm having the same issue, in power BI desktop work fine but in PBI Web not synchronize

 

An error happened while reading data from the provider: 'Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)'

moka
Frequent Visitor

Hi @aibatalov 

I just had the same problem because I was not using a Gateway Connection. 
I solved the problem by enabling a Gateway and installing npgsql v4.0.10 on it.

Hope it helps somehow!

ALWI
Frequent Visitor

I got a call from Microsoft the issue is on the awareness list: https://powerbi.microsoft.com/en-us/support/

tomkvarby
Frequent Visitor

Same issue here. No gateway. Can't see any data.

Aweptimum
Helper II
Helper II

Same issue here, Postgresql DB on Azure server, no gateway, failing on all reports. All of them are either import-only or mixed-mode storage.

Hyferion
New Member

I have been experiencing the same problem for a few days. Hosting a Postgresql as a Database-as-a-service on Azure. Not using any gateway.

v-deddai1-msft
Community Support
Community Support

Hi @aibatalov ,

 

Would you please try to update your gateway to the latest version? You can also refer to https://docs.microsoft.com/en-us/troubleshoot/dotnet/framework/manifest-definitions-dont-match-refer...

 

If this post help, please consider accept it as the solution to help other member find it more quickly.

 

Best Regards,

Dedmon Dai

simonperez200
Regular Visitor

Do you have a solution yet? I'm experiencing the exact same issue.

shubhamamilkant
Helper II
Helper II

Same Issue here as well, any solution ?

aibatalov
Advocate I
Advocate I

My ticket escalated too. Waiting for some solution.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors