Skip to content
DisrupsoftDisrupsoft
Strategy & ROI

Researcher and Analyst Copilot agents: when to use each

Researcher and Analyst Copilot agents: what each one does in Microsoft 365 Copilot, which license they need, their limits and what IT should review first.

Researcher and Analyst Copilot agents: when to use each

It's Thursday, and the sales manager wants a report by Monday on how competitors moved this year, cross-checked against what the largest customers have been saying by email. Meanwhile, finance has to explain why margin dropped in three regions, using four spreadsheets nobody has consolidated. These are two different jobs, and Microsoft 365 Copilot has an agent built for each one.

The Researcher and Analyst Copilot agents are the two reasoning agents Microsoft includes with Microsoft 365 Copilot. The names sound alike and both take their time to answer, but they solve different problems: Researcher investigates and writes a sourced report; Analyst works on your data and does the math. Mix them up and you end up asking one for what the other does better, then deciding that "AI doesn't work." Below we cover what each one does, what license it needs, what IT can control and where each falls short.

Researcher: research with cited sources

Researcher is built for complex questions that take several steps. According to Microsoft Learn, it combines web information with your work content (files, emails, meetings and chats you already have access to) and delivers a structured report with sections, visuals and citations for every source.

Under the hood it uses Microsoft Graph, your organization's connectors and the Bing index for the web part, per the Researcher FAQ. It often asks clarifying questions before it starts. Answer them carefully, because that's where you set the scope of the report.

The big difference from regular Copilot chat is time. Microsoft says a simple query takes under five minutes and a complex one can take 10 to 45. It's the wrong tool for answering an email. It works well for things like:

  • a market or competitor report that mixes public news with what's already been discussed internally;
  • prep for a customer meeting, pulling together the email history, meeting notes and what's been published about the company;
  • a project status summary built from Teams chats, meetings and the team's documents;
  • a regulatory or vendor review, with every claim linked to its source so someone can check it later.

The current version lets you choose the model from a picker inside the agent. Microsoft even documents how to enable Anthropic models (Claude) as a subprocessor, a decision IT should review before switching it on.

Analyst: turning your data into answers

Analyst does the job of a data analyst. You attach one or more files (Excel workbooks, CSVs and other sources), from your device or OneDrive, and ask in plain language. According to Microsoft Support, it calculates statistics, finds trends and outliers, and returns a report with tables and charts.

To do that it writes and runs Python, and you can watch the code as it runs, as Microsoft explained when it introduced both agents. For us this is the most useful part: if a number looks off, you check the calculation instead of trusting it blindly.

Some jobs where it does well:

  • comparing sales by region and quarter across several unconsolidated spreadsheets;
  • finding the products or customers behind a margin drop;
  • cleaning and joining exports from different systems (ERP, CRM, manual spreadsheets);
  • building the base for a management report you'll finish in Excel or PowerPoint.

If your team already uses Copilot in Excel, Analyst doesn't replace it. Copilot in Excel works inside one workbook; Analyst helps when the question spans several files. We covered this in From basic Excel to data analyst with Copilot.

Which one to use: a quick table

If you need...Use
A report combining web and internal documents, with cited sourcesResearcher
Prep for a meeting or a background documentResearcher
Calculations, trends or comparisons on spreadsheetsAnalyst
Consolidating data from several filesAnalyst
Building a new spreadsheetAnalyst (Researcher's own FAQ points to it for Excel tasks)
A quick answer, a short summary or an email draftRegular Copilot chat

Some jobs need both. In the falling-margin case, Analyst finds the three regions and the products responsible, and Researcher looks for competitor price changes or industry news that might explain it.

Licensing and limits

Both agents are included in the Microsoft 365 Copilot license at no extra cost. People who only use Copilot Chat without that license don't get them: Microsoft's official comparison says that without a license agent access is limited and excludes advanced agents such as Researcher and Analyst. If you're deciding which users to license, we explain it in Microsoft Copilot for business: licensing and how to start.

Researcher has a cap: 25 queries per user per month, according to its FAQ. That's plenty for real research, but it runs out fast if someone uses it like a search engine. Say so during training.

A few other limits worth knowing before you promise results:

  • Researcher can't process images inside the documents it receives.
  • It can't be customized or extended with Copilot Studio. It's a Microsoft agent with fixed logic; if you need one with your own instructions and sources, you have to build it separately.
  • Reports can take a while. A user expecting an answer in ten seconds will assume it froze.

What IT needs to review

Both agents work within the permissions each user already has. Researcher follows data loss prevention (DLP) policies and isn't trained on your organization's data, according to Microsoft. That's good, but it has a direct consequence: if a payroll folder is shared with the whole company by mistake, Researcher can cite it in a report. The bad permission was already there; the agent just makes it obvious.

Also check these control points:

  1. Web search is governed by a single tenant-level toggle. You can't block or allow specific sites: either Researcher uses the web through Bing, or it doesn't.
  2. Admins can block Researcher and Analyst from the Microsoft 365 admin center, for example during a pilot.
  3. There's currently no usage report specific to these agents, so measuring adoption needs another method, such as surveys or tracking use cases.
  4. By default, the content of Researcher sessions isn't available to admins or compliance tools. Keep that in mind if your legal team expects to review it.

If those reports will touch personal data about customers or employees, check this against your obligations under Chile's Law 21.719 before opening access to the whole company.

Frequently asked questions

Do I need an extra license to use Researcher and Analyst?

No. They're included in Microsoft 365 Copilot. What isn't enough is Copilot Chat without a license, which doesn't give access to these agents.

How many queries can I run with Researcher?

Microsoft sets a maximum of 25 queries per user per month. Save it for research that really needs several sources.

Can Analyst get the math wrong?

It can, like any analysis. The upside is that it shows the Python code it runs, so you can check how it reached each number before you present it.

Put both agents to work

At Disrupsoft we identify the Copilot scenarios with the most impact for your company, activate and configure it in your Microsoft 365, and train your teams with real cases, including when to use Researcher, when to use Analyst and when plain chat is enough. If you want your Copilot license to do more than search, let's talk about Copilot and Microsoft 365.

CopilotAgentes De AIMicrosoft 365LicenciasGobierno De AI

← View more articles