FabCon Europe 2026 in Barcelona: what shipped in Microsoft Fabric, and what's still preview
FabCon and SQLCon Europe 2026 ran from September 28 to October 1, 2026, in Barcelona. The keynote on September 29 turned Microsoft Fabric into a platform for agents: Microsoft 365 Copilot Chat, MCP clients, Copilot Studio, and apps can now pull answers from Fabric data. This recap labels every announcement GA, PREVIEW, ROADMAP, or TBC, checked against Microsoft Learn on October 21, 2026. It comes with slides in English, Polish, and German, PDFs, 20 recordings from a demo tenant with synthetic data, and a script that rebuilds the demos in your own tenant.
Open the English slides Polski · Deutsch · PDF · GitHub
Use this recap to
- Check a status before you plan on a feature: 22 announcements labeled GA, PREVIEW, ROADMAP, or TBC, each with a Microsoft source.
- Give the talk yourself with 30 slides in English, Polish, and German, PDFs, and recordings, all under CC BY 4.0.
- Run the demos in your own tenant: one command builds the environment for all 18, and each demo has a runbook.
Key takeaways from FabCon Europe 2026
- Fabric data now leaves Fabric through three doors: Copilot Chat and Cowork, MCP servers, and Copilot Studio plus the OneLake Table Read API. Each door enforces the user's permissions, so the real question is who set them.
- Two settings are on by default in every tenant: "Fabric data in Microsoft Copilot" in the Microsoft 365 admin center, and the AI setting on every semantic model.
- Much of what was announced is preview. Turn on what is GA, pilot what is preview on one workspace, model, or capacity, and put the rest off.
Slides, PDF, and recordings in three languages
Each language has the full 30-slide deck as HTML, a PDF, and its own takes of the demos with typed text, so prompts and agent answers match the language.
| Language | Slides | Where it was presented | |
|---|---|---|---|
| English | Open slides | Online session, October 23, 2026 | |
| Polski | Open slides | Data Community Trójmiasto, meetup #34, Gdynia, October 21, 2026 | |
| Deutsch | Open slides | Online-Session, 23. Oktober 2026 |
Status of every FabCon Europe 2026 announcement
GA means generally available, PREVIEW means public preview, ROADMAP means announced with no date, and TBC means sources disagree or Learn shows no label. Checked against Microsoft Learn on October 21, 2026. Statuses change fast, so check the source before you rely on one.
Spot a status that changed? Send a status update with the source link. Confirmed changes go into the table with a new check date.
| ID | Feature | Status | What it means |
|---|---|---|---|
| S1 | Fabric IQ in Microsoft 365 Copilot Chat and Cowork | GA | Business questions answered from a semantic model you control. No extra charge for AI tokens, queries still use your capacity. Source |
| S2 | Fabric IQ MCP server | GA | Read-only MCP server for Power BI reports and semantic models: search, metadata, and DAX queries under the signed-in user's permissions. Source |
| S3 | Fabric Core MCP server | TBC | Fabric REST operations as MCP tools. 27 tools, 15 of them write changes to workspaces, items, and permissions. Learn shows no status label. Source |
| S4 | Data agents in Copilot Studio | TBC | A Fabric data agent as a tool for a Copilot Studio agent. Keynote: GA. The Learn walkthrough still says preview on October 21, 2026. Source |
| S5 | OneLake Table Read API | PREVIEW | Apps read Delta and Iceberg tables over REST. OneLake security filters rows and columns on every request. Source |
| S6 | Project Osmos, the data engineering agent | PREVIEW | Plans, runs, and validates data engineering tasks on SparkCore. Tasks persist. Fabric and OneLake permissions remain the boundary. Source |
| S7 | Operations agent in Monitor hub | PREVIEW | Read-only investigation of failed pipeline runs, as the signed-in user. Needs the Contributor role and workspace monitoring. Source |
| S8 | Database agents for SQL and PostgreSQL | ROADMAP | Announced at the keynote for Database Hub and VS Code, not available yet. Database Hub itself is in preview. Source |
| S9 | Ontology in Fabric IQ | PREVIEW | Built from semantic models, OneLake data, and documents. Rules in natural language, RDF and Turtle export. The previous ontology retires January 31, 2027. Source |
| S10 | Agentic apps in Power BI Desktop | PREVIEW | Preview announced for the coming weeks. Included with Pro and PPU, up to 1 GB per app, with write-back. Source |
| S11 | Copilot for Real-Time Intelligence | PREVIEW | A Real-Time Dashboard generated from one sentence on an eventhouse. The product shows a Preview label. Source |
| S12 | OneLake security | GA | Roles, RLS, and CLS defined once and enforced across engines, also through shortcuts. GA announced for the coming weeks, with no date yet. Source |
| S13 | Outbound access protection | GAPREVIEW | A workspace that blocks data from leaving. GA for OneLake shortcuts, preview for data agents. Source |
| S14 | Purview DLP restrict access | GA | Blocks everyone, or only guests, when sensitive data is found in a Fabric item. GA per the keynote, Learn still showed preview on October 7, 2026. Source |
| S15 | Policies in Fabric | PREVIEW | An allow list for the tenant or a capacity. Allow is the only effect, there is no Deny. Source |
| S16 | OneLake catalog Govern | GA | One admin screen for label coverage, DLP results, tenant settings, and recommended actions. Refreshes once a day. Source |
| S17 | Observability: new Monitor hub, workspace monitoring, Activator alerts | PREVIEW | Run history and success rate for every job, workspace monitoring in an eventhouse, and job alerts. Source |
| S18 | OneLake catalog search API | PREVIEW | Search the whole tenant from code with POST /v1/catalog/search, also available as the search_catalog tool in Core MCP. Source |
| S19 | AI functions in Spark | GA | ai.translate, ai.analyze_sentiment, and ai.classify in one line per column, on a built-in endpoint with no API key. Source |
| S20 | Materialized lake views | GA | Silver and gold layers in SQL, with CONSTRAINT ... ON MISMATCH DROP for bad rows. Views authored in PySpark are in preview. Source |
| S21 | Fabric data agent | GA | Natural-language questions answered with SQL, DAX, or KQL over lakehouses, warehouses, semantic models, and KQL databases. Source |
| S22 | OneLake table APIs: Unity Catalog API and Iceberg REST Catalog | GA | The same Delta tables read through Unity Catalog compatible and Iceberg REST Catalog endpoints, with no copy. Source |
Three doors: how Fabric data reaches agents
Before Barcelona, Copilot and the data agent worked inside Fabric, and the answer stayed there. After Barcelona, Fabric answers questions from outside the platform, and the main consumer of the data is now an agent.
- Microsoft 365 Copilot Chat and Cowork. A user asks in the chat, and Fabric IQ answers from a semantic model you control.
- MCP servers. An MCP client queries Fabric IQ read-only, and Core MCP creates workspaces and items on the user's behalf.
- Copilot Studio and the OneLake Table Read API. A data agent works as a tool for another agent, and an app reads Delta and Iceberg tables over REST.
Each door enforces the user's permissions. The question is who set those permissions.
Two Microsoft Fabric settings that are on by default
- "Fabric data in Microsoft Copilot" in the Microsoft 365 admin center gives Microsoft 365 Copilot access to Power BI data and is on for everyone. Learn
- The AI setting on a semantic model lets anyone with read-only access use Copilot, Copilot Chat, Cowork, the data agent, and MCP tools. It doesn't carry over to chained models. Learn
Admin checklist: four tenant settings to check after FabCon 2026
- Check who can reach Fabric data from Microsoft 365 Copilot. In the Microsoft 365 admin center, open the Copilot settings and find "Fabric data in Microsoft Copilot". It is on for all users by default. Learn
- Review the AI setting on sensitive semantic models. Check the AI setting on semantic models with HR and finance data. It lets anyone with read access use Copilot, the data agent, and MCP tools, and it does not carry over to chained models. Learn
- Check the cross-region AI tenant settings. Check the tenant settings that let AI process or store data outside the capacity's region and geography. They matter for capacities outside the EU Data Boundary and the US, including the UK. Learn
- Turn on outbound access protection where data is sensitive. Turn on workspace outbound access protection for workspaces with sensitive data, so data cannot leave through shortcuts or data agents. Learn
For engineers: test RLS under the data agent on your own model, and tag preview items before someone puts them into production. For CTOs: the agent acts on the user's behalf, read-only, and can't see more than the user. Ask Microsoft whether an agent can run under its own Entra Agent ID.
What's still missing: the Microsoft Fabric roadmap after Barcelona
| ID | What | Status |
|---|---|---|
| R1 | On-demand billing and F0 capacity | Coming soon, no pricing yet |
| R2 | Database agents for SQL and PostgreSQL | Coming soon |
| R3 | Native ontology and semantic model support in IQ sharing | On the roadmap |
| R4 | Apache Ossie, a vendor-neutral ontology standard, together with Snowflake | Announced |
| R5 | GA date for OneLake security | Not given |
| R6 | Previous ontology experience | Retires January 31, 2027 |
Source: the FabCon and SQLCon 2026 announcement on the Microsoft Azure blog and the Microsoft Learn pages linked above.
FAQ
What was announced at FabCon Europe 2026 in Barcelona?
The main announcements: Fabric IQ in Microsoft 365 Copilot Chat and Cowork (GA), the Fabric IQ MCP server (GA), the Fabric Core MCP server, data agents in Copilot Studio, the OneLake Table Read API (preview), Project Osmos (preview), operations agents (preview), a new ontology in Fabric IQ (preview), agentic apps in Power BI Desktop (preview in the coming weeks), OneLake security (GA announced for the coming weeks), policies in Fabric (preview), and on-demand billing with an F0 capacity (roadmap).
Is Fabric IQ in Microsoft 365 Copilot Chat generally available, and does it cost extra?
Yes, it is GA. There is no extra charge for AI tokens, but the queries still use your Fabric capacity, and each user needs a Microsoft 365 Copilot license. Data agents and ontologies answer in Copilot Chat only once they are published as a Microsoft 365 agent.
What is the difference between the Fabric IQ MCP server and the Fabric Core MCP server?
Fabric IQ MCP is a GA, read-only server for Power BI reports and semantic models: search, metadata, and DAX queries under the user's permissions and RLS. Fabric Core MCP exposes Fabric REST operations, and 15 of its 27 tools write changes to workspaces, items, and permissions. Learn warns that autonomous or misconfigured clients may perform destructive actions.
Is OneLake security generally available?
The keynote announced GA for the coming weeks without a date, and Learn gave no GA date on October 21, 2026. OneLake security defines roles, RLS, and CLS once and enforces them across Fabric engines and shortcuts. Every lakehouse has a DefaultReader role. The roles restrict users with Viewer or Read access, while Admin, Member, and Contributor keep broader access.
Does the Fabric data agent support languages other than English?
Officially, no. Learn describes questions in English. The Polish and German demo agents in this repo answered correctly, but outside official support, so test your own language before you rely on it.
Do I need the cross-geo processing setting for Copilot in Fabric?
Not for capacities in the US or inside the EU Data Boundary, which covers the EU and the EFTA countries, Switzerland included. Copilot for a Swiss capacity can still run in an EU datacenter outside Switzerland. Capacities in the UK and other geographies need the setting turned on.
When does the previous ontology experience in Fabric retire?
On January 31, 2027. The new ontology in Fabric IQ, in preview, replaces it.
What is Project Osmos?
Project Osmos is the data engineering agent in Microsoft Fabric, in preview. It plans, runs, and validates data engineering tasks on SparkCore, the tasks persist, and Fabric and OneLake permissions remain the boundary of what it can do. You start it from a coding agent such as GitHub Copilot CLI.
Can I run these demos in my own Fabric tenant?
Yes. The demos folder has a Python script that creates an F8 capacity, a workspace, synthetic data, a semantic model, an eventhouse, notebooks, and a data agent, plus one runbook per recorded demo with the exact prompts and expected results. F8 costs about 1.41 EUR per hour in France Central at the Azure retail price, and the capacity can be paused when you are done.
Demo recordings
20 recordings: 18 product demos from a demo tenant with synthetic data (an oud perfume house with formulas, ingredients, and preference trials), the keynote showreel, and interviews with seven people at Microsoft. Links below play the English takes.


