KosmoKrator

analytics

Microsoft Power BI MCP Integration for Codex

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

6 functions 6 read 0 write Bearer token auth
Submit Microsoft Power BI feedback View package source

Connect Microsoft Power BI to Codex

Use KosmoKrator as a local MCP proxy for Codex so coding sessions can reach selected integrations with explicit write policy.

Register kosmo mcp:serve as a local stdio server and choose the integration allowlist. The gateway is local, scoped to this integration, and starts with --write=deny so Codex can inspect read-capable tools without receiving write access by default.

Microsoft Power BI MCP Config for Codex

Keep write access denied or ask-based unless the workspace is trusted.

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

Run the Gateway Manually

kosmokrator mcp:serve --integration=microsoft_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 Codex

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

MCP toolSource functionTypeDescription
integration__microsoft_powerbi__powerbi_list_reports microsoft_powerbi.powerbi_list_reports Read List all Power BI reports the authenticated user has access to. Returns report names, IDs, embed URLs, and workspace associations.
integration__microsoft_powerbi__powerbi_get_report microsoft_powerbi.powerbi_get_report Read Get details of a specific Power BI report by ID. Returns the report name, embed URL, dataset ID, and other metadata.
integration__microsoft_powerbi__powerbi_list_datasets microsoft_powerbi.powerbi_list_datasets Read List all Power BI datasets the authenticated user has access to. Returns dataset names, IDs, and workspace associations.
integration__microsoft_powerbi__powerbi_get_dataset microsoft_powerbi.powerbi_get_dataset Read Get details of a specific Power BI dataset by ID. Returns the dataset name, tables, default mode, and other metadata.
integration__microsoft_powerbi__powerbi_list_workspaces microsoft_powerbi.powerbi_list_workspaces Read List all Power BI workspaces (groups) the authenticated user has access to. Returns workspace names, IDs, and isolation modes.
integration__microsoft_powerbi__powerbi_get_current_user microsoft_powerbi.powerbi_get_current_user Read Get the profile of the currently authenticated Power BI user. Returns display name, email address, and user identity details.

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 CodexClient-level gateway setup.