Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...


Panel

Table of Contents


Warning

This integration has been sunset

It is replaced by Microsoft Power BI.

Disclaimer

Your use of this download is governed by Stonebranch’s Terms of Use, which are available at https://www.stonebranch.com/integration-hub/Terms-and-Privacy/Terms-of-Use/

...

  • When a Power BI dataflow refresh fails, no detailed error description is provided by the current Power BI REST API.
  • Canceling of dataflow is not provided by the current Power BI REST API.
  • The task will be updated as soon as this feature is available by Microsoft.
  • Canceling of a dataset refresh will be provided in the next Version.

Import the Power BI Universal Template

...

FieldDescription

Power BI Credentials

Power BI Service User and Password.

client_id

Power BI Client ID.

To use the Power BI REST API, a client application ID must be obtained by registering an application with Azure Active Directory.

This registration can be completed via the four-step process at the following portal: Onboarding Embed Tool

Domain or Tenant ID

Domain name.

Go to Microsoft Azure > Azure Active Directory lookup: Primary domain (for example, psemeaaz.onmicrosoft.com) or the Tenant ID.

Action

[refresh dataset, refresh dataflow]

refresh dataset:
Refreshes a dataset in a Group or my workspace.

refresh dataflow:
Refreshes a dataflow in a Group.

Group

In this field, the Group is selected, which contains the dataset to refresh. A Group is a workspace within Power BI.

When pressing the magnifier you can dynamically choose the available Groups in your Power BI account (see Select the Group that Contains the dataset to Refresh).

To select the My workspace, choose None; None as Group.

Dataset

Power BI dataset name.

Power BI datasets represent a source of data ready for reporting and visualization

When pressing the magnifier, you can dynamically choose from the datasets in the Group you pre-selected in the Group field (see Select dataset to Refresh).

Monitor Interval [s]

Default is 60s.

The Monitor Interval is the frequency that the Universal Task checks the current refresh status of the dataset.

The Maximum number of checks is defined by the field value Number of Monitor Retries.

For example, Monitor Interval 60s and Number of Monitor Retries = 120 means that every 60s, the current refresh status is retrieved from Power BI, but only 120 times (120 x 60s = 2h ). If after 2h, the refresh could not be completed, the Universal Task will go into status failed.

Number of Monitor Retries

Default is 120 Monitor Retries.

The Number of Monitor Retries value is the the Maximum number of refresh status checks. As long as the refresh status is unknown, a retry will be performed with the frequency defined in the Monitor Interval [s] field.

If the maximum number is reached the task will go into status failed.

(See the Monitor Interval [s] field Description for an example.)

Log level (default is Inherited)

Universal Task logging settings: [Inherited | Trace | Debug | Info | Warn | Error | Severe]

...

FieldDescription

Power BI Credentials

Power BI Service User and Password.

client_id

Power BI Client ID.

To use the Power BI REST API, a client application ID must be obtained by registering an application with Azure Active Directory.

This registration can be completed via the four-step process at the following portal: Onboarding Embed Tool

Domain or Tenant ID

Domain name.

Go to Microsoft Azure > Azure Active Directory lookup: Primary domain (for example, psemeaaz.onmicrosoft.com) or the Tenant ID.

Action

[refresh dataflow, refresh dataflow]

refresh dataflow:
Refreshes a dataflow in a Group or my workspace.

refresh dataflow:
Refreshes a dataflow in a Group.

Group

In this field, the Group is selected, which contains the dataflow to refresh. A Group is a workspace within Power BI.

When pressing the magnifier you can dynamically choose the available Groups in your Power BI account (see Select the Group that Contains the dataflow to Refresh).

To select the My workspace, choose None; None as Group.

Dataflow

Power BI dataflow name.

Power BI dataflows are Power Query processes running in the cloud, with the same set of data preparation functionalities, data source connectors, gateways, and transformations.

When pressing the magnifier, you can dynamically choose from the dataflows in the Group you pre-selected in the Group field (see Select dataflow to Refresh).

Monitor Interval [s]

Default is 60s.

The Monitor Interval is the frequency that the Universal Task checks the current refresh status of the dataflow.

The Maximum number of checks is defined by the field value Number of Monitor Retries.

For example, Monitor Interval 60s and Number of Monitor Retries = 120 means that every 60s, the current refresh status is retrieved from Power BI, but only 120 times (120 x 60s = 2h ). If after 2h, the refresh could not be completed, the Universal Task will go into status failed.

Number of Monitor Retries

Default is 120 Monitor Retries.

The Number of Monitor Retries value is the the Maximum number of refresh status checks. As long as the refresh status is unknown, a retry will be performed with the frequency defined in the Monitor Interval [s] field.

If the maximum number is reached the task will go into status failed.

(See the Monitor Interval [s] field Description for an example.)

Log level (default is Inherited)

Universal Task logging settings: [Inherited | Trace | Debug | Info | Warn | Error | Severe]

...