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?

Same setup as you:Azure for PostgreSQL, no gataway and the data using Direct Query is not working online. Data using import mode is working. Sent in a Support Ticket, where they escalated the issue to the Product Team. Will update when I get more info.

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

Me too and still waiting for Microsoft support request 😥

I'm in the same situation.Datasource updates once a week and have not been changed in some time -> Today it failes with the same error as OP. Edit: Also using PostgreSql Azure Paas

I have the same issue. All reports are affected. Yesterday evening worked all fine. Reports contains PostgreSQL

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

41 Replies

periyasingh
New Member
5 years ago
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)'
- ysanabria
  Frequent Visitor
  5 years ago
  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)'
ysanabria
Frequent Visitor
5 years ago
Me too and still waiting for Microsoft support request 😥
- shubhamamilkant
  Helper II
  5 years ago
  Same, I am still having this issue.
  any solutions?
daneri
Regular Visitor
5 years ago
I'm in the same situation.
Datasource updates once a week and have not been changed in some time -> Today it failes with the same error as OP.

Edit: Also using PostgreSql Azure Paas
AWILLIM
New Member
5 years ago
I have the same issue. All reports are affected. Yesterday evening worked all fine.

Reports contains PostgreSQL
Anonymous
Not applicable
5 years ago
I am having the same issue. Using PostgreSQL data.
Anonymous
Not applicable
5 years ago
I am having the same issue using direct query to an Azure for PostgreSQL db. No users can access the report via PowerBI Service. The connection works fine, and the data refreshes correctly for me as the admin on desktop.

I am unable to recconect the gateway as Anonymous suggested:
- daneri
  Regular Visitor
  5 years ago
  Same setup as you:
  Azure for PostgreSQL, no gataway and the data using Direct Query is not working online.
  
  Data using import mode is working.
  
  Sent in a Support Ticket, where they escalated the issue to the Product Team. Will update when I get more info.
  - Anonymous
    Not applicable
    5 years ago
    daneri wrote:
    Data using import mode is working.
    I'm afraid, for me import mode is working neither ...
    
    daneri wrote:
    Sent in a Support Ticket, where they escalated the issue to the Product Team. Will update when I get more info.
    Does it help if every affected person files in a separate support ticket to raise the priority, or would this only be spam to Microsoft?
- connec
  Regular Visitor
  5 years ago
  I have the exact same issue with the exaxt same setup...
ALWI
Frequent Visitor
5 years ago
I have the same setup as daneri Azure for PostgreSQL, no gataway and the data using Direct Query is not working online.

But, data import refresh is not working.

My ticket is escalated to the Product Team as well.
Anonymous
Not applicable
5 years ago
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.
ALWI
Frequent Visitor
5 years ago
I got a call from Microsoft the issue is on the awareness list: https://powerbi.microsoft.com/en-us/support/
moka
Frequent Visitor
5 years ago
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!