# Power Query

**Canonical:** https://apis.io/providers/power-query/  
**Website:** https://app.powerbi.com/  
**APIs profiled:** 6

Power Query is a data transformation and mashup engine used across Microsoft products including Excel, Power BI, and Azure. This API collection provides programmatic access to Power Query functionality for data connectivity, transformation, and integration using the M formula language and connector SDK.

## Kin Score — 36.3 / 100 (thin)

Scored 2026-08-25 under rubric 0.14.0. Trend: flat (+0.0 from 36.3).

| Facet | Score |
|---|---|
| Discoverability | 74.1 |
| Contract Quality | 14.7 |
| Governance | 0.0 |
| Contract Governance | 0.0 |
| Operational Transparency | 42.1 |
| Developer Ergonomics | 38.1 |
| Commercial Clarity | 60.5 |
| Access Clarity | 60.5 |

## Agent readiness — 2.5 (human-only)

| Dimension | Value |
|---|---|
| Spec Presence | no |
| Agentic Access | no |
| Reversibility Documented | no |
| MCP Server | no |
| Auth Clarity | no |
| Idempotency | no |
| Error Semantics | no |
| OpenAPI Examples | no |
| Rate Limit Signal | documented |
| Event Surface Described | no |
| Agent Skills | no |
| Well Known Catalog | no |
| Consent Identity | no |
| Agent Card | no |
| Dry Run Mode | no |
| Delegated Identity | no |
| Protected Resource Metadata | no |
| Dynamic Client Registration | no |
| Agentic Commerce | no |

## Access

Freemium — onboarding: unknown, pricing: freemium, trial: no (confidence: medium).

## APIs (6)

- **Power Query REST API** — REST API for executing Power Query mashups and managing data transformations programmatically.
- **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 Power Query Programmatic API** — REST API for programmatically executing Power Query M transformations in Microsoft Fabric, enabling integration with Spark notebooks, pipelines, and external applications.

## Security (1)

- **Power Query Domain Security** — TLSv1.3 · HSTS · DMARC

## Plans (1)

- **Power Query Plans Pricing**

## Use cases (5)

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

## Tags

Business Intelligence, Data Integration, Data Transformation, ETL, Microsoft

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/providers/power-query/). Scores are computed from the provider's own public artifacts under a published rubric.