Skip to content

Build Independently confirmed2 publishers 2 min read Published Updated

Microsoft 365 Copilot now draws business context from Fabric IQ by default

Microsoft made Fabric IQ the default business context for Microsoft 365 Copilot at FabCon Barcelona and opened it to outside agents over MCP. The metric definitions teams keep in Power BI semantic models now shape what those agents answer.

The Engineer · Build desk

Send a correction

What happened

  • Power BI will soon be able to turn the same Fabric IQ definitions into apps, Microsoft said at FabCon and SQLCon.
  • Ontologies, the Fabric IQ component that adds business rules to the data, moved further into preview.
  • Mirrored security roles, due in public preview in the coming weeks, carry Snowflake access roles into Fabric with the same members and table permissions.
  • Microsoft announced a two-way Salesforce Data Cloud 360 integration, general availability of BigQuery mirroring, and a ClickHouse workload that runs directly against OneLake.
  • Fabric CTO Amir Netz said storage under management in OneLake is growing 300% year over year.

Why it matters

  • What it costs cost Owners of Power BI semantic models now carry part of agent behaviour, since a wrong measure reaches Copilot's answers as well as the report it was built for.
  • Who's exposed exposure Fabric permissions now set the limit on what third-party agents can see, because those agents query over MCP the same layer Copilot reads.
  • What it limits constraint Teams mirroring from Snowflake get Copilot reading Fabric IQ weeks before Snowflake's own access roles can follow their data into Fabric.

Arun Ulag, Microsoft's executive vice president for Azure Data, wrote in his announcement post that Fabric IQ combines "unified data from OneLake, trusted metrics from Power BI semantic models, and operational context from ontologies and real-time intelligence" [7]. It is one of four parts of what Microsoft calls Microsoft IQ. Work IQ covers email, Teams and SharePoint, Foundry IQ covers documents and manuals, and Web IQ covers the public internet [6]. Of the four, only Fabric IQ holds metric definitions [20].

I think the design is right. Each metric is defined once in Fabric and read from there by Copilot, by outside agents over MCP and, soon, by apps Power BI builds from the same definitions [2][8][3]. One definition in one place is easier to audit and fix than a copy maintained per agent.

"Agents are a very, very strange animal, and I always like to say it's like Drew Barrymore from 50 First Dates. Every time they open their eyes, they forget everything that happened before," Amir Netz, Fabric's CTO, said in a press briefing after the keynote [4]. As keynote metaphors go, it is an accurate description of a stateless process. Ulag said coding agents work because they have "the code, the repos, the change history, the specs, the tests," and argued that most enterprises have nothing comparable outside coding [5].

Ulag's list ends with tests. Yitzhak Kesselman, the corporate vice president who runs Fabric IQ, described evals as something advanced customers build for themselves. "Customers that are more advanced on their journey have their own evals for their agent," he told The New Stack [10]. What those evals show sometimes isn't what customers expected, he said [11]. He met with more than 320 companies last year [12].

The account from Barcelona does not say whether an administrator can switch the Copilot default off, or which identity an outside agent's MCP query runs under [2][8]. For tables mirrored from Snowflake, keeping the source's access roles depends on mirrored security roles, which are still weeks from public preview [16]. "We're not just solely replicating security rules. We're actually actively enforcing and preserving those roles," said Shireen Bahadur, who demonstrated the feature in the keynote [17].

Microsoft does not charge for shortcuts and mirroring, the features that connect or replicate external sources into OneLake [13]. At the 300% annual growth Netz cited, OneLake now manages four times the storage it did a year earlier [19]. The dbt Fusion engine is due in Fabric in the next couple of weeks [18].

What to watch

  • Microsoft documentation on whether admins can disable the Fabric IQ default in Microsoft 365 Copilot, and which identity outside agents' MCP queries run under.
  • Mirrored security roles reaching public preview, and whether Snowflake-derived permissions apply to MCP queries from outside agents.
  • Ontologies leaving preview, and the first Power BI apps built from Fabric IQ definitions.

Clarity's read

What the record supports and how the coverage leans. The claims behind it follow.

Reality

Evidence60
Adoption35
Hype gap+20
Incentives80
Confidence60
Why these scores

Claim ledger

