Integration

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.

Ask it in chat

Say what should happen.
The workflow builds itself.

When this happens, do that in Power BI.Built from the 29 Power BI tools below, on the connection you add once.

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 workspace
  • export_reportExport reportPOSTExport a report to a file format such as PDF, PNG, or PPTX. Returns an export ID to poll for completion
  • get_reportGet reportGETGet details of a specific report by its ID from My Workspace
  • list_reportsList reportsGETList all reports in the user's My Workspace
  • list_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 Workspace
  • get_datasetGet datasetGETGet details of a specific dataset by its ID from My Workspace
  • list_datasetsList datasetsGETList all datasets in the user's My Workspace
  • list_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 capacity
  • delete_groupDelete groupDELETEDelete a workspace (group) by its ID. All content in the workspace will be deleted
  • get_groupGet groupGETGet details of a specific workspace (group) by its ID
  • list_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 Workspace
  • list_dashboardsList dashboardsGETList all dashboards in the user's My Workspace
  • list_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 role
  • delete_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 Workspace
  • get_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 Code
claude mcp add --transport http livecontext https://livecontext.ai/mcp --header "X-API-Key: YOUR_API_KEY"
Codex (~/.codex/config.toml)
[mcp_servers.livecontext]
url = "https://livecontext.ai/mcp"

[mcp_servers.livecontext.http_headers]
"X-API-Key" = "YOUR_API_KEY"
Cursor, Claude Desktop and other JSON configs
{
  "mcpServers": {
    "livecontext": {
      "type": "http",
      "url": "https://livecontext.ai/mcp",
      "headers": {
        "X-API-Key": "YOUR_API_KEY"
      }
    }
  }
}

Set up the MCP server step by step

How to connect Power BI

  1. Create your workspace

    Sign up free. Nothing to install.

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

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

Popular integrations

Browse the whole catalog