Analytics & Data

Connect Microsoft Power BI to Your AI Agents

Microsoft Power BI is Microsoft's business analytics platform for turning data into interactive dashboards and reports. Through this integration, WKIL agents can manage workspaces, dashboards, reports, dataset refreshes, and scorecard goals using verified actions.

Authentication: OAuth 2.0

Build with Microsoft Power BI

What you can do

Create and manage Power BI workspaces, dashboards, and capacity assignments.
Retrieve and clone reports across workspaces and apps.
Control dataset refresh operations, including cancelling an in-progress refresh.
Track goal values on Power BI scorecards with check-ins.

Available capabilities may vary by authentication and workspace configuration.

Actions supported by the connector

116 verified tools

Add Dashboard to Workspace

Creates a new empty dashboard in the specified workspace.

Get Reports From App

Returns a list of reports from the specified app.

Assign Workspace to Capacity

Assigns the specified workspace to the specified capacity.

Cancel Dataset Refresh in Workspace

Cancels the specified refresh operation for the specified dataset from the specified workspace.

Clone Report

Clones the specified report from My workspace.

Clone Report in Workspace

Clones the specified report from the specified workspace.

Create Goal Value Check-in

Creates a new goal value check-in for a Power BI scorecard goal.

Create Workspace

Creates a new workspace in Power BI.

View all verified tools (search)

Add Dashboard to WorkspaceGet Reports From AppAssign Workspace to CapacityCancel Dataset Refresh in WorkspaceClone ReportClone Report in WorkspaceCreate Goal Value Check-inCreate WorkspaceCreate Push DatasetCreate ScorecardCreate Temporary Upload LocationCreate Temporary Upload LocationDelete DashboardDelete DataflowDelete DatasetDelete Dataset from WorkspaceDelete GoalDelete Goal Note by IDDelete Goal Status RulesDelete Pipeline UserDelete Report from WorkspaceDelete Rows from Dataset TableDelete Rows from Dataset Table in WorkspaceDelete Scorecard By IDDelete WorkspaceDiscover Gateways for DatasetExecute DAX QueriesExecute DAX Queries on DatasetExecute SubscriptionGenerate Dashboard Embed TokenGenerate Embed Token for Power BIGenerate Report Embed Token in GroupGenerate Dataset Embed Token in GroupGet Available Feature By NameGet CapacitiesGet Dashboard from My WorkspaceGet DashboardsGet DataflowsGet DatasetGet Dataset in WorkspaceGet DataSet DataGet Datasets from My WorkspaceGet DataSets from Power BIGet Dataset to Dataflows LinksGet Dataset UsersGet Dataset Users In GroupGet Datasources for DatasetGet Datasources for Dataset in WorkspaceGet GatewayGet Gateway Datasources in GroupGet GatewaysGet Goals from ScorecardGet Goals Refresh HistoryGet Goals Status RulesGet Goal Value By IDGet GroupsGet Groups Capacity Assignment StatusGet Group UsersGet ImportGet Imports from My WorkspaceGet Imports in WorkspaceGet Linked Report History SnapshotGet Report PageGet Pages from ReportGet Pages from Report in My WorkspaceGet Dataset ParametersGet Dataset Parameters in WorkspaceGet Query Scale Out Sync StatusGet Refreshable For CapacityGet refreshables for all capacitiesGet Refresh Execution Details In GroupGet Refresh History for DatasetGet Dataset Refresh ScheduleGet Refresh Schedule In Group 2Get Report from My WorkspaceGet Report Page From My WorkspaceGet ReportsGet Reports From My WorkspaceGet ResourcesGet Scorecard By IDGet ScorecardsGet Tables in DatasetGet Tables in Dataset within WorkspaceGet Tiles from My Workspace DashboardGet Tiles from Workspace DashboardGet WorkspaceTrigger Query Scale Out Sync in WorkspaceMove Power BI Scorecard GoalsPatch Goal NotePatch Goal Value By IDPatch Scorecard By IDCreate Push Dataset in WorkspaceGrant Dataset User PermissionsGrant Dataset User Permissions In GroupPost GoalPost Goal NoteAdd Rows to Dataset Table in WorkspacePost Goal Status RulesUpdate Table SchemaUpdate Table Schema in WorkspaceRebind Report to DatasetTrigger Dataset Refresh in WorkspaceGenerate Report Embed Token for Create in GroupSet Linked Report Cache OptionsTake Over DatasetTake Over Paginated Report OwnershipTrigger Query Scale Out SyncUpdate DatasetUpdate Dataset In WorkspaceUpdate Paginated Report Data SourcesPatch Goal By IDUpdate Dataset Parameters in WorkspaceUpdate Refresh ScheduleUpdate Refresh Schedule In GroupUpdate Report ContentUpdate Workspace

Practical agent use cases

A BI team can have a WKIL agent create a new Power BI workspace and dashboard as part of onboarding a new department.
An operations workflow can cancel a stuck dataset refresh in a workspace before triggering a fresh one.
A leadership team can have a WKIL agent log goal-value check-ins on a Power BI scorecard as part of a regular reporting cadence.

How it works with WKIL

1
Choose the integration
Add Microsoft Power BI to your agent from inside the WKIL platform.
2
Grant the permissions it needs
Define precisely what the agent can access and perform.
3
Test, then run it
Test actions before they go live, with human approval where needed.

Permissions always stay in your control — you can scope access and require human approval before any sensitive action.

Related integrations

FAQ

What is Microsoft Power BI?

Power BI is Microsoft's business analytics platform that helps organizations connect, visualize, and share data through interactive dashboards and reports.

What does the Microsoft Power BI integration support?

The WKIL integration exposes 116 verified Power BI actions covering workspaces, dashboards, reports, datasets, refresh schedules, gateways, and scorecards. It does not currently support building new report visuals or DAX modeling from within WKIL.

Does WKIL need access to a Microsoft Power BI account?

Yes. The integration requires the appropriate Microsoft Power BI authentication and should be scoped to the permissions your workflow needs.