Power Query
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.
APIs
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.
Features
Powerful M formula language for complex data transformations including filtering, pivoting, merging, and custom functions.
Build custom data connectors using the Power Query SDK for connecting to any data source.
Dataflows provide self-service ETL capabilities for business users without IT dependency.
Pre-built connectors for databases, cloud services, files, and web APIs.
Efficient data loading with incremental refresh policies for large datasets.
Execute Power Query transformations programmatically in Microsoft Fabric pipelines.
Use Cases
Clean, transform, and shape data from multiple sources for analytics and reporting.
Build reusable connectors for proprietary or specialized data sources.
Create scheduled dataflows for automated data refresh and transformation workflows.
Integrate data across Power BI, Excel, Azure Data Factory, and Microsoft Fabric.
Implement data quality rules and transformations for consistent enterprise data.
Integrations
Native integration with Power BI for data preparation and visualization workflows.
Built-in Power Query editor in Excel for spreadsheet-based data transformation.
Mapping data flows using Power Query transformations in Azure Data Factory.
Programmatic execution of Power Query in Fabric notebooks and pipelines.
Direct connectivity and query folding optimization for SQL Server databases.