Forum Discussion

gulevi's avatar
gulevi
Microsoft Employee
5 years ago

Failed refresh : An error occurred while processing the data in the dataset

Hello , 

Seems like my dashbaord has not refreshed since the 5th of May , I have done no changes what so ever in the dashabord . 

I cant find a place to fully understadn on what it fails to refresh 

 

I did get an eamil about it the other day.

 

An error occurred while processing the data in the dataset.
Refresh failed:

AI_OI_Operations has failed to refresh.
Failure details: 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.

{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Web.Contents failed to get contents from 'https://cmhelper.kusto.windows.net/v1/rest/query?db=CmOperations&csl=let%20_stepSize%20%3D%201m%3B%20let%20_offset%20%3D%201d%3B%20let%20_startTime%20%3D%20startofmonth%28now%28%29%2C%20-1%29%20-%20_offset%3B%20let%20_endTime%20%3D%20bin%28now%28%29%2C%201m%29%3B%20range%20Timestamp%20from%20_startTime%20to%20_endTime%20step%20_stepSize%20%7C%20extend%20Timestamp%20%3D%20Timestamp%20%2B%20_offset%20%7C%20extend%20WeekOffset%20%3D%20toint%28%28startofweek%28Timestamp%29%20-%20startofweek%28now%28%29%29%29%20%2F%207d%29%20%7C%20extend%20Timestamp%20%3D%20Timestamp%20-%20_offset%20%7C%20order%20by%20Timestamp%20desc&x-ms-app=PowerQuery&properties=%7B%22Options%22%3A%7B%22servertimeout%22%3A%2200%3A04%3A00%22%7D%2C%22Parameters%22%3A%7B%7D%2C%22PrincipalIdentity%22%3Anull%2C%22ClientRequestId%22%3Anull%2C%22SecurityToken%22%3Anull%2C%22AuthorizationScheme%22%3Anull%2C%22RequestHostName%22%3Anull%2C%22LocalClusterName%22%3Anull%2C%22Application%22%3Anull%2C%22User%22%3Anull%7D' (520): InternalServiceError"}}],"exceptionCulprit":1}}} Table: Timestamp.

Next refresh for AI_OI_Operations is scheduled for May 5, 2021 5:00 UTC.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    The error is not indicative enough of the reason but could be an issue with your source data such as duplicate keys in a dimension table?

    • gulevi's avatar
      gulevi
      Microsoft Employee

      Well again I did not change anything so not sure what and where it falls , and on what , it access a few Kusto CLusters and get the data from it with a very simple query .
      How cna I chance what is wrong here ?

      • Anonymous's avatar
        Anonymous
        Not applicable

        Yes it is well understood that you didn't change anything with the report/dashboard. I am suggesting that the issue is with the data and not the report. For example, if you have a Customers dimension table and the Customers table has a unique CustomerID column, the data now might have a duplicate CustomerID now and your model is failing to refresh because it is expecting the CustomerID to be unique while the data source has a repeating CustomerID

  • gulevi's avatar
    gulevi
    Microsoft Employee

    I connected , but agian for some reason it doesnt refresh to the new dates , but in the desktop when I refresh it works , also when I published it from the desktop to public it doesnt work in online only desktop refresh does