cancel
Showing results for 
Search instead for 
Did you mean: 

dataset not refreshing

Hello,

 

Since this morning the dataset in PowerBI online isn't refreshing.

when trying manual refresh it is not refreshing and we are getting this issue. We are using Postgres DB Version 11.

Thanks for your help

 

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"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=xxxxxxxxxx' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)'"}}],"exceptionCulprit":1}}} Table: Mission_Incoming.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: xxxxxxxxxxxx
Request ID: xxxxxxxxxxxxxxxx
Time: xxxxxxxxx

Status: New
Comments
Frequent Visitor

FIXED FOR US: ROOT CAUSE HERE WAS A PREMIUM WORKSPACE UPGRADE

We are not using  PostgreSQL. For us it appeared on multiple Gateways / dataflows while we first found it for our Gateways on a Domino Server with NotesSQL setup which worked well until yesterday when we upgraded the related Premium Workspace which is what we have turned back now and the flows are working again!

Frequent Visitor

In my case the server PBIRS recently updated to OCT 2020, once updated, the Power-BI Report refresh schedules getting following error message (even when i run it manually). I down-graded power-bi desktop to MAY 2020, and saved same report at PBIRS (without any change, but using older verion of PowerBI Desktop), the refresh schedule works fine. Should we wait untill next release of Power-BI desktop (Report Server), or any work-around solution provided to use same OCT 2020 version?

 

SessionID: dc183c37-3cf8-450f-bd7f-21bf110f0d57
[0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, Datasource {"protocol":"tds","address":{"server":"hostname","database":"DBA"},"authentication":null,"query":null} is not found..

 

 

 

Community Support

hi  all,

Power BI customers using PostgreSQL as a data source may see refreshes not succeed with the message "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)'".
Workaround: Customers can follow these steps to configure the report through the gateway.
1) Install gateway (if not already installed)
2) Install postgresql driver
3) Create data source for postgresql in gateway
4) Map data source to Dataset in dataset settings page
Engineers have identified the root cause and a fix is expected to be deployed by end-of-day 11/22/2020

 

https://powerbi.microsoft.com/en-us/support/

 

 

Regards,

Lin

 

Helper I

I am having refresh issues online since yesterday morning. The datasets refresh with no issue on the desktop version. The message we get says it's a "transient" issue with the following details:

 

apatnola_0-1605881013916.png

 

Frequent Visitor

My dataset also cannot be refreshed since 19th Nov. My dataset use dataflow that connect to SQL. Dataflow refresh is working fine.  

 

Last refresh failed: Sun Nov 22 2020 13:46:19 GMT+0800 (Malaysia Time)
The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:9efca6c3-29a4-4e12-bd23-66a1020c13fb
Request ID:b8813436-e740-40dd-ade9-c833e889a8e2
Time:2020-11-22 05:46:19Z
Frequent Visitor

I have the same problem; I have reinstall gateway, but it don't work.

Código de error subyacente: -2147467259
Mensaje de error subyacente: La importación List.ConformToPageReader no coincide con ninguna exportación. ¿Faltaba una referencia del módulo?
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
URI de clúster: WABI-WEST-EUROPE-D-PRIMARY-redirect.analysis.windows.net
Identificador de actividad: 2fef02ed-1f6a-430e-9237-7eca14c9f896
Identificador de la solicitud: b8af7d7e-3a49-e1cf-5984-21a138e7bfc9
Hora: 2020-11-23 08:47:16Z

 

Saludos

Frequent Visitor

Great, thanks Microsoft for fixing this!