Power BI (Preview)

Power BI is a suite of business analytics tools to analyze data and share insights. Connect to get easy access to the data in your Power BI dashboards, reports and datasets.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure China regions
Flow Standard All Flow regions
PowerApps Standard All PowerApps regions

To use this integration, you will need access to a Power BI account. To make a connection, select Sign In. You will be prompted to provide your account, follow the remainder of the screens to create a connection.

When using the connection, you may be required to have certain configurations in your Power BI account. For example, to use the data driven alert triggers you must already have a data driven alert configured.

You're now ready to start using this integration.

Known issues and limitations

Power BI connector is not supported for Power BI sovereign cloud clusters (i.e. China, Germany and US Government clusters).

Throttling Limits

Name Calls Renewal Period
API calls per connection10060 seconds

Actions

Add rows to a dataset

Use Power BI REST API to add rows to a dataset.

Add rows to a dataset

Use Power BI REST API to add rows to a dataset.

Parameters

Name Key Required Type Description
Workspace
groupid True string

The unique identifier of the workspace.

Dataset
datasetid True string

The unique identifier of the dataset.

Table
tablename True string

The name of the table.

Payload to send
Payload dynamic

The unique identifier of the workspace.

Triggers

When a data driven alert is triggered

Return the details of the specified data driven alert from Power BI when the alert triggered.

When a data driven alert is triggered

Return the details of the specified data driven alert from Power BI when the alert triggered.

Parameters

Name Key Required Type Description
Alert Id
alertId True string

The alert id to track.

Returns

Definitions

EvaluatedAlert

Name Path Type Description
Alert title
alertTitle string

The title of the alert.

Alert threshold
alertThreshold number

The threshold at which the alert is triggered.

Is alert triggered
isAlertTriggered boolean

A boolean value (true, false) determining Whether or not the alert was triggered.

Tile URL
tileUrl string

URL linking to the dashboard tile where the alert is set up.

Tile value
tileValue

The value of the tile.

Using this Connector