Best on a big screen
This deck is built for screens wider than 768 px.
Rotate your device or open it on a laptop.
Tap to close
←→ Navigate   G Grid   F Full screen
010203
Microsoft Most Valuable Professional

FabCon Barcelona 2026:
what we had, what shipped,
what's still missing

dr Estera Kot
dr Estera Kot
Microsoft MVP · Data Platform · Real-Time Analytics & Ontology · former Principal PM on the Microsoft Fabric team
Friday, October 23, 2026Online session
⟦TBC event name and start time⟧
010203
FabCon Europe 2026 · Barcelona

Straight from the keynote. Four of these topics get their own slides today.

Keynote opening, 8:47 a.m.
Keynote opening, 8:47 a.m.
Main hall, 9:57 a.m.
Main hall, 9:57 a.m.
Microsoft IQ
Microsoft IQ · slide 10
Database Hub in Fabric
Database Hub in Fabric · slide 14
Microsoft acquires Osmos
Microsoft acquires Osmos · slide 13
On-Demand Billing and F0
On-Demand Billing and F0 · slide 20
The third European FabCon and the first SQLCon. Arun Ulag, who leads Azure Data at Microsoft, opened the keynote.
010203
FabCon Europe 2026

One question for seven people at Microsoft: you're a data engineer who has never used AI. What now?

“What [matters] even today in the AI world is the experience you bring with you. AI can do the code, but it cannot build the ecosystem you want for your customers.”

Ajith Shetty, Fabric Spark Engineering

“I would use them as an assistant, not as a replacement for me to do the critical thinking.”

Amanjeet Singh, Fabric Customer Advisory Team
010203

Fabric has become a platform for agents.
Have our settings kept up?

010203
4

Four questions and four labels: GA, PREVIEW, ROADMAP, TBC.

01

What we had

Fabric before Barcelona

02

What shipped

New features labeled GA or preview

03

What's still missing

The roadmap, no spin

04

What it means for us

Where to start

What the labels mean
GAgenerally available
PREVIEWpublic preview
ROADMAPannounced, no date
TBCstatus to be confirmed
010203
Part 1 · What we had

Before Barcelona, Copilot and the data agent worked inside Fabric. The answer never left the platform.

LakehouseWarehouseReal-Time IntelligencePower BIData FactoryOneLakeCopilotData agentAI INSIDE THE RING
1

OneLake in the center. The workloads sit around it: Lakehouse, Warehouse, Real-Time Intelligence, Power BI, Data Factory.

2

Copilot and the data agent lived inside the ring. We asked in Fabric, and the answer stayed in Fabric.

010203
Part 1 · What we had

After Barcelona, Fabric also answers questions from outside the platform: from Copilot Chat, MCP clients, and Foundry.

Before

We ask Copilot in a Power BI report

  • The answer stays in Fabric.
  • The data goes to a person looking at the report.
After

Agents query Fabric from the outside

  • Questions come from Microsoft 365 Copilot Chat, MCP clients, and Foundry.
  • The main consumer of the data is now an agent.
Fabric is no longer just the place where we ask questions. It is now a source agents pull answers from.
010203
2
Part 1 · What we had

Two settings are on by default in every tenant. Who here has checked them?

GAMicrosoft 365 Copilot access to Power BI data

The “Fabric data in Microsoft Copilot” setting in the Microsoft 365 admin center, on by default for everyone.

GAThe AI setting on a semantic model

Anyone with read-only access can use Copilot, Copilot Chat, Cowork, the data agent, and MCP tools. On by default.

The setting doesn't carry over to chained models, the ones built on top of this model.

010203
3
Part 2 · What shipped

Barcelona opened three doors for data to leave Fabric and reach agents.

1

Microsoft 365 Copilot Chat and Cowork

A user asks in the chat, and Fabric IQ answers from a semantic model we control.

GA
2

MCP servers

An MCP client queries Fabric IQ. Core MCP creates workspaces and items on the user's behalf.

GATBC
3

Copilot Studio and the OneLake Table Read API

A data agent works as a tool for another agent. An app reads Delta and Iceberg tables over REST, and OneLake security filters the result.

TBCPREVIEW
Each door enforces the user's permissions. The question is who set those permissions.
010203
1
Part 2 · Door 1 of 3

Door 1: Copilot Chat queries a semantic model through Fabric IQ on the user's behalf.

GAFabric IQ in Copilot Chat and Cowork
FabCon keynote: Microsoft IQ

We ask a business question in Copilot Chat, and the answer comes from a semantic model we control. No extra charge for AI tokens.

In practice: queries from the chat still use our capacity. There's just no separate bill for tokens.

