Dataset Refresh
Description
This job triggers a dataset refresh in Power BI. This is used to update a visualisation or dashboard with the latest data from the dataset it is connected to. Orchestra uses this endpoint to trigger the refresh.
Use Cases
We recommend creating a dataset refresh for every dataset you have connected to a dashboard in Power BI.
This way, you can use Orchestra to trigger your refreshes on a cron or event-based schedule. This allows you to:
Co-ordinate tasks outside of Power BI - these would typically be specific transformation or ingestion jobs that build the final dataset that is used in the Power BI visualisation. This way you only refresh your dataset when there is new data.
You can use Orchestra to trigger jobs across Power BI workspaces
When Power BI jobs run, cost is incurred. Running these operations on a schedule you set explicitly ensures these costs do not go out of hand
Parameters
These parameters are required to run the Dataset Refresh task
| Name | Data type | Restrictions | Example |
|---|---|---|---|
Dataset Id | string | N.A. | random_dataset_id |
Setup Guide
Fetch the dataset id
Head to the the dataset you wish to refresh in the Power BI app. This is sometimes referred to as a 'Semantic Model' in the UI
Copy the id in the URL after
/datasets. It should be a 36 character UUID.
Last updated
