How to Enable Copilot in Power BI Workspace

Thinking about using natural language to build reports and get insights from your data? You’ve come to the right place. Microsoft's Copilot for Power BI promises to do just that, acting as an AI assistant to speed up your analysis. This article provides a frustration-free walkthrough of exactly how to enable Copilot in your Power BI workspace, covering both the admin and user steps you'll need to take.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

First, What Is Copilot for Power BI?

Copilot for Power BI is an AI-powered feature integrated directly into the Power BI ecosystem. Its goal is to act as your data analysis partner, helping you move from raw data to insights much faster. Instead of manually dragging and dropping fields or writing complex DAX (Data Analysis Expressions), you can use simple, conversational language to have Copilot do the heavy lifting.

Here are a few things it can help you with:

• Create report pages automatically: You can ask Copilot to "create a page that shows sales trends by product and region," and it will generate a new report page with relevant visuals.
• Summarize data insights: Copilot can analyze the data in your reports or semantic models (datasets) and give you a narrative summary of key takeaways and trends.
• Suggest DAX measures: While it might not write every complex measure perfectly, you can ask it to "create a DAX measure for year-over-year sales growth," and it will generate the code for you to review and use.

Essentially, it’s designed to lower the technical barrier to data analysis and automate some of the more tedious report-building tasks. But before you can use it, you need to turn it on.

Prerequisites You Must Meet to Enable Copilot

Before you start clicking buttons, it’s important to make sure your Power BI environment is properly configured. If these requirements aren't met, the option to enable Copilot won't even appear, or the Copilot button will be stubbornly greyed out. Let's walk through what you need.

1. Licensing for Power BI and Fabric

Copilot is considered a premium feature. To use it, you must have one of the following:

• A Power BI Pro license and access to a workspace in a Power BI Premium capacity (P1 or higher) or Fabric capacity (F64 or higher).
• A Premium Per User (PPU) license.

A standard Power BI Pro license with a standard shared workspace won't work. The real key here is the capacity your workspace is running on. Without the proper capacity, Copilot processing isn’t possible.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

2. The Right Workspace Capacity

This is the most common hurdle. Your Power BI workspace must be hosted in a specific region where Azure OpenAI is available (like the United States or France), and it must be on a supported capacity tier. As mentioned above, this means your workspace needs to be assigned to either:

• Fabric Capacity: At tier F64 or higher.
• Power BI Premium Capacity: At tier P1 or higher.

If your company hasn't invested in Fabric or a Premium capacity, you won't be able to proceed. Your admin can check this setting, or you can often see it within the Workspace settings menu.

3. Admin Settings in the Fabric Admin Portal

Even with the right license and capacity, Copilot won’t work unless an administrator for your company’s Power BI/Fabric tenant has enabled it. There are specific tenant-wide settings that control access to Copilot and other generative AI features.

This means you might need to coordinate with your IT department or Power BI administrator to get these settings flipped on. We’ll cover exactly which settings they need to change in the section below.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

For Admins: How to Enable Copilot for Your Tenant

If you're the Power BI or Fabric administrator, these steps are for you. You need to enable Copilot at the organizational level before anyone in your company can use it. This is done through the Fabric admin portal.

Step 1: Access the Fabric Admin Portal

Sign in to your Power BI account and navigate to the settings gear icon in the top-right corner. From there, select "Admin portal."

Step 2: Go to Tenant Settings

Once you’re in the Admin portal, find and click on "Tenant settings" in the navigation menu on the left.

Step 3: Locate the Copilot Settings

Scroll down until you find the section titled "Copilot and Azure OpenAI Service (preview)". Expand this section. You'll see a critical toggle: "Copilot and other generative AI features in Microsoft Fabric".

Step 4: Enable the Main Copilot Toggle

Click the toggle to enable this setting. You will have two main options for applying it:

• Apply to The entire organization: Everyone in your company with the right license and workspace access can use Copilot.
• Apply to Specific security groups: This is a better option if you want to roll out Copilot to a pilot group or a specific department first. You can add one or more security groups (e.g., "Marketing Analytics Team") that should have access.

