Microsoft Fabric

Microsoft Fabric, run as a platform you can afford to keep

Fabric is sold like SaaS and charges like PaaS. One runaway query or a Spark cluster somebody left running can throttle the whole tenant and spend the month's capacity over a weekend. We run the Fabric lifecycle as one practice - assess, migrate, build, govern, run - so the platform stays predictable to pay for and the data underneath stays trustworthy. Dynamics-native since 2002, and independent of anyone's licence quota.

Dynamics-native since 2002·customers across 20+ countries on 4 continents·the full Fabric lifecycle, from readiness assessment to managed capacity.

What Fabric is

What is Microsoft Fabric, and where does it stop?

Microsoft Fabric is the platform: the capacity you buy, the compute that runs on it, the OneLake storage your data sits in and the security boundary drawn around all of it. It is not your data model, and it is not your reporting. Three layers, and confusing them is the single most expensive mistake in a Fabric programme: the platform (Fabric), the reconciled model layer that sits on the platform, and the reporting that sits on top of that.

Buying Fabric does not give you numbers you can trust. It gives you somewhere to put them. Fabric will store data that does not reconcile just as happily as data that does, and it will charge you the same for the privilege. The platform decision and the trust decision are different decisions, made by different people, and they need to be made in the right order.

This is the platform pillar. It owns the capacity, the compute, the OneLake security model, the networking, and the bill. The two layers above it have their own pillars, because they are genuinely different work.

The platform. Fabric itself: what SKU you are on, how much capacity you hold, who can reach OneLake, how the tenant is governed and what a bad weekend costs you. That is this pillar, and it is the section you are reading.

The reconciled model layer. The governed layer that makes your figures agree with each other, once, for everything that reads them. Fabric hosts it. It does not build it, and it will not fix it. That is the data warehouse pillar.

The reporting on top. The dashboards, the board pack, the month-end view. Power BI runs on Fabric capacity, which is precisely why a reporting problem so often turns out to be a platform problem, and why an unbudgeted platform is so often a reporting problem in disguise.

If you are not yet sure which of the three you are actually buying, the routing panel below shows where each piece of the Fabric lifecycle sits, and the readiness assessment is designed to answer exactly that question before you spend anything.

The cost problem

Why does Microsoft Fabric cost more than we budgeted?

Because Fabric is sold like SaaS and charges like PaaS. You buy a capacity, not a bill of materials, and every workload in the tenant draws on the same pool: a badly written query, a semantic model that quietly falls back to DirectQuery, a Spark job nobody switched off. Any one of them can throttle the entire tenant and spend the month's capacity over a weekend, and nobody finds out until Monday.

This is the part of Fabric that no licence conversation prepares you for. Capacity is shared, consumption is smoothed rather than capped, and the platform is designed to keep working right up to the point where it visibly stops. The failure is not technical. It is that nobody owns the capacity.

So here is the honest version of what we sell. You are not paying us to build pipelines. You are paying us to police the capacity: to size it, watch it, throttle the things that misbehave, and tell you before the bill does.

  • Pause and resume is an F-SKU feature. It does not exist on P. If your capacity cannot be paused, you are paying for evenings, weekends and the fortnight nobody logged in.
  • On-demand resizing is F only. Size up for month end, size back down afterwards. On a P SKU that lever is not in the cab.
  • Spark autoscale billing is F only. The one control that stops an experimental notebook eating a production capacity.
  • F64 is the licence threshold. At F64 and above, viewers can consume Power BI content on a free Fabric licence. Below it, every single viewer needs Pro, which is a licence bill hiding inside a platform decision.
  • The platform-hardening features are F only too. Trusted workspace access, managed private endpoints, customer-managed keys and workspace-level private links. The security conversation and the SKU conversation are the same conversation.