Ranked by verification strength, evidence, and original report placement.

  1. [1]

    On Tuesday, at its FabCon and SQLCon data conference in Barcelona, Spain, Microsoft outlined the next step for Fabric.

    Reported Supported Source: The New StackView cited source
  2. [2]

    Fabric IQ, the context layer inside Fabric, now feeds Microsoft 365 Copilot by default.

    Reported Supported Source: The New Stack, reporting Microsoft's FabCon announcementsView cited source
  3. [3]

    Power BI will soon be able to turn the same definitions into apps.

    Reported Supported Source: The New StackView cited source
  4. [4]

    Agents are a very, very strange animal, and I always like to say it's like Drew Barrymore from 50 First Dates. Every time they open their eyes, they forget everything that happened before.

    Reported Supported Source: Amir Netz, Microsoft Fabric CTO, in a press briefing after the keynoteView cited source
  5. [5]

    Arun Ulag said in the keynote that coding agents work because they have "the code, the repos, the change history, the specs, the tests," and argued that outside of coding most enterprises have nothing comparable.

    Reported Supported Source: Arun Ulag, Microsoft EVP for Azure Data, keynoteView cited source
  6. [6]

    Fabric IQ is one of four pieces of Microsoft IQ. Work IQ covers email, Teams and SharePoint; Foundry IQ covers documents and manuals; Web IQ covers the public internet.

    Reported Supported Source: The New StackView cited source
  7. [7]

    Ulag's announcement blog post describes Fabric IQ as combining "unified data from OneLake, trusted metrics from Power BI semantic models, and operational context from ontologies and real-time intelligence."

    Reported Supported Source: Arun Ulag's announcement blog post, as quoted by The New StackView cited source
  8. [8]

    Outside agents can query Fabric IQ over MCP.

    Reported Supported Source: The New Stack, reporting Microsoft's FabCon announcementsView cited source
  9. [9]

    Ontologies, which add business rules, moved further into preview.

    Reported Supported Source: The New StackView cited source
  10. [10]

    Customers that are more advanced on their journey have their own evals for their agent

    Reported Supported Source: Yitzhak Kesselman, corporate vice president who runs Fabric IQ, to The New StackView cited source
  11. [11]

    Kesselman said what customers see from their agent evals sometimes isn't what they expected.

    Reported Supported Source: Yitzhak Kesselman, to The New StackView cited source
  12. [12]

    Kesselman says he met with more than 320 companies last year.

    Reported Supported Source: Yitzhak Kesselman, to The New StackView cited source
  13. [13]

    Fabric's shortcuts and mirroring, which connect or replicate external sources into OneLake, are free of charge.

    Reported Supported Source: The New StackView cited source
  14. [14]

    Netz said storage under management in OneLake is growing 300% year over year.

    Reported Supported Source: Amir Netz, Microsoft Fabric CTOView cited source
  15. [15]

    Microsoft announced a two-way integration with Salesforce Data Cloud 360, mirroring from Google BigQuery in general availability, and a ClickHouse workload that runs that engine directly against OneLake.

    Reported Supported Source: The New StackView cited source
  16. [16]

    Mirrored security roles, which reach public preview in the coming weeks, bring permissions along with the data; access roles defined in Snowflake will show up in Fabric with the same members and the same table permissions.

    Reported Supported Source: The New StackView cited source
  17. [17]

    We're not just solely replicating security rules. We're actually actively enforcing and preserving those roles.

    Reported Supported Source: Shireen Bahadur, Microsoft, who demonstrated the feature in the keynoteView cited source
  18. [18]

    dbt's Fusion engine is due in Fabric in the next couple of weeks.

    Reported Supported Source: The New StackView cited source
  19. [19]

    At 300% year-over-year growth, OneLake storage under management is four times what it was a year earlier.

    Derived Supported
  20. [20]

    Of the four Microsoft IQ parts, Fabric IQ is the only one described as holding metric definitions.

    Derived Supported

Sources

2 independent publishers whose own reporting we read for this story.

  1. azure.microsoft.com

    1 article · September 28, 2026

    FabCon and SQLCon 2026 in Barcelona: Building the data foundation for Microsoft Copilot and agents
  2. thenewstack.io

    1 article · September 30, 2026

    Microsoft Fabric is where AI agents learn how the business works

Topics and entities