Power BI

Power BI Integration

Microsoft Power BI: reports, dashboards, datasets, workspaces, refresh

Data & Analytics 27 actions OAuth 2.0 (sign in to authorise)

Start automating Power BI

What you can automate with Power BI

Drag any of these 27 actions into a process — no code, no API wrangling.

Add Rows

Add rows to a table in a push dataset

Clone Report

Clone a report

Create Workspace

Create a new workspace

Delete Dataset

Delete a dataset

Delete Report

Delete a report

Delete Rows

Delete all rows from a table in a push dataset

Delete Workspace

Delete a workspace

Execute Queries

Execute DAX queries against a dataset

Export Report

Export a report to file

Get Dashboard

Get dashboard details

Get Dataset

Get dataset details

Get Export File

Download the exported report file

Get Export Status

Get the status of a report export

Get Gateway

Get gateway details

Get Refresh History

Get refresh history for a dataset

Get Report

Get report details

Get Workspace

Get workspace details

List Capacities

List available capacities

List Dashboards

List dashboards in a workspace

List Dataflows

List dataflows in a workspace

List Datasets

List datasets in a workspace

List Gateways

List all gateways

List Reports

List reports in a workspace

List Tiles

List tiles in a dashboard

List Workspaces

List all workspaces

Refresh Dataflow

Trigger a dataflow refresh

Refresh Dataset

Trigger a dataset refresh

How the Power BI connection works

1. Authenticate

Power BI uses oAuth 2.0 (sign in to authorise). Save the connection once and reuse it across every process.

2. Build the process

Drop Power BI steps onto the process map alongside desktop, browser, Excel and email steps.

3. Run it attended or unattended

Trigger on a schedule, an email, or a file landing in a folder. Credentials stay encrypted and every run is audited.

Because Power BI has an API, Automize talks to it directly in the cloud — no bot needed on a desktop. Where a system has no API, an Automize bot drives its interface instead.

Other Data & Analytics connectors

Automate Power BI in 7 days

We build one working Power BI automation in your business inside a week, at a fixed price.