That is the FinOps case, and it comes straight off Microsoft's own SKU feature matrix rather than a vendor benchmark. The levers that make Fabric affordable to run only exist on the F SKUs. Which is why the cost question and the migration question turn out to be the same question.

  • For the IT Director. Fabric is infrastructure, and it lands on your plate: capacity units, Spark compute, OneLake access, networking, private endpoints, and a tenant that can be throttled by any workspace in it. You are the one who has to make it hold. We give you a platform that behaves, and an owner for the capacity that is not you at 11pm.
  • For the Finance Director. You are signing for OPEX, and the thing you need from a platform is that it is forecastable. A capacity that can be sized, paused and watched is a number you can put in a budget. A capacity that nobody polices is a number that arrives after the fact and cannot be explained.
Moving to Fabric

Do we have to move to Fabric, and by when?

There is no market-wide deadline, and anyone selling you one has invented it. The forcing functions are real but they are specific to you: the legacy Export to Data Lake pipe has been retired, so if your Dynamics data still travels it you are already running on borrowed time; and P SKUs can no longer be bought, only renewed, so the conversion to an F SKU lands at your renewal date, not on some industry cliff edge.

The pipe that is genuinely dead. Export to Data Lake, the legacy Dynamics data-export route, has been retired: deprecated in late 2024 and decommissioned from early 2025 under Microsoft's own transition guidance. If that is still how your Finance and Operations data reaches your lake, the clock is not ticking, it has already gone off. That is a migration, and it is the most common front door onto this pillar.

Azure Synapse Link is not going away. We will not pretend otherwise in order to manufacture a deadline, and a technical buyer would rightly throw us out if we tried. Microsoft supports both Link to Fabric and Azure Synapse Link, and has been explicit that customers who want to keep exporting data and running their own pipelines will be able to do so. So the choice between the two paths is an architecture decision, not a countdown.

Link to Fabric. No copy, no ETL, straight into Fabric, and the data stays inside the Dataverse governance boundary. The trade: every non-system table with Track changes enabled is auto-selected, so you cannot cherry-pick the tables you want, and it consumes additional Dataverse storage.

Azure Synapse Link. Continuous export into your own storage account, with your own pipelines and your own access model. The trade: it is your storage and your compute to run, but you can choose exactly which tables come across.

Which one is right depends on your estate, not on fashion. Table volume, storage cost, who owns the governance boundary and what your reconciliation actually needs. That is the first question our readiness assessment answers, and it is the decision the migration is built on.

And the P SKU question. P SKUs can no longer be purchased. They can be renewed, and they are being retired, which means the conversion to F happens when your agreement comes up. Microsoft is clear that no immediate action is required and that you can carry on using your existing Premium capacity until your next renewal. So the honest position is this: you have a date, but it is your date. What matters is that you arrive at it having already decided, rather than converting under time pressure and inheriting a capacity nobody sized.

The practice

One practice, not a pile of Fabric projects

We run Fabric as a single connected practice: diagnose, move, build, run, with governance and security as the layer that holds across all four. The spine of all of them is the same idea. The platform is only worth having if it is affordable to keep and safe to open up.

The reason to treat it as one practice is that Fabric punishes the piecemeal approach. A migration done without a capacity plan produces a working platform with an unaffordable bill. A build done without a governance model produces a lake that everyone can read. A capacity that nobody runs quietly drifts until the month it does not. Each rung protects the one before it.

  1. Diagnose.

    Find out what you are actually on, what it will cost on Fabric and what breaks when you move, before you commit to anything. The low-commitment first rung: the Fabric readiness assessment.

  2. Move.

    Get off the retired pipe and onto a supported path, with the SKU, the capacity and the table strategy decided rather than defaulted. Routes to migration to Microsoft Fabric.

  3. Build.

    Put the architecture in: OneLake, the medallion layers, the workspace topology, the capacity design that means one team's experiment cannot take out another team's month end. Routes to Fabric architecture and implementation.

  4. Run.

    Someone has to own the capacity: watch it, size it, pause it, catch the query that is about to cost you a weekend. Routes to the managed Fabric platform and FinOps service.

  5. Govern and secure.

    Across all four rungs: who can see what in OneLake, and whether the controls you think you have actually hold. Routes to Fabric governance and security.

