Power BI Dataset Refresh

Overview

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.

Prerequisites

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

How to Configure Dataset Refresh

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.