Power Query Plans Pricing
Power Query itself is free and has no meter. It ships inside Excel, Power BI Desktop and the Fabric web experience at no charge, and its language toolchain and connector SDK are MIT-licensed on GitHub. What costs money is the service that RUNS a Power Query mashup on a schedule or through the REST API: a Power BI per-user license, or Fabric capacity. There is no API request quota, no per-call price and no overage rate on this surface.
Power Query Plans Pricing is the machine-readable pricing-plan profile for Power Query on the APIs.io network, conforming to the API Commons Plans specification.
It defines 6 plans, covering free, freemium, paid, usage, and capacity tiers, with named plans including Power Query (in Excel / Power BI Desktop), Power BI Free account, Power BI Pro, Power BI Premium Per User, Power BI Embedded, and 1 more.
Tagged areas include Business Intelligence, Data Integration, Microsoft Fabric, Power BI, and Pricing.
Plans
The Power Query editor, the M engine and 300+ connectors are included at no cost in Excel and Power BI Desktop. No account or capacity required.
- Power Query editor
- M formula language
- Built-in connectors
- Power Query SDK for VS Code
Included in the Microsoft Fabric free account. Create rich, interactive reports; no credit card required. Cannot share reports — upgrade to Pro or Premium to publish.
- Included in Microsoft Fabric free account
- No credit card required
- Trial capacity on any Fabric tool
Access Power BI reports shared with you and publish your own. Included in Microsoft 365 E5 and Office 365 E5.
- Publish and share Power BI reports
- Included in Microsoft 365 E5 / Office 365 E5
Everything in Pro plus enterprise-scale features for data professionals.
- All Power BI Pro features
- Larger model sizes
- More frequent refreshes
Customer-facing reports, dashboards and analytics embedded in your own application. Priced on capacity; contact sales or see the Azure pricing page.
The plan that actually governs the Power Query REST surface. A single pool of Capacity Units serves every Fabric workload, including dataflow refresh and query execution. Available pay-as-you-go or on a 1- or 3-year reservation.
Work with this as data
Every plan here is available over the APIs.io API and to AI agents over MCP.