You can enter at any rung. Most organisations enter at the diagnose rung or through a migration, because those are the two moments when the platform question becomes unavoidable.

Explore

An assessment, a migration, a build or a managed platform - which do we need?

They sit on one ladder: assess (a readiness assessment to find out what Fabric will actually cost you and what breaks on the way), move (migrate off the retired pipe onto a supported path), build (the architecture, the workspaces and the capacity design), then run (someone owns the capacity and the bill), with governance and security holding across all of it. Most organisations start with the assessment. Pick the card that matches where you are.

  • Fabric readiness assessment. You are not sure Fabric is the right move, or what it will cost. A fixed-scope diagnosis of your estate, your likely capacity, your data paths and what breaks on the way. The entry rung. Fabric readiness and strategy
  • Migration to Microsoft Fabric. You are on a retired or unsupported pipe, or converting a P SKU at renewal. The move done with the SKU, the capacity and the table strategy decided in advance. Migration to Microsoft Fabric
  • Fabric architecture and implementation. You know you are going to Fabric and need it built properly. OneLake, medallion layers, workspace topology and a capacity design that will not throttle itself. Fabric architecture and implementation
  • Managed Fabric platform and FinOps. You have Fabric and nobody owns the capacity. A managed platform service that watches consumption, sizes and pauses capacity, and tells you before the bill does. Managed Fabric platform
  • Fabric governance and security. You need to know who can actually see what. OneLake security has sharp edges, and several of them hand data to people you thought were excluded. Fabric governance and security

Our deepest specialism, Microsoft Fabric for Dynamics 365, gets its own block below rather than a card here, so it stands out rather than competing with the five.

Our deepest specialism

Can you run Fabric for a Dynamics 365 estate?

Yes, and it is where our depth concentrates. Dynamics data does not arrive in Fabric clean: reserved words get renamed, ID becomes FnO_Id, deleted rows are retained and flagged rather than removed, and long text fields are truncated on the way through. If nobody tells you that before the build, you find out during reconciliation, which is the expensive place to find out.

Most firms come at Fabric from one of two directions: platform engineers who have never had to make an intercompany balance, or ERP implementers who bolt a lake on and leave. PrecisionPoint has been in the gap since 2002, and the Fabric for Dynamics 365 programme is where the platform work and the Dynamics data model meet.

See the programme – Microsoft Fabric for Dynamics 365
Why us

What actually qualifies you to run our platform?

We are an independent, Dynamics-native Microsoft data specialist, in continuous practice since 2002, with customers across 20+ countries on 4 continents and the full Fabric lifecycle behind us. What qualifies us is not a badge. It is that we have no incentive to sell you more capacity than you need, and two decades of knowing what Dynamics data does when it hits a platform.

The uncomfortable question on a Fabric engagement is whose side your consultant is on when the capacity conversation comes up. A firm whose economics improve when your consumption rises will always find a reason for you to consume more. We are independent, and the whole managed-platform proposition rests on the opposite promise: the capacity gets smaller when it should, and somebody tells you why.

  • Independent. No tier to defend, no quota to fill. Our advice on your SKU, your capacity and your architecture is not underwritten by anyone else's incentives.
  • Dynamics-native since 2002. Built around Dynamics data from day one, across D365, AX and NAV. We know what breaks between the ERP and the lake because we have been fixing it for over two decades.
  • Customers across 20+ countries on 4 continents. The practice travels.
  • The full Fabric lifecycle. Assess, migrate, build, govern, run, delivered as one practice rather than a single-point service you have to stitch to four others.
  • FinOps as a discipline, not an afterthought. Capacity is watched, sized and paused as a service, so the platform stays forecastable rather than becoming a monthly surprise.
  • Platform, model and reporting in one shop. We can run the platform, the reconciled model layer and the reporting together, so nobody gets to blame the layer below them.

