What is Microsoft Fabric? A plain-English explainer

Microsoft Fabric is a single software-as-a-service analytics platform that covers the whole journey from raw data to finished report. Instead of buying separate services for moving, storing, transforming and visualising data, you get one product with one storage layer underneath — OneLake — and Power BI as the reporting workload inside it.

What is actually in it?

Fabric bundles what were several separate purchases into role-based workloads on one platform (Microsoft Learn):

• Power BI — reports and dashboards, the part you already know.
• Data Factory — moving and preparing data, with 200-plus connectors.
• Data Engineering — Spark and notebooks for large-scale transformation.
• Data Warehouse — SQL warehousing, stored in the open Delta Lake format.
• Data Science — building and operationalising machine learning models.
• Real-Time Intelligence — data in motion: sensor readings, logs, clickstreams.
• Databases — operational databases, plus mirroring from Azure SQL and Snowflake.

Underneath sits OneLake, a single logical data lake on Azure Data Lake Storage Gen2. Every workload reads and writes to the same store, so data is not copied between services, and shortcuts can point it at data already sitting in Amazon S3 or Google Cloud Storage.

How does it relate to Power BI?

Power BI is a workload inside Fabric, not a separate product any more. That sentence causes most of the confusion.

It does not mean you need Fabric to use Power BI. You can keep buying Power BI Pro at £10.80 per user per month (as of September 2026, ex VAT, per Microsoft's UK pricing page) and never provision a capacity. Most UK small businesses do exactly that.

It does mean the two share an admin surface, a storage layer and a licensing model — which is why Power BI licensing questions now arrive with F-SKUs attached. Our guide to Power BI licensing untangles which parts you need.

A worked example

A 60-person manufacturer wants a weekly production dashboard. Data sits in Sage, a SQL Server database and three spreadsheets.

Without Fabric: Power BI Desktop connects to all three, a model is built, the report publishes to a Pro workspace, a refresh runs each morning. Ten Pro licences, roughly £1,300 a year. For this business, correct.

With Fabric: Data Factory lands the sources into a lakehouse in OneLake overnight, transformations run there, Power BI reads the cleaned tables. The dashboard is identical. What differs is that the data is cleaned once, in one place, reusable later — which matters at twelve sources and four teams, and is expensive overhead at three sources and one analyst.

Should a small business buy it?

Usually not yet, and that answer is not fashionable.

If the problem is "our numbers live in spreadsheets and nobody trusts them", the fix is a properly built star schema, not a platform. The honest test: if you cannot name what you would build in Data Factory this quarter, you are buying capacity you will not use. Our data practice and Power BI consultancy pages cover that call.

Frequently asked questions

What is Microsoft Fabric in simple terms?

A single software-as-a-service analytics platform covering the whole journey from raw data to finished report. Rather than buying separate services for moving, storing, transforming and visualising data, you get one product, one storage layer called OneLake, and Power BI as the reporting workload inside it.

Is Power BI part of Microsoft Fabric?

Yes — Power BI is one workload inside Fabric, alongside Data Factory, Data Engineering, Data Warehouse, Data Science and Real-Time Intelligence. You can still use Power BI on its own with per-user Pro or PPU licences and never touch the rest, which is what most UK small businesses do.

Does a small business need Microsoft Fabric?

Usually not yet. If the problem is "our numbers live in spreadsheets and nobody trusts them", Power BI with a properly built data model fixes that. Fabric earns its place when you genuinely need engineering workloads — pipelines, a lakehouse, streaming data — and have someone to own them.

---

Easy Insight is a UK consultancy for AI, web, apps and data — senior specialists only, no juniors.