Update Dataset Parameters and Refresh
A 5-step recipe with Power BI. We can help you get access.
Recipe · 5 steps
Update Dataset Parameters and Refresh
with Power BI · Analytics & BI Management
Repoint a parameterized dataset and refresh it so the new values apply.
- Read the dataset's current mashup parameters so the existing values are captured before anything is overwritten.
- Apply the new parameter values. The call returns 200 with no body, so the write is confirmed by reading the parameters back in the next step.
- Read the parameters back to confirm the service persisted the new current values.
- Trigger a refresh so the model is rebuilt against the newly parameterized source. Without this the parameter change has no effect on the data.
- Poll the most recent refresh history entry until it leaves the "Unknown" in-progress state, so the caller learns whether the reparameterized refresh actually succeeded.
What you'll need to have ready
- datasetId: The identifier of the dataset whose parameters are being changed.
- updateDetails: The parameter changes to apply. Each entry requires a name and a newValue, for example {"name": "ServerName", "newValue": "prod-sql"}.
- refreshType: The refresh type to run after the parameter change. One of Full, ClearValues, Calculate, DataOnly, Automatic, or Defragment.
For your developer
Arazzo workflow power-bi:parameter-update-refresh, 5 operations: getParameters → updateParameters → getParameters → refreshDataset → getRefreshHistory. Specs on APIs.io.