capabilities.work

Trigger a Dataset Refresh and Poll to Completion

A 3-step recipe with Power BI. We can help you get access.

Recipe · 3 steps

Trigger a Dataset Refresh and Poll to Completion

with Power BI · Analytics & BI Management

Refresh a Power BI dataset and wait for the refresh to finish.

  1. Read the dataset to confirm it exists and that it is refreshable before spending a refresh slot on it.
  2. Start an on-demand refresh. The API accepts the request and returns 202 with no body, so no refresh identifier is available from this step.
  3. Read the single most recent refresh history entry. The step only succeeds once that entry has left the "Unknown" in-progress state; while the refresh is still running the step retries on a fixed interval.
What you'll need to have ready
  • datasetId: The identifier of the dataset to refresh.
  • refreshType: The type of refresh to run. One of Full, ClearValues, Calculate, DataOnly, Automatic, or Defragment.
  • commitMode: Whether objects are committed in batches or only when complete. One of transactional or partialBatch.
  • retryCount: Number of times the refresh operation retries before failing.
For your developer

Arazzo workflow power-bi:dataset-refresh-poll, 3 operations: getDataset → refreshDataset → getRefreshHistory. Specs on APIs.io.