Power BI Dataset Refresh
Last updated
Was this helpful?
Last updated
Was this helpful?
Paradime provides a convenient way to trigger dataset refreshes in Power BI, allowing you to keep your visualizations and dashboards up to date with the latest data.
By leveraging the Power BI REST API endpoint for refreshing datasets, Paradime enables you to automate and schedule the refresh process based right after your dbt™ pipeline completes or in a separate schedule, using the on run completion trigger.
Follow the Power BI integration guide to generate the API credentials
Get your Group ID, this can be found by navigating to your workspace in the Power BI app and copying the id in the URL after /groups. It should be a 36 character UUID.
Use the generated credentials and set as environment variables for Bolt Schedules
POWER_BI_CLIENT_ID
POWER_BI_TENANT_ID
POWER_BI_CLIENT_SECRET
POWER_BI_GROUP_ID
When setting up PowerBI Dataset Refresh, you can provide one or more Dataset names in a single execution.
PowerBI accepts only one refresh operation at a time for a model/dataset. If there's a current running refresh and another request is submitted, a 400 Bad Request HTTP status code returns.
Now, let's learn how to configure the Trigger Types of a Bolt Schedule.