KosmoKrator

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_token Bearer token
cli_setup_supported
true
cli_runtime_supported
true
mcp_gateway_supported
true
lua_supported
true
supports_multi_account
true

Quick Links

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.

Microsoft Power BI CLI Matrix

Use these pages for direct Microsoft Power BI CLI workflows in scripts, CI, cron, and agent wrappers.

Function Catalog

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