Step 5: Review the Cross-Geography Data Setting

Below the main toggle, you'll see another important setting: "Data sent to Azure OpenAI can be processed outside your tenant's geographic region...".

Microsoft notes that if your Fabric capacity is in a region that doesn't currently host a large language model, your data might be processed in another region (often the US). If your company has strict data residency requirements, this is a critical setting to discuss with your compliance team before enabling.

Once you’ve configured these settings, click "Apply." Be patient, as it can sometimes take 15-30 minutes for tenant-wide settings changes to take effect.

For Users: Activating Copilot in Your Power BI Workspace

Okay, your administrator has given the green light. Now, you need to ensure your specific workspace and datasets are ready for Copilot. The button won't just appear everywhere, it depends on your workspace configurations.

Step 1: Navigate to Your Workspace Settings

Go to the Power BI workspace where you want to build your report. Click on "Workspace settings."

Step 2: Check the Assigned Capacity

In the settings panel, go to the "Premium" or "Fabric Capacity" tab. Here, you'll see if the workspace is assigned a capacity and, if so, which one. You need to verify that it's using a PPU, Premium (P1+), or Fabric (F64+) capacity license. If it's listed as "Pro," Copilot will not be available in this workspace. You’ll need to ask your admin to move the workspace to a suitable capacity.

Step 3: Open a Report and Look for the Copilot Button

Once you've confirmed the settings, head into Power BI Desktop or open a report in the Power BI service. If all the prerequisites are met, you will now see the "Copilot" button on the ribbon in the reporting view. It may be partially greyed out until you select a visual, but its presence means you're good to go!

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Best Practices: Preparing Your Data for Copilot

Just turning on Copilot is only half the battle. To get truly useful and accurate results, you need a clean, well-structured data model. Copilot is built on the same foundation as Power BI's Q&A feature, so a model that works well for Q&A will also work well for Copilot.

• Use clear naming conventions: Name your tables, columns, and measures with simple, business-friendly names. Use Total Sales instead of tblFactSales_sls_amt_usd. Copilot understands natural language better when your data model speaks it too.
• Define synonyms: In your dataset's settings, you can define synonyms for tables and fields. For example, if your users often refer to "customers" but your table is named Dim_Clients, you can add "customer" as a synonym.
• Create relationships: Your data tables must have defined relationships. Copilot needs to understand how facts (like sales) relate to dimensions (like products, dates, and customers) to generate meaningful visuals.
• Categorize your data: In the model view, categorize geographic fields (like city, state, country) and other common types of data. This helps Power BI create the right visuals, like maps.

Troubleshooting: Why is the Copilot Button Still Greyed Out?

It can be frustrating to go through all the steps only to find the Copilot button is still unavailable. Here's a quick checklist to run through if you get stuck:

1. Check your license again: Double-check that you have a PPU license or a Pro license with access to the correct capacity.
2. Confirm the workspace capacity: This is the #1 issue. Go back to "Workspace settings" and verify it’s assigned to an F64+ or P1+ capacity. A "Premium Per User" workspace license tier also works perfectly.
3. Talk to your admin: The tenant-level settings might not be enabled for you. The admin may have forgotten to add your security group or enabled a setting that conflicts with Copilot.
4. Check your region: Copilot requires your Fabric capacity to be in a specific geographic region. If your capacity is in a region where it hasn't rolled out yet, it won't be available.
5. Refresh and wait: Sometimes settings just take a little while to sync. Close your browser or Power BI Desktop, wait a few minutes, and check again.

Final Thoughts

Enabling Copilot in Power BI is a process that touches multiple layers, from organizational tenant rules set by an admin to the specific capacity of an individual workspace. By following the steps for both administrators and end-users, you can unlock this powerful AI assistant and start streamlining your report creation process.

While tools like Power BI are incredibly powerful, they often come with a significant setup and learning curve just to get started. At Graphed, we took a different approach. We designed an AI analyst that connects your data sources with a few clicks and lets you build entire dashboards using simple, natural language from day one. There are no admin portals or capacity settings to configure - just ask for the charts you need, and the insights will follow in seconds, not hours.