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.

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.

Agent Surfaces

Microsoft Power BI CLIHeadless setup, JSON output, direct function calls. Microsoft Power BI MCPExpose selected tools to local MCP clients. Microsoft Power BI LuaAgent-facing namespace and Lua reference. FeedbackReport missing tools, auth issues, or bad metadata.

Machine-Readable Metadata

integration_slug
powerbi
route_slug
powerbi
package
microsoft-power-bi
auth_strategy
oauth2_manual_token
cli_setup_supported
true
cli_runtime_supported
true
mcp_gateway_supported
true
lua_supported
true

Function Catalog

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