Can AI agents automate Microsoft Fabric?

Microsoft · saas · platformbusiness-intelligencedeveloper-tools

Microsoft Fabric is automatable today through the Fabric REST APIs on https://api.fabric.microsoft.com/v1/. Core APIs create, read, update, and delete items across workloads; workload APIs target specific item types such as lakehouses, notebooks, and pipelines. Callers acquire a Microsoft Entra token and send it as a Bearer header. Delegated user tokens use scopes such as Workspace.ReadWrite.All and Item.ReadWrite.All. Service principals and managed identities work after a Fabric administrator enables the Service principals can use Fabric APIs tenant setting, and each operation documents whether those identities are supported. Unified identity quotas of 200 calls per minute apply to platform, job-scheduler, and long-running-operation groups, with HTTP 429 and Retry-After on RequestBlocked, and a separate CapacityLimitExceeded path when the F SKU is overloaded. The official Fabric CLI (pip install ms-fabric-cli) browses workspaces like a file system, runs pipelines and notebooks, copies OneLake files, and signs in as a user, service principal, or managed identity. fabric-cicd is Microsoft's official Python library for publishing Git item definitions to workspaces. First-party MCP is official but preview: the remote Fabric Core MCP at https://api.fabric.microsoft.com/v1/mcp/core maps tools to REST for catalog search, workspaces, items, permissions, folders, and capacities over Streamable HTTP and Entra OAuth; it does not modify data inside items. The local Fabric MCP Server (VS Code extension, npx @microsoft/fabric-mcp, or microsoft/mcp source) adds offline API docs, OneLake file tools, and item create. This record excludes standalone Power BI and standalone Azure. Zapier, Make, Power Automate, and n8n listings were not opened. Computer-use viability is unassessed. API scores 8 and is the best path because it is the documented control plane; MCP is a limited vendor preview.

Best path today: api · Overall automatability: 8/10

Modalities

ModalityStatusDetail
APIyesrestoauth2-delegatedservice-principalmanaged-identity
coverage: partial · docs
SDKyespython
official: yes
MCPyes
verdict: official
Integrationsunknown
CLIyes
Extensibilityyesfabric-clifabric-cicd
webhooks: unknown
Data access
export: rest-json, onelake-files · import: onelake-files, fabric-cicd
RPA / UI automationunknownweb-dom
No repeatable UI probe was run. Fabric REST APIs, the official Fabric CLI, fabric-cicd, and the first-party remote Core plus local MCP servers are the documented machine paths. This record does not treat Power BI Desktop or the Azure portal as Fabric automation surfaces.
Computer useunknown
measured verdicts only — "unknown" means not yet probed by us

Scores

apimcpintegrationsclirpacomputer useoverall
86—7——8

Evidence

FactTierSourceDate
homepagedeclaredsource2026-09-09
vendordeclaredsource2026-09-09
deploymentdeclaredsource2026-09-09
platforms[0]declaredsource2026-09-09
licensedeclaredsource2026-09-09
modalities.api.existsdeclaredsource2026-09-09
modalities.api.kinds[0]declaredsource2026-09-09
modalities.api.auth[0]declaredsource2026-09-09
modalities.api.auth[1]declaredsource2026-09-09
modalities.api.auth[2]declaredsource2026-09-09
modalities.api.coveragedeclaredsource2026-09-09
modalities.api.docsdeclaredsource2026-09-09
modalities.sdk.existsdeclaredsource2026-09-09
modalities.sdk.officialdeclaredsource2026-09-09
modalities.sdk.languages[0]declaredsource2026-09-09
modalities.mcp.first_partydeclaredsource2026-09-09
modalities.mcp.verdictdeclaredsource2026-09-09
modalities.cli.existsdeclaredsource2026-09-09
modalities.extensibility.scripting[0]declaredsource2026-09-09
modalities.extensibility.scripting[1]declaredsource2026-09-09
modalities.data_access.export[0]declaredsource2026-09-09
modalities.data_access.export[1]declaredsource2026-09-09
modalities.data_access.import[0]declaredsource2026-09-09
modalities.data_access.import[1]declaredsource2026-09-09
modalities.rpa.ui_stack[0]declaredsource2026-09-09
modalities.rpa.drivabilitydeclaredsource2026-09-09
modalities.computer_use.viabilitydeclaredsource2026-09-09
modalities.agent_docs.llms_txtdeclaredsource2026-09-09
verdict.best_pathdeclaredsource2026-09-09
verdict.scores.apideclaredsource2026-09-09
verdict.scores.mcpdeclaredsource2026-09-09
verdict.scores.clideclaredsource2026-09-09
verdict.scores.overalldeclaredsource2026-09-09
freshness.watch[0].urldeclaredsource2026-09-09
freshness.watch[1].urldeclaredsource2026-09-09
freshness.watch[2].urldeclaredsource2026-09-09
freshness.watch[3].urldeclaredsource2026-09-09
freshness.watch[4].urldeclaredsource2026-09-09

Related tools

Other products in this database that share a category with Microsoft Fabric.

Last verified 2026-09-09 · volatility high · JSON record