For most of the last twenty years, data platform vendors competed over where your data was stored and which engine processed it. That contest is winding down. Open table formats such as Delta Lake and Apache Iceberg let most modern engines read the same files, and every major platform can now read its rivals' data. The competition has moved up a layer, to the place where your organisation's numbers get their meaning.
That place is the semantic layer. It is where "revenue", "active customer" and "late order" are defined, where tables are joined the right way and where access rules are applied. Whoever holds it decides where your reports run and where your AI agents get their answers. Call it semantic layer supremacy. This article looks at who is competing for it, why a semantic layer for AI has become the prize, how to build one properly, and why Microsoft wants yours to sit in Fabric whichever platform holds the data underneath.
What is a semantic layer?
A semantic layer is the part of a data platform that translates raw tables into business terms. It defines your measures, such as revenue or margin, the relationships between your data, and who is allowed to see what, so that every report and AI tool gives the same answer to the same question.
Raw tables hold facts. They do not say which facts count. A sales table records every order, but it cannot tell you whether revenue includes VAT, cancelled orders or sales between your own companies. Each analyst decides for themselves, and the figures drift apart.
A semantic layer settles those questions once. It holds business definitions as measures, the relationships between tables, hierarchies and the financial calendar, business names and synonyms, and the rules on who can see what. Every report, spreadsheet and AI tool on top of it uses the same logic. We set out what goes into one in Why Microsoft Fabric. In Fabric, the semantic layer is the Power BI semantic model.
For years this was treated as a reporting detail that the BI team looked after. AI changed that.
Why AI needs a semantic layer
Ask an AI agent "what was revenue last quarter?" and it has to turn the question into a query. Without a semantic layer it reads table and column names, guesses which ones matter and guesses how to join them. Then it returns a figure with complete confidence, whether the guess was right or not.
The research points one way. In a 2023 benchmark by data.world, GPT-4 answered business questions over an insurance database correctly 16% of the time when it queried the tables directly, and 54% of the time when it worked through a knowledge graph of the same data. dbt Labs reran a similar test in April 2026 with current models. Better models have narrowed the gap, but on a well-modelled project the semantic layer still lifted accuracy from 90% to 98% for one model and from 84% to 100% for another. dbt makes the more useful point itself: a semantic layer answers from a defined metric or says it cannot. It never quietly returns the wrong number.
Vendors run most of these benchmarks on small sets of questions, so read them as a direction of travel. The analysts have reached the same view. In March 2026 Gartner predicted that "by 2030, universal semantic layers will be treated as critical infrastructure, alongside data platforms and cybersecurity". In May it forecast that organisations which prioritise semantics will raise the accuracy of their AI agents by up to 80% by 2027.
Reports used to be the main consumer of business logic. AI agents are taking that role, and an agent that reads its definitions from one vendor's semantic layer runs on that vendor's platform. That is why every vendor wants to hold it.
The battle for the semantic layer
Every major data vendor now has its own semantic layer and an AI assistant that reads it. Each has also released a Model Context Protocol (MCP) server, the emerging standard that lets outside AI agents use the semantic layer as well.
| Vendor | Semantic layer | AI that reads it |
|---|---|---|
| Microsoft | Power BI semantic models, extended by Fabric IQ | Copilot in Power BI and Microsoft 365, Fabric data agents |
| Snowflake | Semantic views | Cortex Analyst and Cortex Agents |
| Databricks | Unity Catalog metric views | Genie, with Genie Ontology in preview |
| Looker and its LookML models | Gemini in Looker | |
| Salesforce | Tableau Semantics | Tableau Next and Agentforce |
| dbt Labs and Fivetran | dbt Semantic Layer (MetricFlow) | Any agent, through the dbt MCP server |
| Independents | AtScale, Cube | Any agent, through their MCP servers |
Acquisitions have followed. Fivetran and dbt Labs completed their merger on 1 June 2026, joining the leading data movement tool to the leading transformation tool. Salesforce completed its purchase of Informatica in November 2025. ServiceNow bought data.world, the company behind the 2023 benchmark, in July 2025. Each deal gives one platform more control over the definitions and context its AI depends on.
An open semantic layer standard, with limits
In September 2025 Snowflake, Salesforce, dbt Labs and others launched the Open Semantic Interchange, an effort to agree one vendor-neutral format for semantic definitions. Databricks joined when the first specification was published in January 2026. In mid-2026 the project moved to the Apache Software Foundation as Apache Ossie. At FabCon Barcelona on 28 September 2026, Microsoft committed to it, and its engineers contributed a converter between Power BI semantic models and the Ossie format. Google is reported to be joining.
So the vendors competing for the semantic layer are also agreeing to make it portable. That looks like a ceasefire. In practice it changes the contest in two ways.
The first is that the standard is young. The current specification is a version 0.2 development draft. Tabular Editor's review of the Microsoft converter found that only simple metrics, such as a single sum or count of a column, translate into DAX. Row-level security, calculation groups and hierarchies have no equivalent in the standard yet. The parts of a semantic model that take the most work to get right are the parts that do not travel.
The second is that portable definitions move the contest to what sits on top. If any platform can read your metric definitions, vendors compete on what they do with them: the AI assistant, the reports, and the tools your staff already use every day. Microsoft is better placed than anyone to win that contest.
Microsoft Fabric's play: your data can live anywhere
Microsoft no longer insists that your data lives in Fabric. Over the past eighteen months it has made Fabric able to read almost everywhere else:
- Databricks. Fabric can mirror an Azure Databricks Unity Catalog, which makes its tables available in OneLake without copying the data. This has been generally available since July 2025.
- Snowflake. Snowflake mirroring has been generally available since November 2025, and Snowflake and OneLake have been able to read each other's Apache Iceberg tables since early 2026.
- Amazon S3 and Google Cloud. OneLake shortcuts point at data in Amazon S3, S3-compatible storage and Google Cloud Storage, with caching to cut the charges for moving data out of those clouds. Google BigQuery mirroring became generally available in September 2026.
- Business systems. Mirroring now covers Oracle and SAP Datasphere, both generally available since March 2026, alongside SQL Server, Azure SQL and others.
- dbt. A dbt job in Fabric, in preview, runs dbt projects inside the platform, so teams that already model in dbt can carry on.
Microsoft has said plainly why. On its July 2025 earnings call, Satya Nadella described OneLake as spanning "all databases and clouds, including semantic models from Power BI", and therefore "the best source of knowledge and grounding for AI applications". In his next sentence he noted that Azure Databricks and Snowflake on Azure were growing too. Microsoft earns from those platforms when they run on Azure, so it does not need to win the storage contest.
What Microsoft wants is the layer above the data. Arun Ulag, who runs Azure Data at Microsoft, has said there are 20 million semantic models running in Fabric and that Microsoft wants to "upgrade them into a full ontology" for AI agents. That is Fabric IQ. Microsoft's documentation calls it "the supported path for data answers in Microsoft 365 Copilot, Copilot Studio, Microsoft Foundry, and custom agents". Fabric IQ in Microsoft 365 Copilot became generally available in September 2026, and the Fabric IQ MCP server opens the same semantic models to outside AI tools. The ontology itself is still in preview.
Put together, the strategy is simple. Leave the data in Databricks, Snowflake or S3. Mirror it or shortcut it into OneLake. Build the semantic model in Fabric, reading the data where it sits through Direct Lake. Then every Copilot answer in Teams, Outlook and Excel, every Power BI report and every data agent draws on that one model. Microsoft 365 is where most staff spend their working day, so the semantic layer that feeds it starts with a big advantage. Customers are following: Microsoft reported more than 40,000 paying Fabric customers in July 2026, against 25,000 a year earlier.
How to build a semantic layer for AI
For a mid-sized organisation, the practical lesson is this. You do not need to bet on which storage platform wins. You do need a semantic layer that is built properly, because the same model now serves your reports and your AI. A model that works for one dashboard can still mislead an agent.
Six practices make the difference:
- One model per business area, shared by many reports. Finance, sales and operations each get an endorsed model that everyone builds on. Dozens of near-identical models, each with its own version of revenue, defeat the purpose.
- Every definition written once, as a measure. Logic buried in report visuals, SQL views or spreadsheets is invisible to an AI agent and drifts from everything else.
- A clean star schema. Fact tables of events join to dimension tables of things, with the relationships set in the model. Agents get joins wrong when the structure is unclear, just as people do.
- Descriptions and synonyms. AI reads them. A measure called "Rev_Net_Adj" with no description gets guessed at. One described as "net revenue after credit notes, excluding VAT and intercompany sales" gets used correctly. Fabric's AI instructions and verified answers, both in preview, build on this.
- Security in the model. Row-level security set in the semantic model applies to every report and every agent, so an agent only answers with what the person asking is allowed to see.
- Version control. Keep the model definition in Git so that changes are reviewed, tested and reversible like any other code. Fabric stores models in a readable text format for exactly this.
If your data already lives in Databricks or Snowflake, you do not have to move it to benefit. Mirror it into OneLake, build the semantic model in Fabric and leave the engineering where it is. If your team models in dbt, keep dbt for transformation and use the semantic model for meaning. Simple metric definitions may move between the two through Apache Ossie in future, but do not design around that until the standard matures.
The organisations that get this right will find each new report and each new AI agent is a small addition on top of definitions they already trust. The ones that skip it will keep rebuilding the same logic, in more places, for more tools.
Our recommendation: start with a Data Assessment
If you are not sure whether your current models would stand up to an AI agent, start with our Data Assessment. It takes a ten-minute questionnaire and one conversation of up to two hours on Teams. We look at where your data lives, how your business definitions are held today and what it would take to put a trusted semantic layer under your reporting and AI. There is nothing to install, and we do not connect to your systems.
Within five working days you get a costed roadmap of 10 to 12 pages, written for whoever signs off spend, with one recommended first step. It is yours to keep whether or not you take the next step.
Start your Data Assessment
A ten-minute questionnaire, one call on Teams and a costed roadmap within five working days.
MPowerUp is a Microsoft Partner based in Winchester, Hampshire. Product names, preview and general availability status and customer figures are as published by Microsoft and other vendors in October 2026 and may change. Accuracy figures come from published vendor and academic benchmarks.