How to Enable Copilot in Power BI: Licences, Capacity and Tenant Settings
What Copilot in Power BI needs, the exact admin settings to switch on, why it often still does not appear, and how to prepare your models so its answers are right.
Core Engineering Takeaways
- •Copilot needs a paid capacity: Fabric F2 or larger, Power BI Premium P1 or larger, or a Fabric Copilot capacity. Trial capacities are not supported.
- •The tenant setting “Users can use Copilot and other features powered by Azure OpenAI” is enabled by default; admins can scope it to security groups.
- •Outside regions where Azure OpenAI is available, an admin must also allow data to be processed outside the capacity's region.
- •Copilot is only as good as the model: clear names, descriptions and a clean star schema matter more than any setting.
1. What Copilot in Power BI needs
Copilot does not come with a Pro or PPU licence on its own. It runs on, and is billed to, a paid capacity:
- Fabric F2 or larger (F2 is $263/month pay-as-you-go), or Power BI Premium P1 or larger.
- Or a Fabric Copilot capacity, which bills Copilot's AI usage to one designated capacity; queries against the semantic model are still charged to the model's own capacity.
- Not a trial capacity. Copilot is not supported on Fabric trials.
Users also need access to a workspace on that capacity. See the Fabric capacity pricing guide for what each size costs.
2. Turning it on: the admin settings
In the Fabric admin portal (Settings → Admin portal → Tenant settings), review these settings:
- Users can use Copilot and other features powered by Azure OpenAI — enabled by default. Use Applies to to limit it to specific security groups for a pilot.
- Data sent to Azure OpenAI can be processed outside your capacity's geographic region, compliance boundary, or national cloud instance — disabled by default. It only matters if Azure OpenAI is not available in your capacity's region; if so, Copilot will not work until it is enabled. Check with your compliance team first.
- Enable the standalone Power BI Copilot experience (preview) — the full-screen Copilot that searches across reports and models. Enabled by default for tenants that already have Copilot on.
- Only show approved items in the standalone Copilot experience — restricts that experience to items you have marked as approved, a useful guard during rollout.
Capacity admins can also manage Copilot per capacity through Delegated tenant settings, which inherit the tenant setting by default.
Reference: Enable Fabric Copilot for Power BI.
3. “I can't see Copilot” — the usual causes
- The workspace is not on a paid capacity. Pro and PPU workspaces, and trial capacities, do not show Copilot unless a Fabric Copilot capacity covers the user.
- The user is not in the security group the tenant setting applies to.
- Region. Azure OpenAI is not available in the capacity's region and the cross-geo setting is off.
- The capacity admin disabled it in the capacity's delegated settings.
- Power BI Desktop: you must be signed in and select a workspace on a Copilot-enabled capacity before the Copilot pane works.
- Propagation. Tenant setting changes can take some time to apply.
4. What you can do with Copilot in Power BI
- Ask questions about a report: summarise a page, explain a trend, find a specific figure.
- Create report pages from a prompt, as a starting point for an author to refine.
- Write and explain DAX in DAX query view, and generate measure descriptions.
- Standalone Copilot to find and ask questions across the reports and models you can access.
It is also the replacement Microsoft names for Q&A, which is retired in December 2026 — see the Q&A retirement guide.
5. Prepare your models so Copilot gets it right
Most poor Copilot answers come from the model, not from Copilot. Before rolling it out:
- Name things for people.
Total Revenueinstead ofMeasure 7,Customerinstead ofDIM_CUST_V2. - Write descriptions on key tables, columns and measures — what they mean and when to use them.
- Hide technical columns (keys, sort columns, staging fields) so Copilot does not pick them.
- Use a clean star schema. Ambiguous relationships confuse people and Copilot alike — see the data modeling best practices.
- *Use Power BI's Prep data for AI* options** to tell Copilot which fields matter, add instructions, and define verified answers for important questions.
- Watch capacity. Copilot consumes capacity units from the same capacity as your reports; monitor it in the Capacity Metrics app during the pilot.
Is your model ready for Copilot?
Check that your capacity has headroom for Copilot, or hand the model preparation and rollout to a fixed-scope sprint.
Get the next Engineering Note
Practical DAX, semantic model and Fabric notes. 1–2 a month, unsubscribe any time.