Does this reach Power BI goals and scorecards?

Yes. Create Scorecard, Get Goals from Scorecard, Post Goal, Create Goal Value Check-in, and Get Goals Refresh History are all present, so Lyro can post a check-in against a goal and report how it has tracked rather than only querying the dataset underneath it.

Can Lyro write data into Power BI, or only read it?

Both. Create Push Dataset and Create Push Dataset in Workspace define a streaming dataset, Add Rows to Dataset Table in Workspace pushes rows into it, and Delete Rows from Dataset Table clears them, so a live metric can be fed straight from a conversation instead of waiting on a scheduled refresh.

What if a refresh fails because of an on-premises data source?

Lyro can see that far in. Discover Gateways for Dataset, Get Gateways, Get Datasources for Dataset, and Get Gateway Datasources in Group show which gateway and datasource a dataset depends on, and Get Refresh Execution Details In Group returns the error itself rather than a failed status.

Why do many of these actions come in both a My Workspace and a workspace version?

Power BI treats a personal workspace as a separate place from shared ones and the API mirrors that. Get Reports From My Workspace and Get Reports, or Get Dataset and Get Dataset in Workspace, address different scopes, so Lyro needs to know which one a report lives in before it can find it.

Microsoft Power Bi MCP integration

Runs DAX queries against the model, triggers and tracks dataset refreshes, generates report embed tokens, and manages workspace access.

Connect Microsoft Power Bi See all integrations

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

See all 116 actions

How businesses use Microsoft Power Bi + Lyro

Each card is one request a support team gets, and the Microsoft Power Bi actions Lyro runs to close it.

Answer a number question from the model itself
Lyro 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 Data
Refresh a dataset and know when it last ran
Lyro 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 Schedule
Put a report in front of the person asking
Lyro 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 Workspace
Keep workspace and dataset access under control
Lyro 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 — Lyro reads the Microsoft Power Bi actions it has and picks the ones a request needs.

01
Connect Microsoft Power Bi
Authorize the Microsoft Power Bi account your team already uses — one consent screen, no API keys, no mapping tables. Lyro can only do what you granted that account, and you can disconnect it at any time.
02
Tell your agent what you need
Describe the job the way you would hand it to a teammate. Lyro maps it to the Microsoft Power Bi actions that close it and chains as many as the request needs.
03
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 · Lyro

Everything else about Microsoft Power Bi

Setup, permissions, and the limits of what Lyro 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 Lyro 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.

Browse every integration

Support agent working at a laptop next to the Lyro mascot

Ready to connect Microsoft Power Bi?

Authorize the account and your agent has all 116 actions from the first conversation.

Connect Microsoft Power Bi Talk to sales

Microsoft Power Bi MCP integration

Three actions you can hand over today

Create goal value check-in

Add rows to dataset table in workspace

Trigger dataset refresh in workspace

How businesses use Microsoft Power Bi + Lyro

Answer a number question from the model itself

Refresh a dataset and know when it last ran

Put a report in front of the person asking

Keep workspace and dataset access under control

Get started in 3 steps

Connect Microsoft Power Bi

Tell your agent what you need

Watch it work

Everything else about Microsoft Power Bi

Every action available in Microsoft Power Bi

Add dashboard to workspace

Get reports from app

Assign workspace to capacity

Cancel dataset refresh in workspace

Clone report

Clone report in workspace

Create goal value check-in

Create workspace

Create push dataset

Create scorecard

Create temporary upload location

Create temporary upload location

Delete dashboard

Delete dataflow

Delete dataset

Delete dataset from workspace

Delete goal

Delete goal note by ID

Delete goal status rules

Delete pipeline user

Delete report from workspace

Delete rows from dataset table

Delete rows from dataset table in workspace

Delete scorecard by ID

Delete workspace

Discover gateways for dataset

Execute dax queries

Execute dax queries on dataset

Execute subscription

Generate dashboard embed token

The tools Microsoft Power Bi sits next to

Brightdata

Exa

Kibana

Openweather api

Securitytrails

Webscraping.ai

Ready to connect Microsoft Power Bi?