Power Query
Power Query is Microsoft's data connectivity and transformation engine, driven by the M formula language. It ships inside Excel, Power BI Desktop, Analysis Services, Azure Data Factory and Microsoft Fabric, and reaches 300+ data sources through built-in and custom connectors built with the MIT-licensed Power Query SDK. Its programmatic surface is the Microsoft Fabric Dataflow REST API on api.fabric.microsoft.com: thirteen Swagger-documented operations that create, read, update and delete dataflows, publish and retrieve their Power Query definitions, discover their parameters, schedule execute and applyChanges jobs, and execute an M query against a dataflow on demand. Authentication is Microsoft Entra ID OAuth 2.0 with delegated Dataflow.* and Item.* scopes layered on top of Fabric workspace roles.
Reference-quality API operations across every facet — a rich contract, published governance, transparent operations, and machine-readable commercial terms.
API Evangelist profiles Power Query the way a machine reads it — 31 machine-readable artifacts across 5 APIs, pulled from the provider's own public surface and indexed so a developer, an analyst, or an AI agent can evaluate it against every other provider on the network.
Every provider in the network is reduced to the same set of machine-readable artifacts — OpenAPI contracts, event specifications, GraphQL schemas, runnable collections, pricing and rate-limit signals, security posture, OAuth scopes, and the agent surfaces (MCP servers and skills) that let software drive the API on its own. We profile them because the interface is the part of a company you can actually inspect: it is a truer signal of what a provider does than any marketing page. From those artifacts we compute the Kin Score — Power Query scores 79.4/100 (exemplar), with a separate agent-readiness read of 33/100 (agent ready). The full breakdown is below, followed by every artifact we hold — each card links through to its machine-readable definition on apis.io.
Kin Score
This is the API Evangelist rating — a single, repeatable read computed from the artifacts on this page. Green fill is points earned; the red track is points possible, so every bar shows earned-versus-possible at a glance. Every facet and dimension name is a link: it opens that measurement's page on APIs.io, where the rating runs across the whole catalog — the exact checks that feed it, how every profiled provider distributes on it, and who is at the top of it.
Kin Score
How this is scored →scored 2026-09-08 · rubric v0.20.0
Put this on your own site. The badge is drawn live from Power Query's current Kin Score — paste it once and it updates itself every time the score is recomputed. It follows your visitor's light or dark setting, and it links back here so anyone who sees it can read the full breakdown.
<!-- Kin Score · API Evangelist -->
<a href="https://providers.apievangelist.com/providers/power-query/"
title="Power Query on API Evangelist — API profile and Kin Score">
<img src="https://apis.io/badge/power-query.svg"
alt="Power Query Kin Score — API readiness rating by API Evangelist" width="150" height="150" loading="lazy">
</a>[](https://providers.apievangelist.com/providers/power-query/)<!-- Kin Score · API Evangelist -->
<a href="https://providers.apievangelist.com/providers/power-query/"
title="Power Query on API Evangelist — API profile and Kin Score">
<img src="https://apis.io/badge/power-query/card.svg"
alt="Power Query Kin Score — API readiness rating by API Evangelist" width="340" height="120" loading="lazy">
</a>More shapes, themes and sizes → · Score as JSON · How badges work
How we profile Power Query
Each block below is one kind of artifact we hold for Power Query. For each we say what it is and why it earns a place in the profile, then list every one we've indexed — capped at two rows, scroll within the panel for the rest.
APIs 5
Each API is captured as its own OpenAPI definition — every operation, parameter, and response. This is the single most useful machine-readable description of what an API does, and it's what lets us score, lint, mock, and generate against it without asking the provider for anything.
Individual APIs this provider publishes, each with its own machine-readable definition.
Power Query M Formula Language
API and language reference for the M formula language used in Power Query for data transformation expressions and custom functions.
Power Query Connectors API
API for building and managing custom data connectors for Power Query using the M language and Connector SDK.
Power Query Dataflows API
API for managing and executing Power Query dataflows in Power Platform and Power BI for self-service ETL workflows.
Power Query SDK
Development toolkit for building custom Power Query connectors using Visual Studio Code, including project scaffolding, testing, and packaging of .mez connector files.
Fabric Dataflow REST API (Power Query)
REST API for the Microsoft Fabric Dataflow item - the productized Power Query mashup engine. Creates, reads, updates and deletes dataflows, publishes and retrieves their Power Q...
MCP Servers 1
Model Context Protocol servers expose these APIs directly to AI agents. We profile them because agent-native access is the fastest-growing way this provider's capabilities actually get used.
Model Context Protocol servers that expose these APIs to AI agents.
Microsoft Learn MCP Server
Microsoft does not publish a Power Query-specific or Fabric-specific MCP server. It does operate one official, anonymous, remote MCP server — the Microsoft Learn MCP Server — wh...
MCP SERVERPricing Plans 1
Pricing is part of the interface. Machine-readable plans tell you what a tier costs and includes before you commit — one of the things the Kin Score reads for access clarity — renamed from commercial clarity in rubric 0.12, because a free statutory interface has access terms and no commercial ones.
Published pricing tiers and plan structures.
Rate Limits 1
Rate limits are the difference between a demo that works and a production integration that doesn't fall over. Publishing them is an operational-transparency signal — and a hard requirement for any agent that plans its own throughput.
Documented rate limits and quota policies.
Power Query Rate Limits
RATE LIMITSFinOps 1
Cost, billing, and metering signals let a buyer model the financial operations of an API before it's live. We profile them for the same reason we profile pricing: the money is part of the contract.
Cost, billing, and metering signals for API financial operations.
Power Query Finops
FINOPSFeatures 6
The notable capabilities this provider advertises, captured as structured features so they can be searched and compared instead of read one landing page at a time.
Notable capabilities this provider offers.
Data Transformation Engine
Powerful M formula language for complex data transformations including filtering, pivoting, merging, and custom functions.
Custom Connector Development
Build custom data connectors using the Power Query SDK for connecting to any data source.
Self-Service ETL
Dataflows provide self-service ETL capabilities for business users without IT dependency.
300+ Built-In Connectors
Pre-built connectors for databases, cloud services, files, and web APIs.
Incremental Refresh
Efficient data loading with incremental refresh policies for large datasets.
Microsoft Fabric Integration
Execute Power Query transformations programmatically in Microsoft Fabric pipelines.
Semantic Vocabularies 1
JSON-LD contexts give the data shared meaning across APIs. We profile them because semantics are what let a machine reconcile 'customer' here with 'customer' somewhere else.
JSON-LD contexts and semantic vocabularies used across these APIs.
Power Query Context
JSON-LDSecurity Posture 4
Authentication, domain security, vulnerability disclosure, and trust-center signals — the evidence that a provider takes security seriously enough to document it. We profile it because you can't govern what you can't see.
Authentication, domain security, vulnerability disclosure, and trust-center signals.
Power Query Trust Center
ISO/IEC 27001, ISO/IEC 27017, ISO/IEC 27018, ISO/IEC 27701, ISO/IEC 42001, ISO 22301, ISO 9001, SOC 1, SOC 2, SOC 3, CSA STAR (attestation, certification, self-assessment), FedR...
SECURITYScopes 1
OAuth scopes are the vocabulary of least-privilege access. Profiling them shows exactly what an integration — or an agent acting on a user's behalf — is allowed to do.
OAuth scopes governing access to this provider's APIs.
Use Cases 5
What developers actually build with this provider — captured so the catalogue answers 'what is this for', not just 'what does this expose'.
What developers build with this provider.
Data Preparation
Clean, transform, and shape data from multiple sources for analytics and reporting.
Custom Data Connectors
Build reusable connectors for proprietary or specialized data sources.
Automated Data Pipelines
Create scheduled dataflows for automated data refresh and transformation workflows.
Cross-Platform Data Integration
Integrate data across Power BI, Excel, Azure Data Factory, and Microsoft Fabric.
Data Quality Management
Implement data quality rules and transformations for consistent enterprise data.
Integrations 5
Pre-built integrations with other platforms tell you where this provider already fits in a stack.
Pre-built integrations with other platforms and tools.
Power BI
Native integration with Power BI for data preparation and visualization workflows.
Microsoft Excel
Built-in Power Query editor in Excel for spreadsheet-based data transformation.
Azure Data Factory
Mapping data flows using Power Query transformations in Azure Data Factory.
Microsoft Fabric
Programmatic execution of Power Query in Fabric notebooks and pipelines.
SQL Server
Direct connectivity and query folding optimization for SQL Server databases.
Resources
Every other property we hold for Power Query — documentation, portals, status pages, policies, and corporate surface — grouped by the job it does, following the integrator's arc from getting started to running in production.
Get Started 5
Portal, sign-up, and the first successful call
Documentation 3
Reference material describing how the API behaves
Agent Surfaces 4
MCP servers, agent skills, and machine-readable catalogs
Design & Contract 6
Pagination, idempotency, versioning, errors, and events
Build 7
SDKs, sample code, and the tooling you integrate with
Scroll within the panel for all 7 ·
Access & Security 9
Authentication, authorization, and security posture
Scroll within the panel for all 9 ·
Learn 1
Tutorials, courses, talks, and written guidance
Operate 10
Status, limits, changes, and where to get help
Scroll within the panel for all 10 ·
Commercial 6
Pricing, plans, and the legal terms of use
Company 2
The organization behind the API
Other 1
Properties that don't map to a standard resource type
← All providers · Data indexed from github.com/api-evangelist/power-query · machine-readable index on apis.io
This is an independent, third-party profile of Power Query, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.
The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.
Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.
info@apievangelist.com
·
Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and
you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.