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
Power Automate Standard All Power Automate regions
Power Apps Standard All Power Apps regions
Contact
Name Microsoft
URL Microsoft LogicApps Support
Microsoft Power Automate Support
Microsoft Power Apps Support
Connector Metadata
Publisher Microsoft
Website https://powerbi.microsoft.com/

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).

Creating a connection

The connector supports the following authentication types:

Default Parameters for creating connection. All regions Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

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.

Export To File for Paginated Reports

Use Power BI Rest API to inititate export for paginated reports

Export To File for Power BI Reports

Use Power BI Rest API to inititate export for Power BI reports

Refresh a dataset

Use Power BI REST API to refresh a powerbi 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

Export To File for Paginated Reports

Use Power BI Rest API to inititate export for paginated reports

Parameters

Name Key Required Type Description
Workspace
groupid True string

The unique identifier of the workspace.

Report
reportid True string

The unique identifier of a paginated report.

Export Format
format True string

The export format for the paginated report. The supported formats are: PPTX (PowerPoint), PDF, XLSX (Excel), DOCX (Word), CSV, XML, MHTML, and Image (BMP, EMF, GIF, JPEG, PNG, or TIFF).

Username
username True string

The effective username reflected by a token for applying RLS rules (For OnPrem model, username can be composed of alpha-numerical characters or any of the following characters '.', '-', '_', '!', '#', '^', '~', '\', '@', also username cannot contain spaces. For Cloud model, username can be composed of all ASCII characters. username must be up to 256 characters)

Dataset
Datasets string

Dataset for which this identity applies

Roles
Roles string

RLS role

CustomData
customData string

The value of customdata to be used for applying RLS rules. Only supported for live connections to Azure Analysis Services.

Blob Value
value True string

OAuth2 access token for SQL Azure

Reports
Reports string

Report for which this identity applies, Only supported for paginated reports

name
name string

The report parameter name

value
value string

The report parameter value

Returns

The content of the file.

File Content
binary

Export To File for Power BI Reports

Use Power BI Rest API to inititate export for Power BI reports

Parameters

Name Key Required Type Description
Workspace
groupid True string

The unique identifier of the workspace.

Report
reportid True string

The unique identifier of a pbi report.

Export Format
format True string

The export format for the Power BI report. The supported formats are: PPTX (PowerPoint), PDF, and PNG

Locale
locale string

The locale to apply

Include Hidden Pages
includeHiddenPages boolean

A flag indicating whether to include hidden pages when exporting the entire report (when passing specific pages this property will be ignored). If not provided, the default behavior is to exclude hidden pages

Bookmark Name
name string

The bookmark name

Bookmark State
state string

The bookmark state

Filter
filter string

The filter to apply

pageName
pageName string

The page name

visualName
visualName string

(Optional) Visual name to be exported

Bookmark Name
name string

The bookmark name

Bookmark State
state string

The bookmark state

Username
username True string

The effective username reflected by a token for applying RLS rules (For OnPrem model, username can be composed of alpha-numerical characters or any of the following characters '.', '-', '_', '!', '#', '^', '~', '\', '@', also username cannot contain spaces. For Cloud model, username can be composed of all ASCII characters. username must be up to 256 characters)

Dataset
Datasets string

Dataset for which this identity applies

Roles
Roles string

RLS role

CustomData
customData string

The value of customdata to be used for applying RLS rules. Only supported for live connections to Azure Analysis Services.

Blob Value
value True string

OAuth2 access token for SQL Azure

Reports
Reports string

Report for which this identity applies, Only supported for paginated reports

Returns

The content of the file.

File Content
binary

Refresh a dataset

Use Power BI REST API to refresh a powerbi 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.

Triggers

Power BI button clicked

This trigger allows you to run a flow when a Power BI button is clicked. (Available only for Power Automate.)

When a data driven alert is triggered

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

Power BI button clicked

This trigger allows you to run a flow when a Power BI button is clicked. (Available only for Power Automate.)

Returns

The outputs of this operation are dynamic.

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.

binary

This is the basic data type 'binary'.

Using this Connector