Power BI integration
Microsoft Power BI REST API for managing workspaces, datasets, reports, dashboards, and data refresh operations. Embed analytics, push data to datasets, and control access to business intelligence resources.
Say what should happen.
The workflow builds itself.
Common Power BI use cases
- automate report management
- automate group management
- automate dataset management
- automate dashboard management
- list report programmatically
- list dataset programmatically
- list dashboard programmatically
- automate group user management
- get group programmatically
- list tile programmatically
What you can do with Power BI
Each of these is one operation on one endpoint, available both as a workflow step and as a tool an AI agent can call on its own. Nothing bundles several operations into one action, so what a run did stays readable afterwards.
Most endpoints run on the free plan. A few, mainly the ones that publish on your behalf, need a paid plan.
Report, 5 operations
clone_reportClone reportPOSTClone a report from My Workspace. The cloned report can be placed in the same or a different workspaceexport_reportExport reportPOSTExport a report to a file format such as PDF, PNG, or PPTX. Returns an export ID to poll for completionget_reportGet reportGETGet details of a specific report by its ID from My Workspacelist_reportsList reportsGETList all reports in the user's My Workspacelist_reports_in_groupList reports in groupGETList all reports in a specific workspace (group)
Dataset, 4 operations
delete_datasetDelete datasetDELETEDelete a dataset by its ID from My Workspaceget_datasetGet datasetGETGet details of a specific dataset by its ID from My Workspacelist_datasetsList datasetsGETList all datasets in the user's My Workspacelist_datasets_in_groupList datasets in groupGETList all datasets in a specific workspace (group)
Group, 4 operations
create_groupCreate groupPOSTCreate a new workspace (group). Optionally create it as a workspace V2 backed by a capacitydelete_groupDelete groupDELETEDelete a workspace (group) by its ID. All content in the workspace will be deletedget_groupGet groupGETGet details of a specific workspace (group) by its IDlist_groupsList groupsGETList all workspaces (groups) the user has access to. Returns workspace IDs, names, capacity assignment, and read-only status
Dashboard, 3 operations
get_dashboardGet dashboardGETGet details of a specific dashboard by its ID from My Workspacelist_dashboardsList dashboardsGETList all dashboards in the user's My Workspacelist_dashboards_in_groupList dashboards in groupGETList all dashboards in a specific workspace (group)
Group user, 2 operations
add_group_userAdd group userPOSTAdd a user to a workspace (group) with a specified access roledelete_group_userDelete group userDELETERemove a user from a workspace (group) by their email address
Refresh history, 2 operations
get_refresh_historyGet refresh historyGETGet the refresh history for a specific dataset in My Workspaceget_refresh_history_in_groupGet refresh history in groupGETGet the refresh history for a specific dataset in a workspace (group)
Dataflow, 1 operation
list_dataflows_in_groupList dataflows in groupGETList all dataflows in a specific workspace (group). Dataflows are reusable ETL logic for data preparation
Dataset table, 1 operation
get_dataset_tablesGet dataset tablesGETGet all tables and their column schemas within a specific push dataset in My Workspace. Only supports push datasets
Generate embed token, 1 operation
generate_embed_tokenGenerate embed tokenPOSTGenerate an embed token for embedding Power BI content (reports, dashboards, datasets) in external applications
Push dataset, 1 operation
create_push_datasetCreate push datasetPOSTCreate a new push dataset in My Workspace. Push datasets allow real-time data ingestion via the Push Rows API
Push row, 1 operation
push_rowsPush rowsPOSTPush data rows into a specific table within a push dataset. The dataset must be a push dataset created with the Push Datasets API
Refresh dataflow, 1 operation
refresh_dataflowRefresh dataflowPOSTTrigger a refresh for a specific dataflow in a workspace
Refresh dataset, 1 operation
refresh_datasetRefresh datasetPOSTTrigger a refresh operation for a specific dataset in My Workspace
Row, 1 operation
delete_rowsDelete rowsDELETEDelete all rows from a specific table within a push dataset
Tile, 1 operation
list_tilesList tilesGETList all tiles (visualizations) on a specific dashboard in My Workspace
Use Power BI from Claude Code, Cursor or Codex
Connect Power BI in LiveContext, create an API key in Settings, then add the LiveContext MCP server to your client. Its Power BI operations become tools the client can call, next to every other integration you connected.
claude mcp add --transport http livecontext https://livecontext.ai/mcp --header "X-API-Key: YOUR_API_KEY"[mcp_servers.livecontext]
url = "https://livecontext.ai/mcp"
[mcp_servers.livecontext.http_headers]
"X-API-Key" = "YOUR_API_KEY"{
"mcpServers": {
"livecontext": {
"type": "http",
"url": "https://livecontext.ai/mcp",
"headers": {
"X-API-Key": "YOUR_API_KEY"
}
}
}
}How to connect Power BI
- Create your workspace
Sign up free. Nothing to install.
- Connect Power BI once
Add your Power BI connection in Settings. Every tool from this integration reuses it, and secrets are encrypted at rest and visible only to you.
- Describe the job in chat
The workflow builds itself in front of you and picks the endpoints it needs. Drag the steps yourself on the canvas whenever you would rather be explicit.
Power BI integration FAQ
What can you do with the Power BI integration?
LiveContext exposes 29 operations on Power BI, covering report, dataset, group and dashboard. Common uses include automate report management, automate group management and automate dataset management.
