analytics
Microsoft Power BI MCP, CLI, and Lua Integration for AI Agents
Microsoft Power BI integration docs for AI agents: MCP gateway setup, Microsoft Power BI CLI commands, Lua API reference, credentials, and function schemas.
7 functions 7 read 0 write Manual OAuth token auth
Microsoft Power BI for agents
Credentials can be configured manually in web or CLI hosts.
Use this integration from Lua code mode, the headless integrations CLI, or the KosmoKrator MCP gateway. The same package metadata powers all three surfaces.
Machine-Readable Metadata
- integration_slug
powerbi- route_slug
powerbi- package
microsoft-power-bi- auth_strategy
oauth2_manual_tokenManual OAuth token- cli_setup_supported
true- cli_runtime_supported
true- mcp_gateway_supported
true- lua_supported
true- supports_multi_account
true
Quick Links
Lua APIAgent-facing namespace and function reference. Microsoft Power BI CLIHeadless setup and direct function calls. Microsoft Power BI MCPMCP gateway setup for external clients. Submit feedbackReport missing tools, auth problems, wrong docs, or runtime issues. ContributeAdd tools or improve metadata in the integrations repo.
Microsoft Power BI MCP Client Matrix
Use these pages when a specific agent client or framework needs copy-pasteable MCP setup for Microsoft Power BI.
Claude Code Microsoft Power BI MCP setup for Claude Code. Cursor Microsoft Power BI MCP setup for Cursor. Codex Microsoft Power BI MCP setup for Codex. OpenAI Agents Microsoft Power BI MCP setup for OpenAI Agents SDK. Claude Agent SDK Microsoft Power BI MCP setup for Claude Agent SDK. Vercel AI SDK Microsoft Power BI MCP setup for Vercel AI SDK. LangChain Microsoft Power BI MCP setup for LangChain. LangGraph Microsoft Power BI MCP setup for LangGraph. CrewAI Microsoft Power BI MCP setup for CrewAI. MCP clients Microsoft Power BI MCP setup for Generic MCP Clients.
Microsoft Power BI CLI Matrix
Use these pages for direct Microsoft Power BI CLI workflows in scripts, CI, cron, and agent wrappers.
CI Microsoft Power BI CLI for CI. Cron Jobs Microsoft Power BI CLI for cron jobs. Shell Scripts Microsoft Power BI CLI for shell scripts. Headless Automation Microsoft Power BI CLI for headless automation. Coding Agents Microsoft Power BI CLI for coding agents.
Function Catalog
| Function | Type | Parameters | Description |
|---|---|---|---|
powerbi.powerbi_list_workspaces | Read read | 1 | 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. |
powerbi.powerbi_get_workspace | Read read | 1 | Get details for a specific Power BI workspace (group) by its ID. |
powerbi.powerbi_list_datasets | Read read | 1 | List datasets within a Power BI workspace. Returns dataset IDs, names, and configuration details. |
powerbi.powerbi_get_dataset | Read read | 2 | Get details for a specific Power BI dataset within a workspace, including schema and refresh configuration. |
powerbi.powerbi_list_reports | Read read | 1 | List reports within a Power BI workspace. Returns report IDs, names, embed URLs, and associated dataset IDs. |
powerbi.powerbi_get_report | Read read | 2 | Get details for a specific Power BI report within a workspace, including embed URL and associated dataset. |
powerbi.powerbi_get_current_user | Read read | 0 | Get the authenticated user's Power BI profile, including display name and email address. |