Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dataset refresh history

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" perfor...
  • v-jiascu-msft's avatar
    7 years ago

    Hi Anonymous,

     

    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