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
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.
Next story · Science · Oct 1
Microsoft and Google back Apache Ossie's shared format for moving semantic models between platformsConfirmed3 publishers
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
Claim ledger
Ranked by verification strength, evidence, and original report placement.
- [1]
On Tuesday, at its FabCon and SQLCon data conference in Barcelona, Spain, Microsoft outlined the next step for Fabric.
- [2]
Fabric IQ, the context layer inside Fabric, now feeds Microsoft 365 Copilot by default.
- [3]
Power BI will soon be able to turn the same definitions into apps.
- [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.
- [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.
- [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.
- [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."
- [8]
Outside agents can query Fabric IQ over MCP.
- [9]
Ontologies, which add business rules, moved further into preview.
- [10]
Customers that are more advanced on their journey have their own evals for their agent
- [11]
Kesselman said what customers see from their agent evals sometimes isn't what they expected.
- [12]
Kesselman says he met with more than 320 companies last year.
- [13]
Fabric's shortcuts and mirroring, which connect or replicate external sources into OneLake, are free of charge.
- [14]
Netz said storage under management in OneLake is growing 300% year over year.
- [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.
- [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.
- [17]
We're not just solely replicating security rules. We're actually actively enforcing and preserving those roles.
- [18]
dbt's Fusion engine is due in Fabric in the next couple of weeks.
- [19]
At 300% year-over-year growth, OneLake storage under management is four times what it was a year earlier.
- [20]
Of the four Microsoft IQ parts, Fabric IQ is the only one described as holding metric definitions.
Sources
2 independent publishers whose own reporting we read for this story.
- azure.microsoft.comFabCon and SQLCon 2026 in Barcelona: Building the data foundation for Microsoft Copilot and agents
1 article · September 28, 2026
- thenewstack.ioMicrosoft Fabric is where AI agents learn how the business works
1 article · September 30, 2026
Topics and entities
Entities
- Salesforce Data Cloud
- Model Context Protocol
- Microsoft IQ
- Microsoft
- Microsoft Fabric
- OneLake
- Microsoft 365 Copilot
- Snowflake
- dbt
- ClickHouse
- Yitzhak Kesselman
- Google BigQuery