Microsoft Power BI Integration

Push datasets and refresh Power BI reports and workspaces from your workflows. Connect Microsoft Power BI data to workflows that react when important metrics change. Start from Watch Imports and let Deploy All Pipelines or Get a Dataset Query Scale Out Sync Status act on the event automatically.

Explore Documentation

3-day trialCancel anytimeUp to 10 minutes quick set up

GDPR
Data Encryption
2FA
Local Data Region

Supported triggers and actions for Microsoft Power BI integration

Triggers can detect changes in Microsoft Power BI and run actions that can create, search or modify data inside Microsoft Power BI automatically [3] — exactly how you set them.

Watch ImportsTriggers when new imports are created.
Watch Imports in a GroupWatch for import In Group.
Deploy All PipelinesRetrieves matching deploy all Pipelines.
Get a Dataset Query Scale Out Sync StatusRetrieves a Dataset Query Scale Out Sync Status.
Get a Dataset Query Scale Out Sync Status in GroupRetrieves a Dataset Query Scale Out Sync Status In Group.
Get a Dataset Refresh Execution DetailsRetrieves a Dataset Refresh Execution Details.
Get a Dataset Refresh Execution Details in GroupRetrieves a Dataset Refresh Execution Details In Group.
Get Direct Query Refresh ScheduleRetrieves details for the selected direct Query Refresh Schedule.
Get Direct Query Refresh Schedule in GroupRetrieves details for the selected direct Query Refresh Schedule In Group.
Get Pipeline Stage ArtifactsRetrieves details for the selected pipeline Stage Artifacts.
List AppsRetrieves a list of apps.
List CapacitiesRetrieves a list of capacities.
List Capacity RefreshablesRetrieves a list of capacity Refreshables.
List DashboardsRetrieves a list of dashboards.
List Dataflow SourcesRetrieves a list of dataflow Sources.
List Dataflow Storage AccountsRetrieves a list of dataflow Storage Accounts.
List Dataflow TransactionsRetrieves a list of dataflow Transactions.
List DataflowsRetrieves a list of dataflows.
List Dataset GatewaysRetrieves a list of dataset Gateways.
List Dataset Gateways in a GroupRetrieves a list of dataset Gateways In a Group.
List Dataset ParametersRetrieves a list of dataset Parameters.
List Dataset Parameters in a GroupRetrieves a list of dataset Parameters in a Group.
List Dataset Refresh HistoryRetrieves a list of dataset Refresh History.
List Dataset Refresh HistoryRetrieves a list of dataset Refresh History.
List Dataset TablesRetrieves a list of dataset Tables.
List Dataset Tables in a GroupRetrieves a list of dataset Tables in a Group.
List Dataset UsersRetrieves a list of dataset Users.
List Dataset Users in a GroupRetrieves a list of dataset Users in a Group.
List DatasetsRetrieves a list of datasets.
List Datasets in a GroupRetrieves a list of datasets in a Group.
List Gateway DatasourcesRetrieves a list of gateway Datasources.
List Gateway Datasources in GroupRetrieves a list of gateway Datasources In Group.
List Group UsersRetrieves a list of group Users.
List GroupsRetrieves a list of groups.
List ImportsRetrieves a list of imports.
List Imports in GroupRetrieves a list of imports In Group.
List PipelinesRetrieves a list of pipelines.
List ProfilesRetrieves a list of profiles.
List RefreshablesRetrieves a list of refreshables.
List ReportsRetrieves a list of reports.
List TilesRetrieves a list of tiles.
List WorkloadsRetrieves a list of workloads.
List Workspace DashboardsRetrieves a list of workspace Dashboards.
List Workspace Dashboards in GroupsRetrieves a list of workspace Dashboards In Groups.
List Workspace TilesRetrieves a list of workspace Tiles.
List Workspace Tiles in GroupRetrieves a list of workspace Tiles In Group.
Retrieve a DashboardRetrieves a Dashboard.
Retrieve a DatasetRetrieves a Dataset.
Retrieve a Dataset in a GroupRetrieves a Dataset in a Group.
Retrieve a GroupRetrieves a Group.
Retrieve a PipelineRetrieves a Pipeline.
Retrieve a ProfileRetrieves a Profile.
Retrieve a ReportRetrieves a Report.
Retrieve a TileRetrieves a Tile.
Retrieve a WorkloadRetrieves a Workload.
Retrieve a Worksapce TileRetrieves a Worksapce Tile.
Retrieve a Workspace DashboardRetrieves a Workspace Dashboard.
Retrieve a Workspace Dashboard in GroupRetrieves a Workspace Dashboard in Group.
Retrieve a Workspace Tile in GroupRetrieves a Workspace Tile in Group.
Retrieve an AppRetrieves an App.
Retrieve an ImportRetrieves an Import.
Retrieve an Import in a GroupRetrieves an Import in a Group.
Retrieve Refreshable for CapacityRetrieves details for the selected refreshable For Capacity.
Selective DeploysRetrieves matching selective Deploys.
Add a Dataset Row in GroupAdds a new Dataset Row in Group.
Add a Dataset RowsAdds a new Dataset Rows.
Add Group UserAdds a new group User.
Assign a Pipeline WorkspaceAssigns the selected Pipeline Workspace.
Assign Workspace CapacityAssigns the selected workspace Capacity.
Assign Workspace to Data Flow StorageAssigns the selected workspace to Data Flow Storage.
Bind a Dataset to a Gateway in a GroupExecutes “Bind a Dataset to a Gateway in a Group” against the connected service API.
Bind a Dataset to GatewayExecutes “Bind a Dataset to Gateway” against the connected service API.
Cancel a Dataflow TransactionCancels the selected Dataflow Transaction.
Cancel a Dataset RefreshCancels the selected Dataset Refresh.
Cancel a Dataset Refresh in a GroupCancels the selected Dataset Refresh in a Group.
Clone a TileClones the selected Tile.
Clone a Tile in GroupClones the selected Tile in Group.
Create a DashboardCreates a new Dashboard.
Create a Dashboard in GroupCreates a new Dashboard in Group.
Create a GroupCreates a new Group.
Create a PipelineCreates a new Pipeline.
Create a ProfileCreates a new Profile.
Delete a DataflowDeletes the selected Dataflow.
Delete a DatasetDeletes the selected Dataset.
Delete a Dataset in a GroupDeletes the selected Dataset in a Group.
Delete a Dataset RowsDeletes the selected Dataset Rows.
Delete a Dataset Rows in a GroupDeletes the selected Dataset Rows in a Group.
Delete a GroupDeletes the selected Group.
Delete a PipelineDeletes the selected Pipeline.
Delete a ProfileDeletes the selected Profile.
Delete a Workspace DashboardDeletes the selected Workspace Dashboard.
Delete a Workspace Dashboard in GroupDeletes the selected Workspace Dashboard in Group.
Delete Group UserDeletes the selected group User.
Execute Dax QueriesExecutes “Execute Dax Queries” against the connected service API.
Execute Dax Queries in a GroupExecutes “Execute Dax Queries in a Group” against the connected service API.
Execute QueriesExecutes “Execute Queries” against the connected service API.
Execute Queries in a GroupExecutes “Execute Queries in a Group” against the connected service API.
Export a DataflowExecutes “Export a Dataflow” against the connected service API.
Make an API CallPerforms an arbitrary authorized API call.
Post ImportPosts the import.
Post Import in GroupPosts import in Group.
Refresh a DataflowRefreshes the selected Dataflow.
Save Dataflow Gen One as Dataflow Gen TwoExecutes “Save Dataflow Gen One As Dataflow Gen Two” against the connected service API.
Unassign a Pipeline WorkspaceExecutes “Unassign a Pipeline Workspace” against the connected service API.
Update a DataflowUpdates an existing Dataflow.
Update a DatasetUpdates an existing Dataset.
Update a Dataset DatasourcesUpdates an existing Dataset Datasources.
Update a Dataset Datasources in GroupUpdates an existing Dataset Datasources In Group.
Update a Dataset in a GroupUpdates an existing Dataset in a Group.
Update a Dataset ParametersUpdates an existing Dataset Parameters.
Update a Dataset Parameters in GroupUpdates an existing Dataset Parameters In Group.
Update a GroupUpdates an existing Group.
Update a PipelineUpdates an existing Pipeline.
Update a ProfileUpdates an existing Profile.
Update a TableUpdates an existing Table.
Update a Table in a GroupUpdates an existing Table in a Group.
Update Group UserUpdates an existing group User.
Update Refresh ScheduleUpdates an existing refresh Schedule.

