Forum Discussion

bhpant's avatar
bhpant
Microsoft Employee
4 years ago

Report refresh failures.

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.

 

 

 
Dashboard
Refresh
Schedule issue

9 Replies

  • PC2790's avatar
    PC2790
    Community Champion
    4 years ago

    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

    • bhpant's avatar
      bhpant
      Microsoft Employee
      4 years ago

      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.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    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.