The "Fabric data in Microsoft Copilot" setting slide 8, 12 sThe Microsoft 365 admin center setting that gives Microsoft 365 Copilot access to Power BI data, on for all users by default.
Also in Polish and German · Runbook D01
The AI setting on a semantic model slide 8, 11 sThe semantic model setting that lets anyone with read access use Copilot, Copilot Chat, the data agent, and MCP tools.
Also in Polish and German · Runbook D02
Fabric IQ MCP server slide 11, 23 sRead-only tools, model discovery, and a DAX query over a semantic model through the Fabric IQ MCP server.
Also in Polish and German · Runbook D03
Fabric Core MCP server tools slide 11, 17 sThe Fabric Core MCP server lists 27 tools, 15 of which write changes.
Also in Polish and German · Runbook D04
OneLake Table Read API slide 12, 14 sAn app reads a Delta table over REST as Apache Arrow, with no cluster and with OneLake security applied.
Also in Polish and German · Runbook D05
Project Osmos task in Fabric slide 13, 49 sA Project Osmos task builds a gold scorecard table: execution plan, live activity, and the resulting table.
Also in Polish and German · Runbook D06
Operations agent investigates a failed pipeline slide 14, 47 sThe operations agent explains why a pipeline run failed, straight from Monitor hub.
Also in Polish and German · Runbook D07
Ontology agent in Fabric IQ slide 15, 47 sThe ontology agent plans entities and relationships from a semantic model, validates the draft, and applies it.
Also in Polish and German · Runbook D08
Copilot generates a Real-Time Dashboard slide 16, 55 sCopilot for Real-Time Intelligence builds a dashboard on an eventhouse from one sentence.
Also in Polish and German · Runbook D09
OneLake security roles slide 17, 14 sManaging OneLake security roles on a lakehouse, including the DefaultReader role.
Also in Polish and German · Runbook D10
Outbound access protection slide 17, 18 sWorkspace outbound access protection settings that stop data from leaving the workspace.
Also in Polish and German · Runbook D11
Policies in Fabric slide 18, 16 sFabric tenant policies: an allow list scoped to the tenant or a capacity.
Also in Polish and German · Runbook D12
OneLake catalog Govern slide 18, 20 sThe admin view of the OneLake catalog: governance insights, domains, and recommended actions.
Also in Polish and German · Runbook D13
OneLake catalog search API slide 26, 30 sSearching the whole tenant from code with POST /v1/catalog/search and with the search_catalog tool in Core MCP.
Also in Polish and German · Runbook D14
AI functions in a PySpark notebook slide 27, 29 sai.translate, ai.analyze_sentiment, and ai.classify on tester comments written in English, Arabic, and French.
Also in Polish and German · Runbook D15
Materialized lake views with data quality rules slide 28, 84 sBronze, silver, and gold layers in SQL. Three bad rows are dropped by CONSTRAINT ... ON MISMATCH DROP.
Also in Polish and German · Runbook D16
Fabric data agent answers from a lakehouse slide 29, 45 sA data agent answers two questions with SQL over a lakehouse, and both answers match the data.
Also in Polish and German · Runbook D17
OneLake table APIs: Unity Catalog and Iceberg REST slide 30, 25 sThe same Delta tables read through the Unity Catalog API and the Iceberg REST Catalog.
Also in Polish and German · Runbook D18
Run the demos in your own Fabric tenant
The demos folder rebuilds the environment behind the 18 product recordings: one Python script creates the capacity, the workspace, synthetic data, a semantic model, an eventhouse, a failing pipeline, notebooks, and a data agent. Each demo has a runbook with the exact prompts in English, Polish, and German and the result you should see.
python3 fabdemo.py up
Runs on an F8 capacity, about 1.41 EUR per hour in France Central at the Azure retail price on October 21, 2026. Pause or delete it with one command when you are done. Code under the MIT License.
Limits, stated up front
- Statuses are a snapshot from October 21, 2026, checked against Microsoft Learn. Microsoft relabels features often.
- TBC means two sources disagree or Learn shows no label. The recap does not guess.
- Keynote claims are marked as keynote claims. Where Learn disagreed, the table says so.
- Four announcements have no demo. Fabric IQ in Microsoft 365 Copilot Chat and the data agent in Copilot Studio need licenses the demo tenant does not have, and database agents and agentic apps had not shipped.
- All demos ran on synthetic data in one test tenant, on an F8 capacity in France Central. Portal labels move, so a runbook step can drift.
- The Polish and German data agent answers worked in the demos, but Learn describes questions in English only.
A runbook step no longer matches what Fabric shows? Report it.
License: reuse it, credit the source
The slides, text, PDFs, and demo recordings are licensed under CC BY 4.0. Copy, share, and adapt them for any purpose, as long as you credit the author and link this source:
Based on "FabCon Europe 2026 recap" by dr Estera Kot, https://github.com/ekote/fabcon-barcelona-2026-recap, licensed under CC BY 4.0.
Not covered: the interview recording on slide 3, Microsoft product interfaces, logos, the meme image, the deck engine files, and the bundled fonts and icons. Details in NOTICE.md.