Power BI Job parameters

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

Parameter

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

Workspace Name

(For Dataset) Defines a Power BI workspace where you want to refresh data.

Workspace ID

(For Dataset) Defines the ID for the specified Power BI workspace (defined in Group Name).

Dataset ID

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.

For more information about available parameters, see Datasets - Refresh Dataset in the Microsoft Power BI documentation.

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

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

For no parameters, specify {}

Example:

{
  "type":"Defragment",
  "commitMode":"transactional",
  "maxParallelism":20,
  "retryCount":2,
  "objects":[
    {"table":"Contributions"},
    {"table":"Traffic_Popular"}
  ]
}

Connection Timeout

(Optional) Determines the maximum number of seconds to wait for REST API requests to respond, before disconnecting.

Default: 10 seconds

Status Polling Frequency

(Optional) Determines the number of seconds to wait before checking the status of the job.

Default: 10 seconds

Pipeline ID

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

Parent Topic

Job types