Power BI Copilot
Copilot in Power BI is Microsoft's generative AI assistant inside Power BI, for business users, report authors and data model owners. It offers chat-based experiences where users can ask questions about their data, get summaries of reports and visuals, and quickly create and edit report pages from natural-language prompts, including generating DAX measures. It is designed to help people get insights from their data without manual report building, with answers grounded in the report's semantic model where the question relates to that model.
Copilot has no separate per-user price; it requires a paid Fabric capacity (F2 or higher) or Power BI Premium (P1 or higher), with Power BI Pro $14/user/mo also needed below F64 capacity; the smallest qualifying Fabric capacity, F2, is about $262.80/mo pay-as-you-go
How to use Power BI Copilot
- Select a report, then in the Power BI service select the Edit button to enter Edit view.
- In the ribbon, select the Copilot icon. If you do not see Copilot, your admin may not have enabled it in Microsoft Fabric, or you may need to select a semantic model first.
- In the Copilot pane, select Suggest content for this report or enter a prompt describing the report or visuals you want Copilot to create.
- Review the report page Copilot generates, then prompt it to add, delete, or change visuals, and save the report when you are satisfied.
Frequently asked questions
Is Power BI Copilot free?
Copilot has no separate per-user price, but it requires a paid Fabric capacity (F2 or higher) or Power BI Premium (P1 or higher), with Power BI Pro at $14 per user per month also needed below F64 capacity. The smallest qualifying Fabric capacity, F2, is about $262.80 per month pay-as-you-go.
Do I need anything enabled before Copilot can create report pages?
Yes. Your admin must have Copilot enabled in Microsoft Fabric, you need a semantic model selected, and the Q and A feature switch must be turned on for your model.
What can Copilot in Power BI do?
It creates and edits report pages from natural-language prompts, generates DAX measures, creates narrative summaries of whole reports, specific pages, or specific visuals, and answers questions about your data grounded in the report's semantic model.
Pros & cons
Pros
- Generates complete report pages with professional visualizations from a plain-language prompt, without manual configuration.
- Edits by prompt too: add, delete, or change visuals on existing pages, with undo and redo to reverse recent Copilot actions.
- Creates narrative summaries of reports, pages, or visuals in a few clicks, helping you plan what to include.
Cons
- Copilot cannot create report pages for semantic models that use real-time streaming or a live connection to Analysis Services, and it does not support custom visuals or styling and formatting changes.
- There is no free route: it needs paid Fabric capacity or Power BI Premium, so the real cost is the capacity, not a Copilot subscription.
Related Data & Analytics tools
- Tableau AIPaid · Tableau
- Julius AIFreemium · Julius AI
- Polymer SearchPaid · Polymer
- AkkioPaid · Akkio
- Obviously AIObviously AI
- DataRobotPaid · DataRobot
- H2O.aiFreemium · H2O.ai
- KNIMEFreemium · KNIME