top of page

What Is Microsoft Fabric? A Plain-English Guide for Leaders

Microsoft Fabric keeps showing up everywhere. In licensing emails, in vendor pitches, in that awkward moment when someone senior asks "should we be using Fabric?" and nobody in the room can give a straight answer.


That's a problem. Not because Fabric is urgent for everyone, but because it's now central to Microsoft's data strategy going forward. Whether you adopt it or not, you need to understand what it actually is so you can make that call properly.

Most explanations jump straight into features and architecture diagrams. This isn't that. This is the version I wish existed when I first started pulling the thread on Fabric: what it is, why Microsoft built it, what it costs, and what it won't fix on its own.


I made a full video walking through all of this (it's below), but here's the written summary with a few extras that didn't make the cut.

Why Microsoft Fabric exists


Microsoft Fabric is a unified data and analytics platform designed to bring data storage, engineering, analysis, and reporting into one governed environment, built on a shared data layer called OneLake.

But the features don't mean much unless you recognise the problem.

In most organisations, analytics has outgrown its initial design. You might have proper pipelines running, a central data store, and Sales reports that people actually trust. And then, usually by accident, you discover that Finance has been exporting CSVs into Excel, saving them in SharePoint, and quietly running that as their own little data warehouse.

They didn't do anything wrong. They just didn't know the data already existed, or it was modelled so tightly around that Sales report it wasn't usable anywhere else.

That's the pattern. Different teams, same problems, different tools, data copied everywhere. Not because anyone wants chaos, but because the system made it the easiest option.

How OneLake works

People often compare Fabric to Office: lots of tools under one umbrella. I get the comparison, but it hides the real value. With Office, you email a OneDrive link on Monday and by Friday you've still got two competing versions in the same folder plus a rogue third living rent-free on Susan's hard drive. It's digital mitosis.

That's not unlike how silos form across fragmented analytics setups. Same customer list, same transactions, stored in different places, different formats, different versions of "truth."


I think the better analogy is Google Maps. Google Maps stores every road, building, and river once. When you switch to satellite view, traffic view, or terrain view, you're not creating a new copy. You're looking at the same map through a different lens.


That's what Fabric's shared foundation, OneLake, is designed to do. Your sales data is stored once. Power BI reads it as a report. Data scientists read it as a lakehouse. Excel reads it as a table. Same data. One version. One truth.


What this Fabric explainer covers

The full video walks through everything a non-technical leader needs to know, including:

  • Why Fabric exists and the real problem it solves

  • What changes (and what doesn't) if you're already using Power BI

  • How licensing and cost actually work (Microsoft has made this almost impossible to figure out, so I decoded it)

  • What Fabric won't fix, because if your Power BI environment is messy today, Fabric will help you scale that mess beautifully

  • What good looks like when an organisation gets this right


Why Fabric won't fix bad data governance on its own

Here's where I'd push anyone evaluating Fabric to slow down. Remember that Finance team with the shadow warehouse of Excels? OneLake can make the tech more resilient. But data ownership, agreed definitions, governance frameworks? Those won't materialise because you enabled a platform.

Fabric enables discipline. It does not create it.

Understanding the platform is half the work. The other half is designing the operating model around it: who owns what, how domains are structured, how access is governed, and how you stop the next team from rebuilding the same pipeline for the fourth time.

If you're trying to figure out where Fabric or Power BI fits in your data strategy, or how to design the operating model that actually makes it work, [that's what I help organisations with](link to Power BI page).

bottom of page