How to integrate Microsoft Power BI in automation workflow?

3 simple steps to make your Microsoft Power BI connected with other apps in automation workflows on WEXTL. Up to 10 minutes integration set up.

STEP 1

Select Microsoft Power BI in workflow

Pick Microsoft Power BI app in the workflow builder [4] - just one click to select the app.

STEP 2

Connect Microsoft Power BI

When prompted, authorize access to Microsoft Power BI in WEXTL once. Microsoft Power BI credentials are encrypted and never shared with WEXTL. Authorization will be reused in any future API calls [3].

WEXTL wants to integrate with your Microsoft Power BI account. Approve?

STEP 3

Build a workflow

Build your workflow with Microsoft Power BI yourself or with WEXTL® AI Builder. Connect Microsoft Power BI to any available integrations [5], or use HTTP node to go beyond them.

Microsoft Power BI

How Microsoft Power BI connects and integrates with WEXTL

Save and approve your credentials once — WEXTL® stores authorization information encrypted and reuses the authentication whenever Microsoft Power BI app is called in workflows. That allows your analytics automations to run without your attention, per defined schedule [7]. Explore documentation [6] for a detailed list of fields that Microsoft Power BI supports.

Full Microsoft Power BI API documentation

The following table illustrates what fields Microsoft Power BI integration require during authorization flow inside our workflow builder [4].

