Power BI Copilot Has Multiple Modes. Here’s What Each One Does—and How Fabric Data Agents Change the Game.

Copilot in Power BI isn’t “one feature.” It’s a growing set of experiences that show up in different places, behave differently, and—most importantly—solve different problems.

That’s why two people can both say “Copilot didn’t work for me,” and both be right. One might be trying to generate a report page in Desktop. Another might be trying to chat across any model in their tenant. A third might be expecting an agent-like experience that stays grounded in a curated subject area.

In this post, we’ll map the major modes of Power BI Copilot (where it shows up, what it’s best at, and what it’s not), then contrast that with Fabric Data Agents—because Data Agents aren’t a “better Copilot.” They’re a different building block, meant for a different kind of outcome.

The mental model that makes everything click

A simple way to keep the landscape straight:

Power BI Copilot is an experience layer—it helps you buildsummarize, and explore BI content where you already work (reports, apps, Desktop, mobile).

Fabric Data Agents are an asset you build—a reusable conversational Q&A system that can be grounded in Fabric data (OneLake) and related items, and then consumed by others (including from Copilot in Power BI).

If you’re building a strategy for Power BI in Microsoft Fabric, this distinction matters. Copilot is how users interact. Data Agents are how you package “what we mean” and “where to look” into something repeatable and governable.

Before the fun part: what actually gates Copilot

Most “Copilot didn’t show up” issues aren’t user error—they’re environment reality.

At a high level, Copilot for Power BI requires tenant enablement and capacity support, and Microsoft calls out F2 capacity or above as a baseline requirement in the Copilot overview.

If you’re using Fabric Copilot capacity, Microsoft notes it must be at least F2 or P1, and it’s supported only in the Fabric tenant’s home region.

This isn’t the “exciting” part, but it shapes adoption. Copilot is not just a client-side toggle; it’s a governed capability.

The modes of Power BI Copilot

Report Copilot: “Build me a report page”

This is the mode most people imagine first: prompt → visuals → a usable page.

Microsoft describes Copilot in Power BI as enabling you to create and edit report pages using natural language prompts, generating professional visualizations without manual configuration.

And this experience has been moving quickly. In the November 2025 update, Microsoft called out an upgraded Report Copilot with better visual recommendations, expanded visual library, and improved context awareness—available in both Power BI service and Desktop.

What this mode is for:

  • Fast first drafts of pages and layouts
  • Exploring a model’s “shape” through suggested content
  • Shortening the time from semantic model → stakeholder-ready canvas

What it is not:

  • A replacement for semantic model design (relationships, naming, measures)
  • A guarantee of business meaning without business definitions (more on that when we talk about AI instructions)

Copilot summaries: “Tell me what matters in this report”

Summarization is its own mode, and it shows up both in-report and in the standalone experience.

Microsoft’s summary documentation is unusually explicit about the value proposition: Copilot summaries generate a concise summary in seconds, in either the report or the standalone experience, highlighting trends, insights, and potential issues.

A detail worth emphasizing: Microsoft states Copilot uses visual metadata from the report to generate natural language summaries, and that citations in the output can point back to which visuals were used. That’s a quiet but important governance feature—traceability is part of the experience, not an afterthought.

This is the mode that’s easiest to roll out to business users because it doesn’t ask them to become report designers—it asks them to become better question askers.

The narrative visual with Copilot: “Write the story onto the canvas”

This is a specialized mode: rather than chatting in a pane, Copilot produces a narrative artifact inside the report.

Microsoft notes the narrative visual pulls information from what’s on the report canvas, which makes naming and clarity of visuals/axes matter—because the narrative is summarizing what’s actually shown.

Practically: if your organization already standardizes report layouts and naming conventions, this mode benefits disproportionately. If report quality is inconsistent, the narrative will reflect that inconsistency.

Standalone Copilot: “Chat across anything I have access to”

This is where Power BI Copilot starts acting less like a report feature and more like an analytics entry point.

Microsoft describes a full-screen, standalone Copilot experience that finds and answers questions about any report, semantic model, and Fabric data agent a user has access to—and explicitly contrasts it with the Copilot pane, which only answers questions about the report you currently have open.

Two implications:

  • Scope becomes a feature. You’re no longer starting from “which report do I open?” You’re starting from “what do I need to know?”
  • Curation becomes visible. If users have access to dozens of similar models, standalone Copilot can surface the wrong one unless your semantic layer is disciplined (or unless you steer it with a Data Agent—more on that soon).

Microsoft also published that this standalone experience is available (in preview) in Power BI mobile apps.

Copilot in Power BI apps: report-scoped vs app-scoped

Apps introduce another “mode split,” and it’s a useful one.

Microsoft says Copilot is available in apps in two ways:

  • Report-scoped Copilot (summaries and Q&A for the report in view)
  • App-scoped Copilot (preview) (find items in the app, summarize an item, or answer questions across items in the app)

This matters because apps are often the unit of distribution for a business domain (Sales, Finance, Operations). App-scoped Copilot is effectively a “domain chat” experience—without requiring users to know which report is the canonical one.

Copilot on mobile: cross-item chat vs in-report help

On mobile, Microsoft draws a bright line between:

  • the standalone Copilot experience (query any report/model/data agent without opening a specific item)
  • and the in-report Copilot button (summaries and insights for the report you’re viewing)