For the depth behind this, see the Microsoft Fabric for Dynamics 365 programme. If you would rather start with your own numbers, the readiness assessment is the cheapest way to find out where you stand.

Common questions

Microsoft Fabric: common questions

What is Microsoft Fabric, and how is it different from a data warehouse and Power BI?

Fabric is the platform: the capacity you buy, the compute that runs, the OneLake storage your data sits in and the security boundary around it. The data warehouse is the reconciled model layer that sits on the platform and makes your figures agree. Power BI is the reporting on top that turns those figures into decisions. Three layers, three decisions. Fabric hosts the other two but does not do their job, and buying it does not make your numbers reconcile.

Why does Fabric cost more than we budgeted, and can that be controlled?

Because Fabric is sold like SaaS but charges like PaaS. You buy one shared capacity and every workload in the tenant draws on it, so a single bad query or a Spark cluster left running can throttle everything and consume the month's capacity in a weekend. It is controllable, but only if somebody owns it: sizing, monitoring, pausing and killing the workloads that misbehave. That is what our managed Fabric platform service exists to do.

Is there a deadline to move to Fabric?

Not a market-wide one. What is true is that P SKUs can no longer be purchased, only renewed, and they are being retired, so the conversion to an F SKU happens at your renewal, on your own date. Microsoft states that no immediate action is required and that existing Premium capacity can be used until the next renewal. The genuine urgency is elsewhere: the legacy Export to Data Lake pipe has already been retired, so estates still using it need to move regardless of any licence question.

Is Azure Synapse Link going away?

No. Both Link to Fabric and Azure Synapse Link are supported, and Microsoft has said it intends to let customers keep exporting data and running their own pipelines well into the future. The service that has been retired is the legacy Export to Data Lake route. If someone is selling you a move on the basis that this path is about to disappear, they are either out of date or inventing urgency.

Link to Fabric or Azure Synapse Link - which should we use?

It depends on your estate. Link to Fabric is no-copy and no-ETL and keeps the data inside the Dataverse governance boundary, but it auto-selects every non-system table with Track changes enabled, so you cannot cherry-pick, and it consumes additional Dataverse storage. Azure Synapse Link exports continuously into your own storage account, which you then run, but it lets you choose exactly which tables come across. Table volume, storage cost and who owns the governance boundary decide it. The readiness assessment answers it with your data, not a rule of thumb.

What does F64 mean, and does it matter to us?

F64 is the capacity threshold at which viewers can consume Power BI content on a free Fabric licence. Below F64, every viewer needs a Pro licence. It matters because it turns a platform sizing decision into a per-head licence decision, and the two are usually budgeted by different people. Working out which side of that line your organisation lands on, and what it costs either way, is part of a readiness assessment rather than a guess.

Are you a Microsoft partner, and what qualifies PrecisionPoint to run our Fabric platform?

We are an independent Microsoft data specialist, Dynamics-native and in continuous practice since 2002, with customers across 20+ countries on 4 continents. What qualifies us for platform work is not a badge but two decades of knowing what Dynamics data does when it lands on a platform, plus the fact that we have no incentive to sell you more capacity than you need. Independence is the point: on a consumption-billed platform, whose side your consultant is on is not a small question.

Start here

Talk to us about Fabric

A Fabric engagement starts with a conversation or a fixed-scope readiness assessment, not a platform commitment, so you find out what Fabric will actually cost you and what breaks on the way before you decide anything. Tell us what you are running today and we will point you to the right next step.

Whether you are already on Fabric and watching the capacity behave strangely, coming up to a renewal, stuck on a pipe that has been retired, or simply working out whether any of this is your problem yet, the first step is the same. If you want to start with your own numbers, the readiness assessment names what you are dealing with before you spend on the fix.

Talk to us

Tell us what your Fabric or Dynamics platform looks like today and we will come back to you with the right next step.