Microsoft Power Bi MCP integration
Runs DAX queries against the model, triggers and tracks dataset refreshes, generates report embed tokens, and manages workspace access.
116actions available
Three actions you can hand over today
Every action runs live through MCP. Nothing to build, nothing to maintain.
Create goal value check-in
Ayro records progress against scorecard goals so your team tracks milestones and performance updates in real-time. This keeps accountability transparent across departments.
Add rows to dataset table in workspace
Ayro pushes new customer records or transaction data directly into Power BI tables for real-time analysis. This keeps dashboards current without manual import steps.
Trigger dataset refresh in workspace
Ayro refreshes Power BI datasets on demand so your team sees the latest data without waiting for scheduled syncs. This ensures every report reflects current metrics.
How businesses use Microsoft Power Bi + Ayro
Each card is one request a support team gets, and the Microsoft Power Bi actions Ayro runs to close it.
Answer a number question from the model itself
Ayro reads which tables the dataset holds, runs a DAX query against it, and pulls the underlying rows, so a figure comes from the semantic model rather than from a screenshot of a tile.
Get Tables in DatasetExecute DAX Queries on DatasetGet DataSet DataRefresh a dataset and know when it last ran
Ayro triggers the refresh, reads the history and execution details to confirm it succeeded, and adjusts the schedule when the timing no longer suits, so a stale report gets fixed rather than flagged.
Trigger Dataset Refresh in WorkspaceGet Refresh History for DatasetUpdate Refresh SchedulePut a report in front of the person asking
Ayro lists the pages inside a report, generates the embed token that lets someone view it, and clones it into another workspace when a team needs a copy of their own.
Get Pages from ReportGenerate Report Embed Token in GroupClone Report in WorkspaceKeep workspace and dataset access under control
Ayro creates the workspace, grants dataset permissions to the people who need them, and reads who currently has access to a group, so a one-off request does not turn into a standing exception.
Create WorkspaceGrant Dataset User PermissionsGet Group Users
How it works
Get started in 3 steps
Connect once, then just ask. There is no workflow builder to learn and nothing to maintain — Ayro reads the Microsoft Power Bi actions it has and picks the ones a request needs.
Connect Microsoft Power Bi
Authorize the Microsoft Power Bi account your team already uses — one consent screen, no API keys, no mapping tables. Ayro can only do what you granted that account, and you can disconnect it at any time.
Tell your agent what you need
Describe the job the way you would hand it to a teammate. Ayro maps it to the Microsoft Power Bi actions that close it and chains as many as the request needs.
Watch it work
The agent runs the actions inside the conversation the customer is already in, so nobody copies data between tabs and your team can take over at any point.
Get started free
Microsoft Power Bi · Ayro
What can you do in Microsoft Power Bi without me setting anything up?
These, right away:
- Add dashboard to workspace
- Get reports from app
- Assign workspace to capacity
Great, let's start with the first one.
FAQ
Everything else about Microsoft Power Bi
Setup, permissions, and the limits of what Ayro can do inside Microsoft Power Bi.
Yes. Create Scorecard, Get Goals from Scorecard, Post Goal, Create Goal Value Check-in, and Get Goals Refresh History are all present, so Ayro can post a check-in against a goal and report how it has tracked rather than only querying the dataset underneath it.
Every action available in Microsoft Power Bi
All 116 actions your agent can call on Microsoft Power Bi, straight from the live MCP connection.
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.
Create push dataset
Creates a new dataset on My workspace in Power BI.
Create scorecard
Creates a new scorecard in the specified Power BI workspace.
Create temporary upload location
Creates a temporary blob storage upload location for importing large Power BI .pbix files that are between 1 GB and 10 GB in size.
Create temporary upload location
Creates a temporary blob storage upload location for importing large Power BI .pbix files that are between 1 GB and 10 GB in size.
Delete dashboard
Deletes the specified dashboard from My workspace.
Delete dataflow
Deletes the specified dataflow from Power BI data prep storage, including its definition file and model.
Delete dataset
Deletes the specified dataset from My workspace.
Delete dataset from workspace
Deletes the specified dataset from the specified workspace.
Delete goal
Deletes a goal from a scorecard by goal ID.
Delete goal note by ID
Deletes a goal value check-in note by its unique identifier.
Delete goal status rules
Removes status rule definitions from a goal.
Delete pipeline user
Removes user permissions from the specified deployment pipeline.
Delete report from workspace
Deletes the specified report from the specified workspace.
Delete rows from dataset table
Deletes all rows from the specified table within the specified dataset from My workspace.
Delete rows from dataset table in workspace
Deletes all rows from the specified table within the specified dataset from the specified workspace.
Delete scorecard by ID
Deletes a scorecard by its ID from the specified workspace.
Delete workspace
Deletes the specified workspace.
Discover gateways for dataset
Returns a list of gateways that the specified dataset from the specified workspace can be bound to.
Execute dax queries
Executes Data Analysis Expressions (DAX) queries against the provided dataset in My workspace.
Execute dax queries on dataset
Executes Data Analysis Expressions (DAX) queries against the specified Power BI dataset.
Execute subscription
Executes the Subscription specified by the Id.
Generate dashboard embed token
Generates an embed token to view or edit the specified dashboard from the specified workspace.
The tools Microsoft Power Bi sits next to
Same connection, same setup. Pick the next one your team already uses.
Brightdata
Triggers crawls and downloads snapshots, runs SERP queries, retrieves pages behind bot protection, and checks which proxy locations exist.
Exa
Answers a question with citations, extracts full page text, builds Websets of lookalike pages, and runs async research tasks that return reports.
Kibana
Checks Kibana and cluster health, finds the detection alerts that fired, builds dashboards and data views, and creates alerting rules and connectors.
Openweather api
Resolves a place name into coordinates, returns current conditions, five-day forecasts, air quality and UV, and registers weather stations.
Securitytrails
Pulls DNS, SSL, and infrastructure detail for a domain, queries the hosts and ips tables directly, and keeps ASI asset scope current.
Webscraping.ai
Answers questions about a live web page, extracts named fields as JSON, and pulls rendered HTML or specific elements by CSS selector.
Ready to connect Microsoft Power Bi?
Authorize the account and your agent has all 116 actions from the first conversation.