Video slide demonstrates how Microsoft Power BI is connected in WEXTL builder [4].

Field	Type	Help
Microsoft - TenantRequired	select	Go to `https://entra.microsoft.com` and copy your tennat ID or select any of the following`
Microsoft - Client IDRequired	text	Go to the Microsoft Entra admin center → Entra ID → App registrations and select New registration. → enter a description and expiration → Add, then immediately copy your Client ID
Microsoft - Client SecretRequired	password	Copy you client Secret from the previously created app

Connect Microsoft Power BI to popular apps on WEXTL

Enter a name of the other app you want to sync with Microsoft Power BI below. Click on selected app to explore integration options with Microsoft Power BI. If the app you search for is not available in WEXTL yet, you can use HTTP node [10] instead to integrate it directly.

Example automation with Microsoft Power BI integration

Select Watch Imports in a Group trigger from Microsoft Power BI - this will be a starting point in your automation. Whenever event happens in Microsoft Power BI, workflow will start [7] from Watch Imports in a Group node.

Search for Add a Dataset Row in Group, connect it as the next step of integration sequence. You can use filters between Watch Imports in a Group and Add a Dataset Row in Group, so only important data pass from Watch Imports in a Group to the next step. WEXTL gives you full control over the process of Microsoft Power BI automation. All parts of workflow are visible on the canvas [4].

Microsoft Power BI on WEXTL has 118 modules for combining analytics automations. Explore Microsoft Power BI documentation for more.

Video slide demonstrates how Watch Imports in a Group and Add a Dataset Row in Group nodes are used in Microsoft Power BI workflow.

Video slide demonstrates how Watch Imports in a Group and Add a Dataset Row in Group [6] nodes are used in Microsoft Power BI workflow.

Frequently asked questions

Common questions about automating Microsoft Power BI in your workflows.

Microsoft Power BI has 2 triggers, including "Watch Imports" and "Watch Imports in a Group". Triggers are start points of the workflow, and automations may start from them.

Integration has 116 actions, including "Deploy All Pipelines", "Get a Dataset Query Scale Out Sync Status", and "Get a Dataset Query Scale Out Sync Status in Group", and more. Refer to our Microsoft Power BI Documentation for detailed inputs and outputs.

No. Most automations are built visually on the canvas by picking triggers, actions, and mapping fields. You can add custom JavaScript with Functions when advanced logic is needed — but our customers do that in rare cases [4].

Yes. Connections are authenticated per account, credentials are encrypted at rest, and you can enforce approvals and team-level access controls on any automation.

The Microsoft Power BI integration on WEXTL runs directly on its vendor public API — every field name, authentication method, and rate limit is controlled by Microsoft Power BI official API and covered in documentation [3]. WEXTL handles the request signing and pagination for you.

Absolutely. Where Microsoft Power BI provides native webhooks, you can use instant triggers to eliminate polling delay. For custom webhooks, WEXTL offers Custom Webhook node, so you can start automation whenever Microsoft Power BI or any other service sends event to webhook URL.

WEXTL is an AI-first visual canvas. The platform allows you to describe automation in plain text — and AI will wire nodes for Microsoft Power BI inside the workflow builder [4]. You can also use built-in workflow nodes (AI Agent, Human in the Loop, Condition, Aggregate Results) in pair with Microsoft Power BI modules to craft complex integration flows with branches, filtering, and conditional logic. There are absolutely no limits of what you can build.

References

List of sources used to gather information about the Microsoft Power BI integration.

Microsoft Power BI integration source code, module specs and credentials implementation.
Internal Microsoft Power BI integration documentation, structured input and output parameters, scopes, and authentication methods.
Official Microsoft Power BI vendor API documentation — used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
WEXTL® Visual Workflow Builder, anonymized data from our technical support team.
WEXTL® Apps Library
WEXTL® Microsoft Power BI App Documentation
WEXTL® Workflow Scheduler
WEXTL® HTTP node documentation

Microsoft Power BI Integration

Supported triggers and actions for Microsoft Power BI integration