aid: power-query name: Power Query description: >- 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. type: Index image: https://kinlane-productions.s3.amazonaws.com/apis-json/apis-json-logo.jpg url: >- https://raw.githubusercontent.com/api-evangelist/power-query/refs/heads/main/apis.yml created: '2024-01-01' modified: '2026-04-18' specificationVersion: '0.19' tags: - Business Intelligence - Data Integration - Data Transformation - ETL - Microsoft apis: - aid: power-query:rest-api name: Power Query REST API description: >- REST API for executing Power Query mashups and managing data transformations programmatically. humanURL: https://docs.microsoft.com/en-us/power-query/power-query-rest-api baseURL: https://api.powerquery.microsoft.com/v1.0 tags: - Data Query - Mashup Engine - REST properties: - type: Documentation url: https://docs.microsoft.com/en-us/power-query/power-query-rest-api - type: Authentication url: https://docs.microsoft.com/en-us/power-query/authentication - type: GettingStarted url: https://learn.microsoft.com/en-us/power-query/power-query-what-is-power-query - aid: power-query:m-language name: Power Query M Formula Language description: >- API and language reference for the M formula language used in Power Query for data transformation expressions and custom functions. humanURL: https://docs.microsoft.com/en-us/powerquery-m/ baseURL: https://docs.microsoft.com/powerquery-m/ tags: - Formula Language - Functions - M Language properties: - type: Documentation url: https://docs.microsoft.com/en-us/powerquery-m/ - type: APIReference url: https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference - type: GettingStarted url: https://learn.microsoft.com/en-us/powerquery-m/quick-tour-of-the-power-query-m-formula-language - aid: power-query:connectors-api name: Power Query Connectors API description: >- API for building and managing custom data connectors for Power Query using the M language and Connector SDK. humanURL: https://docs.microsoft.com/en-us/power-query/connectors/ baseURL: https://github.com/Microsoft/DataConnectors tags: - Connectors - Data Sources - SDK properties: - type: Documentation url: https://docs.microsoft.com/en-us/power-query/installingsdk - type: SDK url: https://aka.ms/powerquerysdk - type: GitHubRepository url: https://github.com/Microsoft/DataConnectors - type: GettingStarted url: https://learn.microsoft.com/en-us/power-query/creating-first-connector - aid: power-query:dataflows-api name: Power Query Dataflows API description: >- API for managing and executing Power Query dataflows in Power Platform and Power BI for self-service ETL workflows. humanURL: https://docs.microsoft.com/en-us/power-query/dataflows/ baseURL: https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows tags: - Dataflows - Power Platform - Self-Service ETL properties: - type: Documentation url: https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service - type: APIReference url: https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows - type: GettingStarted url: https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service - aid: power-query:sdk name: Power Query SDK description: >- Development toolkit for building custom Power Query connectors using Visual Studio Code, including project scaffolding, testing, and packaging of .mez connector files. humanURL: https://learn.microsoft.com/en-us/power-query/install-sdk baseURL: https://learn.microsoft.com/en-us/power-query/power-query-sdk-vs-code tags: - Connector Development - SDK - Tooling - VS Code properties: - type: Documentation url: https://learn.microsoft.com/en-us/power-query/power-query-sdk-vs-code - type: GettingStarted url: https://learn.microsoft.com/en-us/power-query/install-sdk - type: GitHubRepository url: https://github.com/microsoft/vscode-powerquery-sdk - aid: power-query:fabric-api name: Fabric Power Query Programmatic API description: >- REST API for programmatically executing Power Query M transformations in Microsoft Fabric, enabling integration with Spark notebooks, pipelines, and external applications. humanURL: https://blog.fabric.microsoft.com/en-US/blog/execute-power-query-programmatically-in-microsoft-fabric/ baseURL: https://learn.microsoft.com/en-us/fabric/data-factory/ tags: - Microsoft Fabric - Pipelines - Programmatic Execution - REST properties: - type: Documentation url: https://blog.fabric.microsoft.com/en-US/blog/execute-power-query-programmatically-in-microsoft-fabric/ - type: APIReference url: https://learn.microsoft.com/en-us/fabric/data-factory/pipeline-rest-api common: - type: Portal url: https://app.powerbi.com/ - type: Documentation url: https://learn.microsoft.com/en-us/power-query/ - type: GettingStarted url: https://www.microsoft.com/en-us/power-platform/products/power-bi/getting-started-with-power-bi - type: Blog url: https://powerbi.microsoft.com/blog/ - type: GitHubOrganization url: https://github.com/MicrosoftDocs/powerquery-docs - type: Support url: https://powerbi.microsoft.com/en-us/support/ - type: Pricing url: https://powerbi.microsoft.com/pricing/ - type: StatusPage url: https://support.fabric.microsoft.com/ - type: TermsOfService url: https://www.microsoft.com/en-us/servicesagreement/ - type: PrivacyPolicy url: https://privacy.microsoft.com/en-us/privacystatement - type: SignUp url: https://www.microsoft.com/en-us/power-platform/products/power-bi/landing/free-account - type: StackOverflow url: https://stackoverflow.com/questions/tagged/powerquery - type: YouTube url: https://www.youtube.com/channel/UCFp1vaKzpfvoGai0vE5VJ0w - type: ChangeLog url: https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-change-log - type: Features data: - name: Data Transformation Engine description: Powerful M formula language for complex data transformations including filtering, pivoting, merging, and custom functions. - name: Custom Connector Development description: Build custom data connectors using the Power Query SDK for connecting to any data source. - name: Self-Service ETL description: Dataflows provide self-service ETL capabilities for business users without IT dependency. - name: 300+ Built-In Connectors description: Pre-built connectors for databases, cloud services, files, and web APIs. - name: Incremental Refresh description: Efficient data loading with incremental refresh policies for large datasets. - name: Microsoft Fabric Integration description: Execute Power Query transformations programmatically in Microsoft Fabric pipelines. - type: UseCases data: - name: Data Preparation description: Clean, transform, and shape data from multiple sources for analytics and reporting. - name: Custom Data Connectors description: Build reusable connectors for proprietary or specialized data sources. - name: Automated Data Pipelines description: Create scheduled dataflows for automated data refresh and transformation workflows. - name: Cross-Platform Data Integration description: Integrate data across Power BI, Excel, Azure Data Factory, and Microsoft Fabric. - name: Data Quality Management description: Implement data quality rules and transformations for consistent enterprise data. - type: Integrations data: - name: Power BI description: Native integration with Power BI for data preparation and visualization workflows. - name: Microsoft Excel description: Built-in Power Query editor in Excel for spreadsheet-based data transformation. - name: Azure Data Factory description: Mapping data flows using Power Query transformations in Azure Data Factory. - name: Microsoft Fabric description: Programmatic execution of Power Query in Fabric notebooks and pipelines. - name: SQL Server description: Direct connectivity and query folding optimization for SQL Server databases. maintainers: - FN: Kin Lane email: kin@apievangelist.com url: https://apievangelist.com