Datasets - Get Refresh History

Service:

Power BI REST APIs

API Version:

v1.0

Returns the refresh history for the specified dataset from My workspace.

Required Scope

Dataset.ReadWrite.All or Dataset.Read.All

Limitations

OneDrive refresh history isn't returned.

There are always between 20–60 available refresh history entries for each dataset, depending on the number of refreshes in the last 3 days.
The most recent 60 are kept if they are all less than 3 days old. Entries more than 3 days old are deleted when there are more than 20 entries.

GET https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/refreshes

With optional parameters:

GET https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/refreshes?$top={$top}

URI Parameters

Name	In	Required	Type	Description
datasetId	path	True	string	The dataset ID
$top	query		integer	The requested number of entries in the refresh history. If not provided, the default is the last available 60 entries.

Responses

Name	Type	Description
200 OK	Refreshes	OK

Examples

Completed refresh example

Failed refresh example

In-progress refresh example

Completed refresh example

Sample request

GET https://api.powerbi.com/v1.0/myorg/datasets/cfafbeb1-8037-4d0c-896e-a46fb27ff229/refreshes?$top=1

Sample response

Status code:

200

{
  "value": [
    {
      "refreshType": "ViaApi",
      "startTime": "2017-06-13T09:25:43.153Z",
      "endTime": "2017-06-13T09:31:43.153Z",
      "status": "Completed",
      "requestId": "9399bb89-25d1-44f8-8576-136d7e9014b1",
      "refreshAttempts": [
        {
          "attemptId": 1,
          "startTime": "2017-06-13T09:25:43.153Z",
          "endTime": "2017-06-13T09:31:40.153Z",
          "type": "Data"
        },
        {
          "attemptId": 1,
          "startTime": "2017-06-13T09:31:40.156Z",
          "endTime": "2017-06-13T09:31:43.153Z",
          "type": "Query"
        }
      ]
    }
  ]
}

Failed refresh example

Sample request

GET https://api.powerbi.com/v1.0/myorg/datasets/cfafbeb1-8037-4d0c-896e-a46fb27ff229/refreshes?$top=1

Sample response

Status code:

200

{
  "value": [
    {
      "refreshType": "ViaApi",
      "startTime": "2017-06-13T09:25:43.153Z",
      "endTime": "2017-06-13T09:31:43.153Z",
      "serviceExceptionJson": "{\"errorCode\":\"ModelRefreshFailed_CredentialsNotSpecified\"}",
      "status": "Failed",
      "requestId": "11bf290a-346b-48b7-8973-c5df149337ff",
      "refreshAttempts": [
        {
          "attemptId": 1,
          "startTime": "2017-06-13T09:25:43.153Z",
          "endTime": "2017-06-13T09:31:43.153Z",
          "serviceExceptionJson": "{\"errorCode\":\"ModelRefreshFailed_CredentialsNotSpecified\"}",
          "type": "Data"
        }
      ]
    }
  ]
}

In-progress refresh example

Sample request

GET https://api.powerbi.com/v1.0/myorg/datasets/cfafbeb1-8037-4d0c-896e-a46fb27ff229/refreshes?$top=1

Sample response

Status code:

200

{
  "value": [
    {
      "refreshType": "ViaApi",
      "startTime": "2017-06-13T09:25:43.153Z",
      "status": "Unknown",
      "requestId": "9399bb89-25d1-44f8-8576-136d7e9014b1"
    }
  ]
}

Definitions

Name	Description
Refresh	A Power BI refresh history entry
RefreshAttempt	Power BI automatically makes multiple attempts to refresh a dataset if it experiences a refresh failure. This object contains information about each refresh attempt.
RefreshAttemptType	The type of refresh attempt.
Refreshes	The OData response wrapper for a Power BI refresh history list
RefreshType	The type of refresh request

Refresh

A Power BI refresh history entry

Name	Type	Description
endTime	string	The end date and time of the refresh (may be empty if a refresh is in progress)
refreshAttempts	RefreshAttempt[]	The refresh attempt list.
refreshType	RefreshType	The type of refresh request
requestId	string	The identifier of the refresh request. Provide this identifier in all service requests.
serviceExceptionJson	string	Failure error code in JSON format (empty if no error)
startTime	string	The start date and time of the refresh
status	string	Unknown if the completion state is unknown or a refresh is in progress. Completed for a successfully completed refresh. Failed for an unsuccessful refresh (serviceExceptionJson will contain the error code). Disabled if the refresh is disabled by a selective refresh.

RefreshAttempt

Power BI automatically makes multiple attempts to refresh a dataset if it experiences a refresh failure. This object contains information about each refresh attempt.

Name	Type	Description
attemptId	integer	The index of the refresh attempt.
endTime	string	The end date and time of the refresh attempt. The value is void if the refresh attempt is in progress.
serviceExceptionJson	string	Failure error code in JSON format. Void if there's no error.
startTime	string	The start date and time of the refresh attempt.
type	RefreshAttemptType	The type of refresh attempt.

RefreshAttemptType

The type of refresh attempt.

Name	Type	Description
Data	string	The refresh attempt to load data into the dataset.
Query	string	The attempt to refresh premium query caches and dashboard tiles.u

Refreshes

The OData response wrapper for a Power BI refresh history list

Name	Type	Description
odata.context	string
value	Refresh[]	The refresh history list

RefreshType

The type of refresh request

Name	Type	Description
OnDemand	string	The refresh was triggered interactively through the Power BI portal
OnDemandTraining	string	The refresh was triggered interactively through the Power BI portal with automatic aggregations training
Scheduled	string	The refresh was triggered by a dataset refresh schedule setting
ViaApi	string	The refresh was triggered by an API call
ViaEnhancedApi	string	The refresh was triggered by an enhanced refresh REST API call
ViaXmlaEndpoint	string	The refresh was triggered through Power BI public XMLA endpoint