KosmoKrator

analytics

Microsoft Power BI MCP Integration for LangChain

Connect Microsoft Power BI to LangChain through the local KosmoKrator MCP gateway with scoped tools, credentials, and write policy.

7 functions 7 read 0 write Manual OAuth token auth
Submit Microsoft Power BI feedback View package source

Connect Microsoft Power BI to LangChain

Bridge LangChain agents to local KosmoKrator integration tools through MCP or headless CLI calls.

Use the MCP gateway when the agent should discover tools, or wrap kosmo integrations:call for fixed chains. The gateway is local, scoped to this integration, and starts with --write=deny so LangChain can inspect read-capable tools without receiving write access by default.

Microsoft Power BI MCP Config for LangChain

Keep the gateway scoped to the integration and operation class needed by the chain.

{
  "mcpServers": {
    "kosmokrator-powerbi": {
      "type": "stdio",
      "command": "kosmo",
      "args": [
        "mcp:serve",
        "--integration=powerbi",
        "--write=deny"
      ]
    }
  }
}

Run the Gateway Manually

kosmokrator mcp:serve --integration=powerbi --write=deny

Why Use KosmoKrator Here

Scoped tools

Expose only Microsoft Power BI instead of a broad multi-service tool list.

Local credentials

Reuse credentials already configured for the KosmoKrator CLI and Lua runtime.

Write policy

Start read-only, then opt into ask or allow for trusted workspaces.

Microsoft Power BI Tools Visible to LangChain

LangChain sees stable MCP tool names generated from the Microsoft Power BI integration catalog.

MCP toolSource functionTypeDescription
integration__powerbi__powerbi_list_workspaces powerbi.powerbi_list_workspaces Read List Power BI workspaces (groups) the authenticated user has access to. Returns workspace IDs and names that can be used to query datasets and reports.
integration__powerbi__powerbi_get_workspace powerbi.powerbi_get_workspace Read Get details for a specific Power BI workspace (group) by its ID.
integration__powerbi__powerbi_list_datasets powerbi.powerbi_list_datasets Read List datasets within a Power BI workspace. Returns dataset IDs, names, and configuration details.
integration__powerbi__powerbi_get_dataset powerbi.powerbi_get_dataset Read Get details for a specific Power BI dataset within a workspace, including schema and refresh configuration.
integration__powerbi__powerbi_list_reports powerbi.powerbi_list_reports Read List reports within a Power BI workspace. Returns report IDs, names, embed URLs, and associated dataset IDs.
integration__powerbi__powerbi_get_report powerbi.powerbi_get_report Read Get details for a specific Power BI report within a workspace, including embed URL and associated dataset.
integration__powerbi__powerbi_get_current_user powerbi.powerbi_get_current_user Read Get the authenticated user's Power BI profile, including display name and email address.

Related Microsoft Power BI Pages

Microsoft Power BI CLIUse direct JSON commands instead of MCP discovery. Microsoft Power BI MCPFull gateway reference and MCP tool names. KosmoKrator for LangChainClient-level gateway setup.