AI Model Wiki

    Skip to main content
    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

    1. Open a new report in Power BI Service
    2. Click the Copilot icon in the toolbar
    3. Describe the report you want to create
    4. Copilot generates a complete report page
    5. 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.