How to Access Copilot in Power BI

You’ve probably seen the buzz around Microsoft Copilot in Power BI and are wondering how to get it working for you and your team. Good news: it’s an incredible tool for turning conversational requests into data visualizations. The slightly complicated news? Accessing it isn’t as simple as flipping a single switch. This guide will walk you through exactly what’s required, how to enable it, and what to do if you run into roadblocks along the way.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly Is Copilot for Power BI?

Before we get into the setup, let's quickly cover what Copilot for Power BI actually is. Think of it as a generative AI assistant embedded directly within your Power BI environment. Instead of manually dragging and dropping fields, choosing chart types, and writing complex Data Analysis Expressions (DAX) formulas, you can simply describe what you want in plain English.

For example, you could ask it to:

• "Create a report page showing our total revenue and profit over time by customer segment."
• "Write a DAX measure to calculate the 30-day moving average of user signups."
• "Summarize the key insights from the data on this dashboard."

Copilot handles the heavy lifting of report creation and data analysis, letting you get to insights much faster. It's designed to lower the technical barrier, making data analysis more accessible to everyone on the team, not just the Power BI experts.

First Things First: Check the Prerequisites

Getting Copilot to appear and work involves meeting several requirements at once. If even one of these is missing, you won’t see the feature. Here’s a clear checklist of what you need to have in place.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

1. Microsoft Fabric Capacity

This is the most significant hurdle for many organizations. Copilot is not just a Power BI feature, it’s part of the broader Microsoft Fabric ecosystem. Fabric is an all-in-one analytics platform that brings together different data tools. To use Copilot for Power BI, your organization must have a paid Fabric capacity - specifically an F64 SKU or higher, or an existing Power BI Premium capacity (P1 SKU or higher).

A "Free" or "Power BI Pro" license alone is not enough. Your Power BI workspace must be assigned to one of these higher-tier capacities. This is often a budget and infrastructure decision, so you’ll likely need to speak with your IT department or a budget owner to ensure this is available.

2. Critical Tenant Settings for Your Admin

Even with the right capacity, Copilot won't appear unless a Power BI or Fabric administrator enables it for your entire organization (or at least for your user group). There are two key settings in the Admin Portal that need to be turned on:

• Copilot and other Azure OpenAI features: This is the master switch that allows Fabric to use Azure OpenAI services. If this is off, nothing else will work.
• Copilot for Power BI: There's a specific sub-setting for unleashing Copilot's features within Power BI itself.

Your admin can enable these for the entire organization or specified security groups. If you're running user-level access through security groups, make sure you're in the right one.

3. Data Processing Region Limitations

For now, all of the data processing needed for Copilot must happen in specific geographic regions where Azure OpenAI is available. Your Fabric capacity must be located in one of the regions listed in Microsoft’s official documentation (primarily regions within the United States and France at the time of writing, but this is expanding). If your capacity is housed in a different region, Copilot will not be available even if you meet all other criteria.

4. An Up-to-Date Version of Power BI Desktop

If you plan to use Copilot in the Power BI Desktop application (which is great for report development), you need to be on a recent version. Ideally, you should be using the latest release from the Microsoft Store, as it updates automatically. If your organization manages software updates, ensure they've pushed a version from late 2023 or newer.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

A Step-By-Step Guide to Enabling Copilot

Now that you know the requirements, here’s how to put them into action. This process involves actions from both an administrator and a workspace owner or user.

Step 1: The Admin Checklist

You’ll need to coordinate with your Power BI or Fabric admin to make sure the foundational settings are correct. Send them this short list to check:

1. Log into Power BI Service and navigate to Settings > Admin portal.
2. Under Tenant settings, find the section for "Copilot and other Azure OpenAI features."
3. Ensure the main toggle, "Copilot and other Azure OpenAI features," is Enabled. Your admin might need to certify that your organization understands any applicable usage terms first.
4. Scroll down and find the setting called "Copilot for Power BI" and ensure it is also Enabled for the relevant groups (or the entire organization).

Quick tip: Admin settings can sometimes take up to 15 minutes to apply across the entire tenant. If you don't see changes immediately, grab a coffee and check back a bit later.

Step 2: Assign Your Workspace to the Right Capacity

Once the admin has enabled Copilot at the tenant level, you need to make sure the specific workspace containing your data and reports is running on the correct infrastructure.

1. Navigate to the Power BI workspace you want to use Copilot in.
2. Click on Workspace settings.
3. Switch to the Premium tab.
4. Under License mode, you should select Fabric capacity or Premium per capacity.
5. From the dropdown, select an available capacity that is F64 or higher (e.g., F64, F128) or P1 or higher (e.g., P1, P2). You will not see these options if your organization hasn't purchased them.
6. Click Save.

This workspace is now capable of running Copilot.

Step 3: Dive into Power BI Desktop or Service

With the backend set up, you can finally access Copilot. Open a report in your newly configured workspace either in Power BI Desktop or the Power BI Service.

In the top ribbon, you should now see a Copilot button. Clicking it will open a side panel where you can start making requests. For Copilot to analyze your data, you must have a published data model (known as a semantic model) to work with. If it's a new report, connect to your semantic model first.

Common Problems and Troubleshooting

It's common to miss a step and find that Copilot isn't working as expected. Here are some of the most frequent issues and how to resolve them.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

"The Copilot button is greyed out or I get an error."

This almost always comes down to your workspace or data model.

• Check the workspace capacity: The most common reason. Double-check that your workspace is assigned to an F64+ or P1+ capacity as described in Step 2 above.
• Ensure your data model is compatible: Currently, Copilot works best when your semantic model is in Import, DirectQuery, or Direct Lake mode, and it needs to be published and processed. For visual suggestions, Copilot needs to have read access to your model's metadata.

"My admin swears they enabled it, but I still don’t see it."

This is often a permissions or timing issue.

• Give it time: As mentioned, tenant setting changes can take a little while to propagate through Microsoft's systems.
• Check security groups: If your admin enabled Copilot for a specific security group, confirm that you are actually a member of that group. Sometimes user lists are out of date.

"I can't seem to get any results."

Check the geographic location of your Fabric capacity. If your data tenant sits outside of the currently supported regions for Azure OpenAI workloads, the feature will be blocked until Microsoft expands its infrastructure footprint. This is a hard-and-fast limitation with no current workaround other than migrating your capacity.

Final Thoughts

Accessing Copilot in Power BI involves a few administrative and technical hurdles, primarily tied to having the right Microsoft Fabric capacity and a few tenant-level settings. Once these prerequisites are met and your workspace is correctly configured, you unlock a powerful AI assistant that promises to change how you build reports and analyze data by simply having a conversation.

This broader trend toward natural language and conversational analytics is all about removing the complexity between you and your data. At Graphed, we're building our entire platform around this idea specifically for marketing, sales, and e-commerce teams. Rather than needing to manage complex capacities and tenant settings, we allow you to connect all your data sources - like Google Analytics, Facebook Ads, Salesforce, and Shopify - in a matter of seconds. From there, you just describe the charts, reports, and dashboards you need, and our AI analyst builds them for you in real-time, helping you get from raw data to clear insights without the technical overhead.