# Power Query

> Power Query is Microsoft's data connectivity and transformation engine. It ships
> inside Excel, Power BI Desktop, Analysis Services, Azure Data Factory and
> Microsoft Fabric, and it is driven by the M formula language. Its programmatic
> surface is the Microsoft Fabric Dataflow REST API on
> https://api.fabric.microsoft.com/v1 — 13 operations that create, read, update and
> delete dataflows, publish and fetch their Power Query definitions, discover their
> parameters, schedule execute and applyChanges jobs, and execute a query on demand.

Generated by the API Evangelist enrichment pipeline on 2026-08-29 from this repo's
artifacts. Microsoft publishes no /llms.txt on learn.microsoft.com (probed
2026-08-29, HTTP 404), so this file is generated, not harvested.

## Key facts

- API base URL: https://api.fabric.microsoft.com/v1 (DNS alias of api.powerbi.com)
- Contract: Swagger 2.0, published by Microsoft at github.com/microsoft/fabric-rest-api-specs
- Auth: Microsoft Entra ID OAuth 2.0 bearer tokens. No API keys.
- Authorization is TWO layers: an Entra delegated scope AND a Fabric workspace role.
- Rate limits: 200 calls/minute per identity, per API category, fixed 60-second window.
- No RateLimit-* budget headers. Retry-After on 429 is the only runtime signal.
- No idempotency key. A retried create can produce a duplicate dataflow.
- Errors are a proprietary {errorCode, message, requestId, isRetriable} envelope, not RFC 9457.
- Query execution times out at 90 seconds.
- Creating a dataflow requires the workspace to be on a supported Fabric capacity.

## Contract

- [Fabric Dataflow REST API (Swagger 2.0)](openapi/power-query-fabric-dataflow-swagger.json): 13 operations, host api.fabric.microsoft.com
- [Dataflow definitions](openapi/power-query-fabric-dataflow-definitions.json): 26 schemas
- [Shared Fabric definitions](openapi/power-query-fabric-common-definitions.json): 47 schemas including Item, ErrorResponse, PaginatedResponse
- [API Evangelist overlay](overlays/power-query-fabric-dataflow-overlay.yaml): securityDefinitions, tags and rate-limit metadata the upstream spec omits
- [Request/response examples](examples/fabric-dataflow/): 15 files published by Microsoft

## Operations

Items
- Items_ListDataflows — GET /workspaces/{workspaceId}/dataflows — scopes: Workspace.Read.All or Workspace.ReadWrite.All
- Items_CreateDataflow — POST /workspaces/{workspaceId}/dataflows — scopes: Dataflow.ReadWrite.All or Item.ReadWrite.All — 202 long-running
- Items_GetDataflow — GET /workspaces/{workspaceId}/dataflows/{dataflowId}
- Items_UpdateDataflow — PATCH /workspaces/{workspaceId}/dataflows/{dataflowId}
- Items_DeleteDataflow — DELETE /workspaces/{workspaceId}/dataflows/{dataflowId} — ?hardDelete=true is IRREVERSIBLE
- Items_GetDataflowDefinition — POST .../getDefinition — 202 long-running
- Items_UpdateDataflowDefinition — POST .../updateDefinition — 202 long-running
- Items_DiscoverDataflowParameters — GET .../parameters

BackgroundJobs
- BackgroundJobs_ScheduleExecute — POST .../jobs/execute/schedules — scopes: Dataflow.Execute.All AND Dataflow.ReadWrite.All
- BackgroundJobs_ScheduleApplyChanges — POST .../jobs/applyChanges/schedules
- BackgroundJobs_RunOnDemandExecute — POST .../jobs/execute/instances — 202, poll Location
- BackgroundJobs_RunOnDemandApplyChanges — POST .../jobs/applyChanges/instances — 202, poll Location

QueryExecution
- QueryExecution_ExecuteQuery — POST .../executeQuery — scopes: Dataflow.Execute.All or Item.Execute.All — 90s ceiling

## Artifacts in this repo

- [Authentication](authentication/power-query-authentication.yml)
- [OAuth scopes](scopes/power-query-scopes.yml)
- [Conventions, long-running ops, reversibility](conventions/power-query-conventions.yml)
- [Error catalog — 18 codes](errors/power-query-problem-types.yml)
- [Rate limits](rate-limits/power-query-rate-limits.yml)
- [Plans and pricing](plans/power-query-plans-pricing.yml)
- [Data model](data-model/power-query-data-model.yml)
- [Lifecycle, status page, deprecations](lifecycle/power-query-lifecycle.yml)
- [Changelog digest](changelog/power-query-changelog.yml)
- [Packages and SDKs](packages/power-query-packages.yml)
- [CLI (fab)](cli/power-query-cli.yml)
- [MCP](mcp/power-query-mcp.yml) and [tool crosswalk](mcp/power-query-tool-crosswalk.yml)
- [Conformance](conformance/power-query-conformance.yml)
- [Sandbox / evaluation](sandbox/power-query-sandbox.yml)
- [Vulnerability disclosure](security/power-query-vulnerability-disclosure.yml), [trust center](security/power-query-trust-center.yml), [domain security](security/power-query-domain-security.yml)
- [Well-known probe](well-known/power-query-well-known.yml)
- [Agent skills](skills/_index.yml)

## Documentation

- [Power Query documentation](https://learn.microsoft.com/en-us/power-query/)
- [M formula language reference](https://learn.microsoft.com/en-us/powerquery-m/power-query-m-function-reference)
- [Fabric Dataflow REST reference](https://learn.microsoft.com/en-us/rest/api/fabric/dataflow/items)
- [Fabric throttling](https://learn.microsoft.com/en-us/rest/api/fabric/articles/throttling)
- [Fabric scopes](https://learn.microsoft.com/en-us/rest/api/fabric/articles/scopes)
- [Long-running operations](https://learn.microsoft.com/en-us/rest/api/fabric/articles/long-running-operation)
- [Power Query SDK for VS Code](https://learn.microsoft.com/en-us/power-query/power-query-sdk-vs-code)
- [Custom connector samples](https://github.com/microsoft/DataConnectors)

## Agent notes

- There is NO Power Query-specific MCP server. Microsoft operates one anonymous
  remote MCP server, https://learn.microsoft.com/api/mcp, which answers
  documentation questions about Power Query but cannot call the Dataflow API.
- There is no A2A agent card on any Power Query, Power BI, Fabric or Microsoft
  host probed on 2026-08-29.
- api.powerquery.microsoft.com does not exist (NXDOMAIN). Any reference to a
  "Power Query REST API" on that host is wrong.