Editorial independence: AI Agent Square is not paid by the vendors we review. We currently earn no commissions from links on this site, and no vendor can pay to influence scores, rankings, or review content. How reviews are made is on our methodology page.
By Fredrik Filipsson · Reviewed by Fredrik Filipsson · 9 July 2026
Power BI Copilot is the obvious AI-analytics choice to evaluate for an organisation already standardised on Microsoft. It covers natural-language report building, DAX help and conversational data questions, and the April 2025 move that made Copilot available from an F2 capacity rather than F64 lowered the cost of entry for a pilot. The drawbacks are the licensing labyrinth — capacity plus per-user licences plus Capacity Unit throttling — and Copilot's continued dependence on a clean, well-described semantic model to produce trustworthy answers. Buy it for the ecosystem fit and the low pilot cost; budget carefully for the capacity you will actually need at scale.
Licensing note (read this first): Copilot for Power BI requires a paid Microsoft Fabric capacity of F2 or higher, or a Power BI Premium capacity of P1 or higher, with Copilot enabled in your tenant. Microsoft's documentation states plainly that a Power BI Pro or Premium Per User (PPU) licence alone is not enough — Copilot needs organisational capacity. Trial SKUs and trial capacities are explicitly not supported. This corrects the widespread belief that Copilot demands an F64: F2 pay-as-you-go is roughly $263/month in East US, versus roughly $8,410/month for F64. Larger deployments still choose bigger SKUs for throughput, not because F64 is a hard minimum.
Pricing & Licensing
Power BI Copilot Pricing & Licensing in 2026
Power BI separates two costs that buyers constantly conflate: per-user licences (who can author and share) and capacity (the infrastructure that actually runs premium and AI features). Copilot is a capacity feature. That is why the sticker price of a Pro seat tells you almost nothing about what Copilot will cost — the AI runs on the capacity, not the seat.
- Report creation & publishing
- Dashboard sharing & collaboration
- Dataflows & standard datasets
- Required seat for Copilot authors
- No Copilot without F2+/P1+ capacity
- All Power BI Pro features
- Paginated reports & AI visuals
- Larger model sizes & refresh
- Deployment pipelines
- Copilot still needs paid capacity
- Copilot report generation & chat
- Natural-language DAX authoring
- Report & semantic-model summaries
- 10,000-character Copilot prompts
- Scales up to F4/F8/…/F64 for throughput
- P1+ Premium capacity also qualifies
The full Fabric F-SKU ladder (East US, USD)
Every F-SKU from F2 up is Copilot-eligible; the choice above F2 is about throughput, not access. Capacity Units (CU) are consumed by Copilot calls alongside refresh, rendering and dataflow jobs, so busier tenants step up the ladder to avoid throttling.
| SKU | CU | PAYG / hr | Monthly PAYG | 1-yr Reserved /mo | Copilot? |
|---|---|---|---|---|---|
| F2 | 2 | $0.36 | ~$263 | ~$156 | Yes — min |
| F4 | 4 | $0.72 | ~$525 | ~$313 | Yes |
| F8 | 8 | $1.44 | ~$1,051 | ~$626 | Yes |
| F16 | 16 | $2.88 | ~$2,102 | ~$1,252 | Yes |
| F32 | 32 | $5.76 | ~$4,204 | ~$2,503 | Yes |
| F64 | 64 | $11.52 | ~$8,410 | ~$5,002 | Yes |
| F128 | 128 | $23.04 | ~$16,819 | ~$10,005 | Yes |
Figures are approximate East US rates from the Microsoft Fabric pricing page at retrieval in July 2026; reserved figures reflect the one-year reservation, which Microsoft lists as saving 40.5% over pay-as-you-go. Region and reservation term materially change the rate — re-verify in the Azure pricing calculator before budgeting. Note that F64 and above also confer free (Pro-equivalent) content consumption for viewers, which changes the per-user maths at larger scale.
Per-user licences you still need on top of capacity
| Licence | 2026 price (USD/user/mo) | Copilot access |
|---|---|---|
| Free | $0 | No (consume from F64+ workspaces only) |
| Power BI Pro | $14 (was $10 before 1 Apr 2025) | Author Copilot — only if a paid F2+/P1+ capacity backs the workspace |
| Premium Per User | $24 (was $20 before 1 Apr 2025) | Advanced authoring — still requires paid capacity for Copilot |
The practical takeaway: budget for both a capacity and the per-user seats of whoever authors with Copilot. Reserved capacity is cheaper than pay-as-you-go for steady-state workloads.
Strengths & Weaknesses
What We Like & What We Don't
- +Reports embed in Teams and SharePoint, inside the tools Microsoft 365 users already work in
- +Natural-language report generation lets non-technical users build report pages without knowing DAX or data modelling
- +Since April 2025 the F2 entry point makes a Copilot pilot cheap — roughly $263/month of capacity instead of an $8k F64
- +10,000-character prompts let analysts supply schema and business context in one message
- –Licensing is confusing — capacity plus per-user seats plus CU throttling create a decision tree that often needs a Microsoft licensing specialist
- –Pro and PPU licences alone do not switch on Copilot, which surprises buyers who assumed a seat was enough
- –Copilot output quality is only as good as your semantic model — vague measure names and messy relationships produce weak answers
- –DAX generation degrades on complex multi-table models and still needs data-team review before production use
- –Every Copilot call consumes Capacity Units and competes with refresh and rendering, so heavy interactive use can throttle a small capacity
In-Depth Analysis
Power BI Copilot Feature Review
Power BI Copilot is Microsoft's AI layer for business intelligence, embedded in both Power BI Desktop and the Power BI service and running on Azure OpenAI Service models. The most important change for buyers was a licensing one: since April 2025 Copilot is available on any paid Fabric capacity from F2 upward, rather than the F64 that gated it at launch.
The licensing reality, in plain terms
To run Copilot in the Power BI service, the report must live in a workspace backed by a paid Fabric capacity (F2 or higher) or a Power BI Premium capacity (P1 or higher), with Copilot enabled by the tenant administrator. To run Copilot in Power BI Desktop, you need write access to a workspace on such a capacity. Microsoft's documentation states that a Power BI Pro or Premium Per User licence alone is not sufficient, and trial capacities and free SKUs are not supported. The AI runs on the capacity; the per-user seat is a separate requirement for the people who author with it. Microsoft is also retiring the Premium P capacity SKUs, so new buyers are directed to F SKUs.
A lot of published guidance, including older versions of this review, still says Copilot needs an F64. It does not. F64 remains relevant for two reasons: it is the threshold at which viewers with a free licence can view Power BI content, and it provides more Capacity Unit headroom. As a minimum to switch Copilot on, F2 is the answer, at roughly $263 a month pay-as-you-go rather than roughly $8,410.
AI report generation
A user describes the analysis they want and Copilot assembles a report page with visuals, filters and annotations against the chosen semantic model. Treat the result as a first draft that an analyst finishes.
Natural-language DAX generation
DAX is Power BI's formula language. Copilot can write DAX queries from plain-language descriptions and add descriptions to existing measures. Treat every generated measure as a draft to be validated, and never publish AI-authored DAX to a production report without review.
Conversational data questions and standalone Copilot
Business users get three chat experiences: the Copilot pane on an open report (generally available), the standalone full-screen Copilot that searches any report or semantic model the user can access (preview), and Copilot scoped to an app (preview). Microsoft's own guidance is that without a prepared semantic model Copilot can misinterpret the data and return generic or inaccurate results.
Copilot in Power BI Desktop
In Power BI Desktop, authors with write access to a Copilot-enabled workspace can use Copilot to build and refine reports, summarise the semantic model, draft measure descriptions and generate narrative visuals. The licence and the capacity are complementary, not alternatives.
The semantic model is the product
Copilot works from your model's metadata: table and column names, measure definitions, relationships and descriptions. Teams considering Copilot should budget time to add measure descriptions, tidy relationships and curate a clean model surface; Microsoft publishes guidance on preparing a model for AI for this reason.
Capacity Units, throttling and the cost you can't see on the price page
Copilot usage consumes Capacity Units against your Fabric capacity, shared with scheduled refreshes, report rendering, dataflows and other Fabric workloads. Microsoft processes Copilot consumption as background operations, smoothed over time, and bills downstream actions such as DAX queries and refreshes separately. Capacity admins can see Copilot usage in the Fabric Capacity Metrics app. Size a capacity for peak concurrent Copilot use plus your existing refresh and rendering load.
Governance, security and data residency
Copilot operates within the tenant's existing identity, role and workspace permissions. Administrators control whether Copilot is enabled at the tenant and capacity level. If your tenant or capacity is outside the US or EU data boundary, Copilot is off by default until an admin allows data to be processed outside the region, and sovereign clouds are not supported. Verify data residency against your own compliance requirements.
Ecosystem
Power BI Copilot Integrations
Copilot works on whatever Power BI connects to through Power Query.
Best Applications
Where Power BI Copilot Excels
Buyer Fit
Who It's For & Who Should Skip It
- →Already standardised on Microsoft 365, Azure and Power BI — the integration and governance fit is decisive
- →Running a Copilot pilot and want a cheap entry point — an F2 capacity makes proof-of-value affordable
- →A team with well-modelled, well-documented semantic models that Copilot can reason over accurately
- →Trying to give non-technical business users conversational access to trusted, governed data
- →Not on the Microsoft stack — the ecosystem advantage that justifies Copilot largely evaporates
- →Expecting Copilot to work off a Pro or PPU seat alone — it will not without paid F2+/P1+ capacity
- →Working with messy, undocumented models and unwilling to invest in cleaning them first
- →A power analyst who needs the most sophisticated custom visual analytics — Tableau still leads there
Alternatives
Power BI Copilot Alternatives
The Verdict
Our Verdict on Power BI Copilot
Power BI Copilot is the natural AI-analytics choice for an organisation already in the Microsoft ecosystem. The April 2025 move that made Copilot available from an F2 capacity, not F64, turned a capital decision into an affordable pilot. The drawbacks are consistent: the licensing model of capacity, per-user seats and Capacity Unit consumption often needs specialist help, and Copilot is only as useful as your semantic model. For Microsoft-committed buyers it is worth piloting with clear-eyed budgeting; for everyone else, the ecosystem case is not there.
Sources
Sources Used for This Review
- Copilot for Power BI overview, Microsoft Learn, checked 11 October 2026
- Copilot and AI capabilities now accessible to all paid SKUs in Microsoft Fabric, Microsoft Fabric Blog, checked 11 October 2026
- Understand Microsoft Fabric licenses and capacity, Microsoft Learn, checked 11 October 2026
- Power BI pricing, Microsoft, checked 11 October 2026
- Azure Retail Prices API, Microsoft Fabric, East US, Microsoft, checked 11 October 2026
- Microsoft Power BI price increases of 1 April 2025, The Register, checked 11 October 2026
FAQ
Frequently Asked Questions
See how it stacks up on capability, licensing and real cost against the other data-analysis AI tools we review — no vendor pays for placement.