Microsoft Cloud · Data and analytics

Microsoft Fabric for Dynamics 365 and Dataverse — built, secured, handed over.

We bring your Dynamics 365 and Dataverse data into Microsoft Fabric and build the access model there before the first report is shared — because business units, security roles and record ownership are Dataverse concepts and do not travel into the lakehouse. Five building blocks, each with a result that stays with you.

Five building blocks each with a result in your hands Access model first before the first report is shared Microsoft Partner since 2007 Scope boundaries we say so when Fabric is too much

What we deliver

Five building blocks — each with a result you hold in your hands.

Scope, order and duration are set after we have seen your environment, not before.

01

Data path decision and setup

Link to Fabric as the path for new links, a recommendation on which workspace the link lands in, authentication via workspace identity rather than a user account, table selection and change tracking, initial synchronization in a low-load window. If an Azure Synapse Link path exists, retiring it belongs in the same plan.

Result. A running link in your workspace, plus a record of which path was chosen and why — traceable even when someone else asks later.

02

Access and security model in Fabric

Microsoft Entra ID groups, workspace roles, OneLake security roles, row-level security on the gold layer, column restrictions in the semantic model rather than in a OneLake column rule, a fixed identity for Direct Lake models, the default read permission DefaultReader kept with a reason or switched off, diagnostics and monitoring logs enabled, the result documented.

Result. A documented permission model: which group sees what, on which layer it is enforced, and how you spot a deviation.

03

Medallion architecture for your CRM data

Silver transformations for choice fields, lookups, delete rows and record versions; gold tables per business domain; file sizes and clustering following the documented Microsoft guidance for each layer.

Result. Gold tables per business domain for your reports to build on — without every report author having to know the quirks of the raw Dataverse data.

04

Capacity, cost and licensing

An SKU proposal measured against your consumer count and your model sizes, pay-as-you-go versus reservation, a pause plan for non-production, reconciliation with your existing Power BI licensing — together with our License Advisory.

Result. An SKU proposal with the arithmetic behind it, which you can check against your own volumes.

05

Governance and operations

Workspace model, separation of development and production, versioning via deployment pipelines, data quality rules with an escalation path, handover to Power Platform Governance and Application Care.

Result. An operations manual and a handover after which your team can run the path itself — or a solid basis for an Application Care contract.

What you provide

What the schedule depends on — and what we need from you.

What we need from you is stated up front — then it is already answered in the initial conversation instead of shifting the schedule later.

  • A Dataverse environment with change tracking on the tables that are to be included. Without change tracking enabled, a table cannot be linked — that is a product limit, not a settings question.
  • A Fabric workspace on an F capacity — or the decision which one. Building block 04 provides the proposal for that.
  • Microsoft Entra ID groups for the readership — or the willingness to create them. Individual assignments do not hold up over time.
  • Read access in the agreed scope to the Dataverse environment and the Fabric workspace.
  • A business contact who decides definitions — for example, what counts as a won opportunity.
  • A role that runs the access model afterwards. If there is none, we say so before the build and not after the handover.

An honest boundary

When Microsoft Fabric is not the right choice.

For Dataverse data, Microsoft Fabric is the strategic path. It is still not the right answer in every project. We do not recommend Fabric when:

  • You need CRM reports and not a data platform. Power BI Pro with a direct Dataverse connection covers many CRM analyses — with the advantage that users' permissions apply in Dataverse instead of being rebuilt in Fabric. A capacity costs money from day one — even before the first report delivers value.
  • You stay below F64 but have many read-only users. Then you pay for the capacity and a Pro or PPU license for every reader. That is a common miscalculation in planning — and it only shows up at rollout.
  • The data model is still moving. Every type or precision change on a synchronized column creates permanent sync errors that can only be fixed by removing and re-adding the table. Settle the model first, then link.
  • Nobody can run the access model. A lakehouse without maintained OneLake security roles is the riskier version of the status quo. If no role in the house runs the access model permanently, the honest next step is building the necessary skills and not another workspace.
  • You want to analyse attachment or document content. File content from notes is not synchronized. For that need, the path through Fabric is the wrong one.
  • This is about archiving. Microsoft states explicitly that these paths are intended for analytics; for retention, long-term data retention in Dataverse is the means.
  • This is about real-time integration between systems. An analysis path that runs up to hourly is not an integration path. Other patterns apply there — see Dynamics 365 Integration.

If one of these points applies, we say so in the initial conversation. If a Fabric architecture still makes sense afterwards, we plan the build-up of the necessary skills in the customer team as part of it — for us that belongs to Application Care and Power Platform training.

Scope boundaries

Where our work ends.

We do not take on legal assessment. We build and document access, logging and encryption configurations. Whether your processing is permissible under data protection law is assessed by your organisation or your legal advisers — we supply the technical basis for it.

We do not make license procurement decisions for you. We calculate the options against your volumes and lay them open. Procurement and contractual commitment remain your decision.

We do not take over Microsoft's product roadmap. Several mechanisms on this path are in motion: low-latency sync is being rolled out in stages, and the Delta Lake output of Azure Synapse Link is being retired. We plan against the documented state and name what is in preview. Dates and scope are set by Microsoft.

