12 min
Lesson 1 of 4
Getting Started with Copilot in Power BI
From the course Power BI Copilot
Microsoft Copilot in Power BI transforms how you create reports and analyze data. Instead of manually building visuals, you can describe what you want in plain English.
What Copilot Can Do
- Create reports: "Build a sales dashboard showing revenue by region and product"
- Generate visuals: "Add a line chart showing monthly trends"
- Write DAX: "Create a measure that calculates year-over-year growth"
- Explain insights: "Why did revenue spike in March?"
- Create narratives: Auto-generate text summaries of your data
Requirements
- Power BI Pro or Premium Per User license
- Microsoft Fabric capacity (F64 or higher) or Power BI Premium
- Data model published to a Power BI workspace
- Copilot enabled by your admin
Using Copilot
Report Creation
- Open a new report in Power BI Service
- Click the Copilot icon in the toolbar
- Describe the report you want to create
- Copilot generates a complete report page
- Refine with follow-up instructions
Example prompts:
- "Create an executive summary page with KPIs for revenue, profit margin, and customer count"
- "Show me a comparison of this year vs last year across all product categories"
- "Build a page focused on regional performance with maps and rankings"
Visual Generation
- "Add a bar chart of top 10 customers by revenue"
- "Create a scatter plot comparing marketing spend to conversions"
- "Show a funnel chart for our sales pipeline stages"
DAX Generation
- "Create a measure for running total of sales"
- "Write a DAX formula for average deal size by quarter"
- "Calculate customer retention rate month over month"
Key Takeaways
- •Copilot creates complete Power BI reports from natural language descriptions
- •Generates visuals, DAX formulas, and narrative summaries automatically
- •Requires Power BI Premium or Fabric capacity with admin enablement
- •Refine generated reports iteratively with follow-up instructions
0 of 4 lessons marked complete
Progress is kept in this browser only.