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.

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"
    }
  ]
}

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"
    }
  ]
}

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
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)
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.

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