For adoption, this is the “moment of truth” for your semantic layer. Mobile users don’t tolerate long navigation flows. If Copilot can’t quickly find the right model and return something coherent, users will abandon it.

Copilot for model work: DAX Query View and measure documentation

If your audience is primarily developers and semantic model owners, this is where Copilot becomes genuinely day-to-day useful.

Write DAX queries with Copilot: Microsoft documents Copilot in DAX Query View as supporting natural language to DAX query generation, DAX-to-natural-language explanation, and general help understanding DAX concepts.

Measure descriptions with Copilot: Microsoft also documents Copilot generating measure descriptions based on the DAX formula, positioning this as model documentation that helps report authors understand which measures to use.

And there’s a bigger point hiding in the official “get started” tutorial: authoring AI instructions and AI data schema is available only in Power BI Desktop, while consumption is available everywhere Copilot exists.

That’s a subtle product signal: Microsoft is treating “teaching Copilot what your business means” as a modeling responsibility, not a consumer responsibility.

Fabric Data Agents: what they are (and why they’re not just “Copilot but better”)

A Fabric data agent is a feature that lets you build your own conversational Q&A systems using generative AI, so teams can ask plain-English questions about data stored in Fabric OneLake and get relevant answers.

Data agents are conversational experiences that can answer questions about data stored in lakehouses, warehouses, Power BI semantic models, KQL databases, and ontologies in Fabric—again emphasizing plain-English access for colleagues who aren’t deep experts.

The key shift:

Copilot (in Power BI) is about accelerating the BI workflow.
A Data Agent is about packaging a governed conversational interface to a subject area.

Where they meet: using Fabric Data Agents from Copilot in Power BI

There’s also a direct integration: you can consume a Fabric Data Agent from Copilot in Power BI in two ways:

  • let Copilot search and suggest relevant items (semantic models, reports, data agents)
  • or manually add a specific Data Agent to the Copilot session

There’s also an interaction flow where Copilot sends the question to the selected data agent, and the agent identifies the most relevant data source to query. Importantly, Microsoft calls out enforcement of Row-Level Security (RLS) and Column-Level Security (CLS) based on user permissions when retrieving answers.

This is the practical reason Data Agents matter: they can act like “curated grounding” inside an otherwise broad, cross-item Copilot experience.

Copilot vs Data Agents: the clearest contrast

DimensionPower BI CopilotFabric Data Agents
What it isA set of Copilot experiences embedded across Power BI surfacesA created, reusable conversational Q&A system grounded in Fabric data
Typical outputReport pages, visuals, summaries, narrative artifacts, Q&A responsesQ&A responses grounded in chosen data sources (subject-area chat)
Scope controlVaries by mode: report-scoped pane vs cross-item standaloneDefined by the agent’s configured grounding (what it can “talk to”)
OwnershipUsually “any enabled user,” with best results from strong modelsTypically built/owned by data teams or domain owners as a shared asset
Best fitSpeeding up authoring and accelerating explorationProviding consistent, governed answers in a domain without report hunting
How they work togetherCopilot can discover and invoke data agents, or you can attach one to the sessionData agent can serve as a grounding target when Copilot needs domain context

Three practical patterns that work in real teams

The goal isn’t to pick one. The goal is to place each capability where it reduces friction without weakening trust.

Pattern: Copilot for building, Data Agent for answering
Use Report Copilot to accelerate draft pages and layouts, then rely on a Data Agent for “what does this metric mean?” and “what changed?” style questions that need consistent grounding.

Pattern: Standalone Copilot for discovery, Data Agent for focus
Standalone Copilot is powerful precisely because it’s cross-item. But cross-item can become “cross-wired.” Attach a Data Agent when you want the conversation to stay anchored to a domain and its curated sources.

Pattern: Model-first Copilot (the unglamorous multiplier)
If you want Copilot to feel credible, invest in the semantic model: relationships, naming, measure descriptions, and (where appropriate) AI instructions and schema. You’re not “tuning an LLM.” You’re reducing ambiguity in the layer Copilot depends on.

Closing: what we learned (and what to do next)

Power BI Copilot is best understood as a family of modes: report creation, report summarization, narrative generation, cross-item chat, app-scoped help, mobile experiences, and model-focused assistance like DAX query generation and measure documentation. Those modes matter because each one has a different scope boundary—and scope is where trust is either built or broken.

Fabric Data Agents are different: they’re not “another Copilot button.” They’re a buildable, reusable conversational system designed to make domain Q&A consistent, accessible, and grounded in Fabric data—while still fitting naturally into Copilot in Power BI when you want that agent-like focus.

If you’re charting an AI path for analytics, the opportunity isn’t to sprinkle Copilot everywhere. It’s to intentionally pair Copilot experiences with the right semantic foundations—and bring in Data Agents where you need repeatable, governed answers.

Unknown's avatar

Author: Jason Miles

A solution-focused developer, engineer, and data specialist focusing on diverse industries. He has led data products and citizen data initiatives for almost twenty years and is an expert in enabling organizations to turn data into insight, and then into action. He holds MS in Analytics from Texas A&M, DAMA CDMP Master, and INFORMS CAP-Expert credentials.

Discover more from EduDataSci - Educating the world about data and leadership

Subscribe now to keep reading and get access to the full archive.

Continue reading