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.
6 functions 6 read 0 write Bearer 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
microsoft_powerbi- route_slug
microsoft-powerbi- package
microsoft-powerbi- auth_strategy
bearer_tokenBearer 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 |
|---|---|---|---|
microsoft_powerbi.powerbi_list_reports | Read read | 0 | List all Power BI reports the authenticated user has access to. Returns report names, IDs, embed URLs, and workspace associations. |
microsoft_powerbi.powerbi_get_report | Read read | 1 | Get details of a specific Power BI report by ID. Returns the report name, embed URL, dataset ID, and other metadata. |
microsoft_powerbi.powerbi_list_datasets | Read read | 0 | List all Power BI datasets the authenticated user has access to. Returns dataset names, IDs, and workspace associations. |
microsoft_powerbi.powerbi_get_dataset | Read read | 1 | Get details of a specific Power BI dataset by ID. Returns the dataset name, tables, default mode, and other metadata. |
microsoft_powerbi.powerbi_list_workspaces | Read read | 0 | List all Power BI workspaces (groups) the authenticated user has access to. Returns workspace names, IDs, and isolation modes. |
microsoft_powerbi.powerbi_get_current_user | Read read | 0 | Get the profile of the currently authenticated Power BI user. Returns display name, email address, and user identity details. |