Limit: the answer is only as good as the descriptions and synonyms in the model. The “code experience” version goes to the Frontier program first.

010203
2
Part 2 · Door 2 of 3

Door 2: Fabric IQ MCP only reads data. Core MCP can change your tenant: 15 of its 27 tools write changes.

GAFabric IQ MCP

Reads. Six tools, all read-only: search, model schema, DAX query. The answer comes from the data and respects the user's permissions.

TBCCore MCP

Changes. 27 tools, and 15 of them write changes to workspaces, items, and permissions. Sign-in uses OAuth 2.0 with Entra ID, and Fabric logs supported operations in the audit log.

Learn: “Autonomous or misconfigured clients may perform destructive actions.” Safeguards against destructive operations aren't standardized in MCP, and a client can process data outside Fabric's compliance boundaries.

010203
3
Part 2 · Door 3 of 3

Door 3: the data agent as a tool in Copilot Studio, and Delta tables read over REST.

TBCData agents in Copilot Studio
Not recorded: the demo tenant has no Copilot Studio license

A Fabric data agent works as a tool for an agent in Copilot Studio and shows a visualization in its answer.

Keynote: GA. The Learn walkthrough still says preview on October 21, 2026. Topics in data agents are in preview too.

PREVIEWOneLake Table Read API

An app reads a Delta or Iceberg table over REST, and OneLake security filters rows and columns on every request.

In practice: any app that sends an HTTP request with an Entra ID token can read the table. No Spark cluster, no SQL endpoint, no copy of the data. OneLake security permissions are the only guard.

010203
Part 2 · What shipped

Osmos plans the task, runs it on SparkCore, and checks the result. OneLake permissions remain the boundary.

PREVIEWProject Osmos

The agent plans, runs, and validates a data engineering task in Fabric on SparkCore. We start it from GitHub Copilot CLI, Claude Code, or Codex. Tasks persist, so we can come back to them.

Guardrails: a permission boundary, a write pattern, rerun rules, schema evolution. Fabric and OneLake permissions decide what the agent can do.

010203
Part 2 · What shipped

The operations agent only reads data from Monitor hub. Database agents aren't here yet.

PREVIEW

The agent works out why a pipeline run failed, straight from Monitor hub.

Read-only, on behalf of the signed-in user. Needs the Contributor role and workspace monitoring turned on.

ROADMAPDatabase agents
FabCon keynote: Database Hub in Fabric

For SQL and PostgreSQL, in Database Hub and in VS Code. Announced at the keynote, not available yet.

Database Hub itself is in preview too.

010203
Part 2 · What shipped

The new ontology in Fabric IQ: entities from the semantic model, rules in natural language, export to a knowledge graph.

PREVIEWOntology in Fabric IQ

We build the ontology from a semantic model, data in OneLake, and documents. We write rules in natural language. DAX measures come in as metrics. The ontology agent acts on our behalf and respects OneLake security, RLS, OLS, and CLS.

In practice: we export to RDF and Turtle, the W3C standards for knowledge graphs, and we can import from OWL. Another graph tool can open an ontology from Fabric.

The previous ontology version goes away on January 31, 2027, and the new one replaces it. An independent review flagged entities without an identifying key and no automatic health check for the ontology.

010203
Part 2 · What shipped

Power BI: agentic apps coming to preview soon, Copilot for RTI already in preview.

PREVIEWAgentic apps in Power BI Desktop
Meme: One does not simply run Power BI Desktop on a Mac

We describe the app, and Power BI Desktop generates it, previews it, and publishes it. Included with Pro and PPU licenses, up to 1 GB per app, with write-back.

PREVIEWCopilot for Real-Time Intelligence

A Real-Time Dashboard from one sentence, and we manage the eventhouse in natural language.

010203
Part 2 · What shipped

OneLake security: we define roles, RLS, and CLS once, and they also apply through shortcuts.

GAOneLake security

Roles, RLS, and CLS in one place, also through shortcuts. Every lakehouse gets a DefaultReader role. GA announced for the coming weeks, with no specific date.

GAshortcutsPREVIEWdata agentsOutbound access protection

The workspace won't let data out, either through an outbound shortcut or through a data agent.

GAPurview DLP: restrict access

Blocks access for everyone, or just for guests, when it finds sensitive data in a Fabric item.

FabCon keynote, September 29, 2026: GA.
Learn, October 7, 2026: access restriction still in preview.
010203
Part 2 · What shipped

Policies (allow only), catalog Govern, and observability: three admin screens.

PREVIEWPolicies in Fabric

Scope: tenant or capacity. It's an allow list only: the only effect is Allow, and there's no Deny. Conditions: workspace, groups, sensitivity labels, recipient domain, item type.

