Matillion ETL Shared Job
Author: Datalab Solutions (Pty) Ltd
Date Posted: Nov 17, 2023
Last Modified: Nov 17, 2023

Power BI Dataset Refresh

Refresh a Power BI Dataset from a Matillion ETL orchestration job.

Power BI Dataset Refresh

This shared job, by Datalab Solutions, uses the Power BI REST API to refresh a previously-built Power BI Dataset.

If you have any questions or comments about extending the functionality across the REST API, please reach out to support@datalab.co.za.

Parameters

ParameterDescription
GroupIdGroup ID of the Dataset to refresh
ClientIdAzure service principal Application (Client) ID
DataSetIdID of the Dataset to refresh
TennantIdAzure service principal Directory (Tenant) ID
ClientSecretValue of the Azure client secret
PayloadAn optional JSON payload, as per the Power BI REST API documentation

Prerequisites

You will need to know the GroupId and DataSetId of the Power BI dataset you intend to refresh.

You must have configured a sufficiently privileged Service Principal. You must have its Application (Client) ID, the Directory (Tenant) ID:

Azure Service Principal Configuration

… and the value of its client secret:

Azure Service Principal Client Secret

To avoid a ModuleNotFoundError, the following Python libraries must be available to the Python 3.8 interpreter:

  • requests
  • base64
  • json

Downloads

Licensed under: Matillion Free Subscription License

Installation Instructions

How to Install a Matillion ETL Shared Job