topic Re: Report refresh failures. in Report Server

Report refresh failures.

bhpant — Thu, 19 Aug 2021 13:00:20 GMT

An error occurred while processing the data in the dataset.

Refresh failed:
Dashboard_New_2 has failed to refresh.
Failure details: Query execution has resulted in error (0x80131500): Partial query failure: 0x80131500 (message: 'One or more errors occurred.: : : ', details: 'Source: Kusto::CachedStorageObject'). [0]Kusto.Data.Exceptions.KustoDataStreamException: Query execution has resulted in error (0x80131500): Partial query failure: 0x80131500 (message: 'One or more errors occurred.: : : ', details: 'Source: Kusto::CachedStorageObject'). Timestamp=2021-08-18T12:26:09.5197870Z ClientRequestId=KPBI;a0f4d171-990c-4b13-b99e-322581999a07;07fdacce-7efb-48d4-a138-15ace0f0fb7f;309a646b-4a67-4d08-ab68-e619b3c4e57b ActivityId=ce20e192-f8fb-45e7-890c-0652e9ee058c ActivityType=PO.OWIN.CallContext ServiceAlias=AZCRP MachineName=KEngine00000T ProcessName=Kusto.WinSvc.Svc ProcessId=9388 ThreadId=14632 AppDomainName=Kusto.WinSvc.Svc.exe ActivityStack=(Activity stack: CRID=KPBI;a0f4d171-990c-4b13-b99e-322581999a07;07fdacce-7efb-48d4-a138-15ace0f0fb7f;309a646b-4a67-4d08-ab68-e619b3c4e57b ARID=ce20e192-f8fb-45e7-890c-0652e9ee058c > PO.OWIN.CallContext/ce20e192-f8fb-45e7-890c-0652e9ee058c) MonitoredActivityContext=(ActivityType=PO.OWIN.CallContext, Timestamp=2021-08-18T12:25:30.5340865Z, ParentActivityId=ce20e192-f8fb-45e7-890c-0652e9ee058c, TimeSinceStarted=38985.7005 [ms])ErrorCode= ErrorReason= ErrorMessage= DataSource= DatabaseName= ClientRequestId= ActivityId=00000000-0000-0000-0000-000000000000 UnderlyingErrorCode=80131500 UnderlyingErrorMessage=Partial query failure: 0x80131500 (message: 'One or more errors occurred.: : : ', details: 'Source: Kusto::CachedStorageObject')

Next refresh for Dashboard_New_2 is scheduled for August 19, 2021 12:00 UTC.

Re: Report refresh failures.

PC2790 — Fri, 20 Aug 2021 06:06:03 GMT

Hello bhpant ,

Was the refresh happening before successfully? Or this is the first time it was attempted and it got failed.

Are you using a gateway? What sources you are using?

Couple of troubleshooting things you can do:

1) Download the pbix and try to refresh manually and see if it is giving the same error.

2) Monitor the next run as it could be a temporary issue

3) Check step by step in Power Query for any error

Re: Report refresh failures.

v-henryk-mstf — Mon, 23 Aug 2021 03:14:22 GMT

Hi bhpant ,

First, you can follow the suggestions provided by PC2790 to troubleshoot. If the problem still exists, please provide more information screenshots, such as the configuration process, refreshed data source information, error information, etc.

Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Report refresh failures.

bhpant — Mon, 23 Aug 2021 13:22:21 GMT

PC2790 , Frankly I am not very sure whether it was working or not. This dashboard was maintained by someone else and I took over it after that person left the team. But I am assuming it must be working as the data was updated there.

I did some redesigning of the dashboard both visual and data.

My problem is that the failure details are not enough for me to figure out what is the issue and how to address those.

Re: Report refresh failures.

bhpant — Mon, 23 Aug 2021 13:26:10 GMT

1. Locally, I am manually refreshing each and every data source. Is there a way to refresh every data source using a single click?

2. The issue is not temporary, I am receiving refresh failures emails for 4-days.

3. Can you please provide the steps to check. there are many data sources in my dashboard, around 1 for each widget which makes it difficult to manually seek for each data source but as far as I checked I don't see any issues there.

Re: Report refresh failures.

v-henryk-mstf — Tue, 24 Aug 2021 09:12:49 GMT

Hi bhpant ,

Does it help you to see similar solutions?

Solved: An error occurred while processing the data in the... - Microsoft Power BI Community

Solved: Data Source Error: Resource name and Location need... - Microsoft Power BI Community

Or Troubleshooting refresh scenarios

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Report refresh failures.

bhpant — Wed, 25 Aug 2021 13:35:11 GMT

v-henryk-mstf , No the issue is not solved yet.
My problem is that I am not getting enough information from the error? Is there a way I could get more information either locally or from some logs?

Re: Report refresh failures.

bhpant — Thu, 26 Aug 2021 12:05:13 GMT

v-henryk-mstf < is there any other way we can engage so that we can speedily investigate it?

Re: Report refresh failures.

v-henryk-mstf — Fri, 27 Aug 2021 09:30:34 GMT

Hi bhpant ,

You can collect logs from the on-premises data gateway app to better investigate it, this file is saved to the ODGLogs folder on your Windows desktop in .zip format.

More details, you can read this blog:

Working with Power BI Gateway logs - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Report refresh failures.

bhpant — Thu, 30 Sep 2021 17:44:59 GMT

Can you point me to On-Premise data Gateway App to triage it?

My application was disabled for some time and then I enabled auto refreshed. Auto-refresh worked for few days and today it failed again.