Dataset refresh history

[vmakhija]

Hello

I want to create a report which will give me data about how much time each of my datasets took for refresh each day for last 3 months. Basically to monitor how was my "schedule refresh" performance.

Is such data available anywhere or any other way to access it?

Any pointers will be helpful. 

Regards

[v-jiascu-msft]

Hi @vmakhija,

Could you please mark the proper answers as solutions?

Best Regards,
Dale

[v-jiascu-msft · Accepted solution]

Hi @vmakhija,

As far as I know, there isn't a UI function doing that. But we can leverage the power of REST API. Finally, we will get the refresh details like below. Please give it a try.

{
      "id":7616323,"refreshType":"OnDemand","startTime":"2018-10-16T02:01:57.84Z","endTime":"2018-10-16T02:02:10.107Z","status":"Completed"
    },{
      "id":5913907,"refreshType":"OnDemand","startTime":"2018-09-10T06:27:18.303Z","endTime":"2018-09-10T06:27:34.137Z","status":"Completed"
    },{
      "id":2608950,"refreshType":"ViaApi","startTime":"2018-06-10T14:54:04.517Z","endTime":"2018-06-10T14:54:08.597Z","status":"Completed"
    },{
      "id":2608924,"refreshType":"ViaApi","startTime":"2018-06-10T14:53:51.527Z","endTime":"2018-06-10T14:53:57.547Z","status":"Completed"
    },{
      "id":2608923,"refreshType":"ViaApi","startTime":"2018-06-10T14:53:39.383Z","endTime":"2018-06-10T14:53:44.34Z","status":"Completed"
    },{
      "id":2608914,"refreshType":"ViaApi","startTime":"2018-06-10T14:52:43.463Z","endTime":"2018-06-10T14:52:49.223Z","status":"Completed"
    },{
      "id":2608910,"refreshType":"ViaApi","startTime":"2018-06-10T14:51:49.06Z","endTime":"2018-06-10T14:51:53.983Z","status":"Completed"
    },{
      "id":2608909,"refreshType":"ViaApi","startTime":"2018-06-10T14:51:41.967Z","endTime":"2018-06-10T14:51:48.607Z","status":"Completed"
    },{
      "id":2608883,"refreshType":"ViaApi","startTime":"2018-06-10T14:50:34.713Z","endTime":"2018-06-10T14:50:49.27Z","status":"Completed"
    },{
      "id":2608711,"refreshType":"ViaApi","startTime":"2018-06-10T14:43:57.357Z","endTime":"2018-06-10T14:44:13.447Z","status":"Completed"
    }

Best Regards,
Dale