Power BI Job

The Power BI job enables you to integrate Power BI workflows with your existing Control-M workflows. The following table describes Power BI job attributes:

Attribute

Description

Connection profile

Determines which connection profile to use to connect to the Power BI endpoint.

Dataset Refresh/

Pipeline Deployment

Determines one of the following options for execution in Power BI:

  • Dataset Refresh

  • Pipeline Deployment

Group Name (For Dataset) Defines a Power BI workspace where you want to refresh data.
Group ID (For Dataset) Defines the ID for the specified Power BI workspace (defined in Group Name).
Dataset Name Defines a Power BI data set that you want to refresh under the specified workspace.

Parameters

(For Dataset) Defines specific parameters to pass when the job runs, defined as JSON pairs of parameter name and value.

To specify parameters, the dataset must be in Premium group.

Format: {"param1":"value1", "param2":"value2"}

For no parameters, specify {}

Pipeline ID Defines the ID of a Power BI pipeline that you want to deploy to test and then to production.