We do not run your capacity on the side. Capacity monitoring, pause plans and reacting to throttling are ongoing operational tasks. We design the plan during the project; anyone who does not want to run it themselves needs an Application Care contract for it.

We do not build workarounds for documented product limits. Where a limit exists — 2,000 tables, 200 MiB per record, one workspace per environment, no file content from notes — we say so instead of placing a construction next to it that nobody maintains.

Authority over business definitions stays with you. What a won opportunity is and which status counts towards the rate is decided by your business side. We build the logic that matches that decision and write it down.

The data path in detail

How the link works technically.

Which path Microsoft still offers for new links today, what is replicated and what is not, how the medallion layers are cut for CRM data, why your Dataverse permission model ends at the boundary to the lakehouse, and which capacity limits shape the architecture — we wrote that up as of 6 November 2026 on the basis of the Microsoft documentation: Dynamics 365 and Dataverse data in Microsoft Fabric.

Licensing models, prices, discounts and break-even points are on our page about Power BI licensing, pricing and discounts. This page here describes what we take on.

Questions and answers

What is usually still open before the first conversation.

What do you deliver in the end?

Five results, each one acceptable on its own: a running link together with the decision record, a documented access model, gold tables per business domain, an SKU proposal with verifiable arithmetic, and an operations manual with handover. The documentation stays with you and is not tied to us.

How long does a build like this take?

We only say that once we have seen the environment — a number beforehand would be guesswork. It is determined by the number of tables, the state of your data model, whether Microsoft Entra ID groups are already in place, whether an existing Azure Synapse Link path has to be replaced, and who runs the access model afterwards.

What do we have to provide?

A Dataverse environment with change tracking on the desired tables, a Fabric workspace or the decision about the capacity, Microsoft Entra ID groups for the readership, read access in the agreed scope, a business contact for definitions, and a role that runs the access model after the handover.

What does Microsoft Fabric cost?

Fabric is billed as capacity per capacity unit, pay-as-you-go or reserved, and can be obtained through an Azure subscription or through a Cloud Solution Provider — we are a CSP partner. The current Microsoft prices, the full SKU table and the break-even calculation are on our page about Power BI licensing, pricing and discounts. We calculate our own work after the environment review.

We already have an Azure Synapse Link path. What does that mean for us?

An eligible existing organisation keeps its path but has to switch to CSV output or to Link to Fabric by December 2027. That replacement belongs in building block 01 and not in a separate project afterwards. Important when changing environments: eligibility is tied to the Dataverse organisation ID, not to the tenant.

Isn't Power BI Pro enough?

Often yes — and then we say so. If you need CRM reports and not a data platform, Power BI Pro with a direct Dataverse connection covers many analyses, with the advantage that users' permissions apply in Dataverse instead of being rebuilt in Fabric. The scope section on this page names the other cases in which we do not recommend Fabric.

Do you take over operations afterwards?

Not on the side. Capacity monitoring, pause plans and reacting to throttling are ongoing tasks. We design the plan during the project; running it is available as an Application Care contract or stays with your team — for which we lay the basis in the handover.

30-min initial conversation or 45-min architecture conversation

Does the path into Fabric suit your Dynamics data — or is Power BI Pro enough?

Bring your table count, your consumer count and your permission model in Dataverse. In 30 minutes we work out whether Link to Fabric or a direct Power BI connection is the right path — and what you need for it in terms of capacity and licenses. For more complex situations, go straight to a 45-minute architecture conversation.

Accompanying services

What typically runs alongside this engineering work.

Engineering projects rarely stand alone — license logic, architecture clarification, quality gates, knowledge transfer, and follow-on operations usually run in parallel. Here are the most common accompanying services we add to Discovery Spikes, sprint fixed-price engagements, or Application Care contracts.

Up front · architecture

Advisory & Architecture

Before implementation: tenant structure, data model, security concept, integration mapping. The result is an architecture document any engineering team can pick up — including one other than us.

Up front · CSP

License Advisory & CSP

Which license bundles for which users, which add-on SKUs are needed, where you are over- or under-licensed. If you wish, you can source the licenses through us as a Microsoft Cloud Solution Provider — one invoice, one point of contact.

During · quality gate

Project Assurance

Independent second opinion during a running implementation project — whether we are delivering it or another partner. CMMI-based quality gates, risk reviews, fixed price per gate.

During · adoption

Training & learning program

Not the classic two-day workshop that's forgotten after a week — but a dynamic learning program over 4–6 weeks with kickoff training, application phases, and advanced sessions. Training matrix for roles and topics.

After · operations

Application Care

After go-live: a predictable Application Care contract with monthly flat rate, SLA-based. Includes releases, hotfixes, extensions, tenant hardening — and continuous support instead of merely reacting to tickets.

After · knowledge

Knowledge Recovery

When the original developers are gone, the previous partner is no longer reachable, or the documentation is outdated — reverse engineering of the existing solution with a documented result: code map, data model, customization inventory.