Power Query

aid: power-query
name: Power Query
description: '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.'
type: Index
deliveryModel:
  model: open-core
  license: MIT
  open_source: true
  commercial: true
  callable_host: false
  label: Open core · an OSS project plus a commercial hosted product
  confidence: high
  source:
  - license
  - pricing
  generated: '2026-08-28'
  method: derived
accessModel:
  pricing: freemium
  onboarding: unknown
  trial: false
  try_now: false
  public: false
  label: Freemium
  confidence: medium
  source:
  - plans
  generated: '2026-07-22'
  method: derived
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/power-query.png
url: https://powerquery.microsoft.com/
created: '2024-01-01'
modified: '2026-08-29'
specificationVersion: '0.23'
tags:
- Business Intelligence
- Data Integration
- Data Transformation
- ETL
- Microsoft
- Microsoft Fabric
- Power BI
- Dataflows
- M Language
- Data Connectors
- Self-Service ETL
apis:
- 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://learn.microsoft.com/en-us/powerquery-m/
  baseURL: https://learn.microsoft.com/powerquery-m/
  tags:
  - Formula Language
  - Functions
  - M Language
  properties:
  - type: Documentation
    url: https://learn.microsoft.com/en-us/powerquery-m/
  - type: APIReference
    url: https://learn.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://learn.microsoft.com/en-us/power-query/connectors/
  baseURL: https://github.com/Microsoft/DataConnectors
  tags:
  - Connectors
  - Data Sources
  - SDK
  properties:
  - type: Documentation
    url: https://learn.microsoft.com/en-us/power-query/install-sdk
  - type: SDKs
    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://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service
  baseURL: https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows
  tags:
  - Dataflows
  - Power Platform
  - Self-Service ETL
  properties:
  - type: Documentation
    url: https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service
  - type: APIReference
    url: https://learn.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 Dataflow REST API (Power Query)
  description: 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 Query definitions, discovers their parameters, schedules
    execute and applyChanges jobs, and executes a Power Query M query against a dataflow on demand. Thirteen operations, Swagger
    2.0, published by Microsoft at github.com/microsoft/fabric-rest-api-specs.
  humanURL: https://learn.microsoft.com/en-us/rest/api/fabric/dataflow/items
  baseURL: https://api.fabric.microsoft.com/v1
  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
  - type: OpenAPI
    url: openapi/power-query-fabric-dataflow-swagger.json
  - type: APIReference
    url: https://learn.microsoft.com/en-us/rest/api/fabric/dataflow/items
  - type: Examples
    url: examples/fabric-dataflow/
  - type: Overlay
    url: overlays/power-query-fabric-dataflow-overlay.yaml
  - type: Authentication
    url: authentication/power-query-authentication.yml
  - type: OAuthScopes
    url: scopes/power-query-scopes.yml
  - type: Conventions
    url: conventions/power-query-conventions.yml
  - type: DataModel
    url: data-model/power-query-data-model.yml
  - type: ErrorCatalog
    url: errors/power-query-problem-types.yml
  - type: RateLimits
    url: rate-limits/power-query-rate-limits.yml
common:
- type: Website
  url: https://powerquery.microsoft.com/
- type: VulnerabilityDisclosure
  url: security/power-query-vulnerability-disclosure.yml
- type: IssueTracker
  url: https://github.com/Microsoft/DataConnectors/issues
- type: Releases
  url: https://github.com/Microsoft/DataConnectors/releases
- type: SecurityPolicy
  url: https://github.com/microsoft/DataConnectors/blob/master/SECURITY.md
- type: CodeOfConduct
  url: https://github.com/microsoft/DataConnectors/blob/master/CODE_OF_CONDUCT.md
- type: License
  name: MIT
  url: https://github.com/Microsoft/DataConnectors/blob/master/LICENSE
- type: DomainSecurity
  url: security/power-query-domain-security.yml
- 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/microsoft
- 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: DeveloperPortal
  url: https://learn.microsoft.com/en-us/rest/api/fabric/dataflow/items
- type: APIReference
  url: https://learn.microsoft.com/en-us/powerquery-m/power-query-m-function-reference
- type: Roadmap
  url: https://roadmap.fabric.microsoft.com/
- type: OpenAPI
  url: openapi/power-query-fabric-dataflow-swagger.json
- type: Examples
  url: examples/fabric-dataflow/
- type: Overlay
  url: overlays/power-query-fabric-dataflow-overlay.yaml
- type: Packages
  url: packages/power-query-packages.yml
- type: SDKs
  url: packages/power-query-packages.yml
- type: CLI
  url: cli/power-query-cli.yml
- type: WellKnown
  url: well-known/power-query-well-known.yml
- type: SecurityTxt
  url: well-known/power-query-security.txt
- type: MCPServer
  url: mcp/power-query-mcp.yml
- type: ToolCrosswalk
  url: mcp/power-query-tool-crosswalk.yml
- type: LLMsTxt
  url: llms/power-query-llms.txt
- type: AgentSkill
  url: skills/_index.yml
- type: Authentication
  url: authentication/power-query-authentication.yml
- type: OAuthScopes
  url: scopes/power-query-scopes.yml
- type: Conventions
  url: conventions/power-query-conventions.yml
- type: ErrorCatalog
  url: errors/power-query-problem-types.yml
- type: DataModel
  url: data-model/power-query-data-model.yml
- type: Lifecycle
  url: lifecycle/power-query-lifecycle.yml
- type: Deprecation
  url: lifecycle/power-query-lifecycle.yml
- type: Conformance
  url: conformance/power-query-conformance.yml
- type: Compliance
  url: conformance/power-query-conformance.yml
- type: Security
  url: security/power-query-vulnerability-disclosure.yml
- type: TrustCenter
  url: security/power-query-trust-center.yml
- type: Sandbox
  url: sandbox/power-query-sandbox.yml
- type: Plans
  url: plans/power-query-plans-pricing.yml
- type: RateLimits
  url: rate-limits/power-query-rate-limits.yml
- type: FinOps
  url: finops/power-query-finops.yml
- type: Vocabulary
  url: vocabulary/power-query-vocabulary.yml
- type: ChangeLog
  url: changelog/power-query-changelog.yml
- 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
x-enrichment:
  date: '2026-08-29'
  status: enriched
  artifacts_added: 43
  pass: local-v1
x-parent: microsoft-azure
x-relationship: product