GAOneLake catalog Govern

One screen for the admin: label coverage, DLP results, tenant settings, recommended actions.

The data refreshes once a day. The view doesn't cover tables inside items.

PREVIEWObservability
The new Monitor hub in Fabric: the Job runs view with run history

The new Monitor hub: run history and success rate for every job. Plus workspace monitoring in an eventhouse and Activator alerts.

Is our tenant ready for an agent that reads data on our behalf?
010203
03
Part 3

What's still missing, and where to start

010203
6
Part 3 · What's missing and where to start

Five announcements with no date and one hard date: the previous ontology goes away on January 31, 2027.

WhatStatus
ROADMAPOn-demand billing and F0 capacitySoon, no pricing yet
ROADMAPDatabase agents for SQL and PostgreSQLSoon
ROADMAPNative support for ontologies and semantic models in IQ sharingOn the roadmap
ROADMAPApache Ossie, a vendor-neutral ontology standard, together with SnowflakeAnnounced
ROADMAPGA date for OneLake securityNot given
ROADMAPPrevious ontology versionRetired January 31, 2027
010203
Part 3 · What's missing and where to start

What to turn on, what to pilot, what to put off. The label decides, not an opinion.

Turn on
  • GAFabric IQ in Microsoft 365 Copilot Chat
  • GAOneLake catalog Govern
  • GAOneLake security, once it's GA
Pilot first
  • PREVIEWOntology on one model
  • PREVIEWOperations agent in Monitor hub
  • PREVIEWPolicies on one capacity
  • GAFabric IQ MCP on one workspace
Put off for now
  • PREVIEWOsmos in production
  • TBCCore MCP for autonomous clients
  • ROADMAPDatabase agents
A pilot covers one workspace, one model, or one capacity, so we can switch it off in one move.
010203
4
Part 3 · What's missing and where to start

Four tenant settings to check, each with a QR code to Learn.

010203
Part 3 · What's missing and where to start

Engineer: test RLS under the data agent. CTO: ask about the agent's identity.

Engineer
CTO
010203

Fabric has become a platform for agents.
Have our settings kept up?

010203

Questions

QR code: https://cloudsonmars.com/careers/
is hiring

Projects: data platforms and lakehouses, data modeling and reporting, AI and automation. Microsoft Fabric, Azure, Databricks, Power BI.

We don't do body leasing. We run projects, and staff augmentation happens very, very rarely.

Microsoft Most Valuable Professional
010203
Appendix · New features in action

Searching the OneLake catalog from code: one query, the whole tenant.

PREVIEWOneLake catalog search API

POST /v1/catalog/search searches by name, description, and workspace name, with a type filter. It returns only what we have permission to see. The search_catalog tool in Core MCP runs the same search.

In practice: an agent first checks whether a model or table already exists, before it builds another copy.

010203
Appendix · New features in action

AI functions in Spark: translation, sentiment, and classification in one line per column.

GAAI functions in a PySpark notebook

ai.translate, ai.analyze_sentiment, and ai.classify on tester comments written in English, Arabic, and French. Built-in Fabric endpoint, no API key.

In practice: we process text where the data lives, with no separate service and no copying.

On Runtime 2.0 you have to name the model explicitly for now. Learn documents this as a temporary workaround.

010203
Appendix · New features in action

Materialized lake views: a medallion architecture in SQL, with quality rules in the view definition.

GAMaterialized lake views

We create the silver and gold layers with CREATE MATERIALIZED LAKE VIEW. Fabric builds the lineage and refreshes views in dependency order. CONSTRAINT … ON MISMATCH DROP rejects bad rows.

In practice: three bad rows from the panel never reached the gold layer. The run report shows Dropped rows: 3.

Views created from PySpark are in preview and only do full refreshes.

010203
Appendix · New features in action

The data agent: a question, SQL on the lakehouse, a one-line answer and a table.

GAFabric data agent

An agent on lh_oud_rd with instructions in English. Both answers match the data: OB-104 Oud Saffron S-7, 68%, 14,353 QAR per kilogram.

In practice: we test the agent with questions we already know the answer to.

With the vaguer question “Which formula beats the reference most often?”, the agent counted winning trials and named the wrong formula. Each formula has only about one trial.

010203
Appendix · New features in action

We see the same Delta tables through the Unity Catalog API and the Iceberg REST Catalog.

GAOneLake table APIs

The onelake.table.fabric.microsoft.com endpoint: Delta through a Unity Catalog compatible API, Iceberg through the Iceberg REST Catalog. A Delta table from the lakehouse shows up as Iceberg format-version 2.

In practice: any engine that speaks Iceberg REST or Unity Catalog sees our tables with no copy and no export.

All slides