How to Set Up Power BI Copilot for AI Reports

What Power BI Copilot Does

Power BI Copilot is Microsoft's generative AI layer built on top of Azure OpenAI and embedded directly into the Power BI authoring experience. It lets analysts type natural language prompts to generate report pages, create DAX measures, build narratives, and surface data insights without writing formulas or clicking through menus manually.

Since its general availability in late 2024, Microsoft has steadily expanded what Copilot can do inside Power BI. As of early 2026, the prompt input limit has grown from 500 characters to 10,000 characters across all Copilot surfaces, including the standalone pane, report view, embedded apps, and mobile. That increase matters for analysts working with complex datasets who need to describe multi-step analysis requests in a single prompt.

According to Microsoft's own documentation, Copilot is now enabled by default on all Fabric-licensed tenants. But "enabled by default" does not mean "ready to use." There are licensing, capacity, and admin portal steps that must be completed first. This guide walks through each one.

Step 1: Check Your Licensing

Power BI Copilot requires one of the following:

A Microsoft Fabric capacity at F64 or higher. Fabric capacity is billed by the hour and consolidates compute for Power BI, Data Factory, Synapse, and other Fabric workloads into a single pool. F64 is the minimum tier where Copilot features are available.

A Power BI Premium Per User (PPU) license at $20 per user per month. PPU gives individual users access to premium features, including Copilot, without requiring the organization to purchase a full Fabric capacity. For small teams and solo analysts, this is often the more practical path.

A Fabric trial. Microsoft offers a 60-day free trial of Fabric capacity that includes Copilot access. This is the fastest way to test the feature without committing budget.

If your organization is on a standard Power BI Pro license ($10 per user per month), Copilot is not available. You would need to upgrade to PPU or provision Fabric capacity.

Step 2: Enable Copilot in the Admin Portal

Even with the right license, a Fabric administrator must confirm that the Copilot tenant setting is turned on. Here is how to check and enable it:

Open the Power BI admin portal at app.powerbi.com. Click the gear icon in the top right, then select Admin portal. In the left sidebar, click Tenant settings. Scroll to the section labeled "Copilot and Azure OpenAI Service." You will see a toggle for "Users can use Copilot and other features powered by Azure OpenAI." Toggle it on.

You can apply this setting to the entire organization or restrict it to specific security groups. If you are running a pilot with a small team, restricting to a security group lets you control who has access during the evaluation period.

Changes to tenant settings can take up to 15 minutes to propagate across the service. After enabling, ask users to sign out and back in to Power BI before testing.

Step 3: Enable Copilot in Power BI Desktop

Copilot in Power BI Desktop requires a separate check. Open Power BI Desktop and go to File, then Options and settings, then Options. Under the Preview features section, make sure "Fabric Copilot" is checked. Click OK and restart the application.

Once restarted, you will see a Copilot button in the Home ribbon. Clicking it opens the Copilot pane on the right side of the canvas, where you can type natural language prompts to generate report pages or ask questions about your data model.

For Desktop to connect to Copilot, your workspace must be assigned to a Fabric capacity or PPU. If your workspace is on shared (free) capacity, the Copilot button will appear grayed out. To fix this, go to the Power BI service, open Workspace settings, and under License info, assign the workspace to a Premium or Fabric capacity.

Step 4: Use Copilot to Generate Your First Report

With everything enabled, connect to a dataset and try a basic prompt. For example, if you have a sales dataset loaded, type "Create a report page showing monthly revenue trends by region with a bar chart and a summary card for total revenue."

Copilot will generate a draft report page with visuals, titles, and formatting. You can then refine it with follow-up prompts like "Add a slicer for product category" or "Change the bar chart to a line chart."

Beyond report generation, Copilot handles several other tasks. You can ask it to write DAX measures ("Create a measure that calculates year-over-year revenue growth"), explain existing formulas ("What does this DAX measure do?"), generate narrative summaries of a report page, or suggest additional visuals based on the data model.

The 10,000-character prompt limit means you can now describe detailed, multi-step analyses in a single request. For example, you could ask Copilot to "Create a page with three visuals: a line chart of monthly revenue for the last 24 months filtered to the North America region, a table showing the top 10 products by margin, and a KPI card comparing this quarter's revenue to the same quarter last year."

Step 5: Set Up Copilot Capacity Controls

For organizations with multiple teams using Copilot, Microsoft introduced Fabric Copilot capacity in February 2026. This feature consolidates all Copilot usage across Power BI Desktop, Pro workspaces, and PPU workspaces into a single designated Fabric capacity.

To configure this, go to the Fabric admin portal, navigate to Capacity settings, and assign a specific capacity for Copilot workloads. This prevents Copilot usage from consuming compute resources allocated to other Fabric workloads like data pipelines or lakehouses.

This setting is enabled by default on tenants provisioned after February 8, 2026. If your tenant predates that, you may need to manually assign the Copilot capacity.

Common Setup Issues

The most frequent problem is the grayed-out Copilot button. This almost always means the workspace is not assigned to a Fabric or Premium capacity. Check workspace settings in the Power BI service.

If Copilot is enabled but returns generic or unhelpful responses, the issue is usually the data model. Copilot works best with well-structured star schema models that have clear table names, descriptive column names, and defined relationships. Renaming columns from "Col_1" to "Monthly Revenue" significantly improves output quality.

Users outside the United States, United Kingdom, France, or Australia may experience higher latency or limited availability. Microsoft is expanding Copilot's geographic coverage, but as of April 2026, performance varies by region.

Practical Summary

Setting up Power BI Copilot takes about 15 minutes if you have the right license in place. The steps are: confirm Fabric or PPU licensing, enable the tenant setting in the admin portal, activate the preview feature in Desktop, and assign your workspace to a premium capacity. Once those four boxes are checked, Copilot is ready to generate reports, write DAX, and summarize data from natural language prompts. If you prefer to skip the setup entirely and work with data using plain English from a file upload, platforms like VSLZ AI handle the full pipeline from raw data to charts and statistical analysis without requiring any BI tool configuration.