Back to Blog
Published:
Last Updated:
Recently Updated
ERP Write-Back & IntegrationChapter 16

What happens when you unlink Dynamics 365 from Microsoft Fabric?

4 min read
846 words
high priority
Mudassir Marwat

Mudassir Marwat

Founder & CEO, Cognilium AI

TL;DR

Unlinking deletes the Fabric lakehouse, and everything built on it goes too. What to check before anyone treats it as a reversible setting.

Unlinking deletes the Fabric lakehouse. It does not detach the link and leave the data sitting where it was. The lakehouse goes, and anything that depended on it goes with it.

That is the whole answer, and it is worth stating plainly because the word "unlink" implies something reversible and the operation is not.

Why the wording misleads

Every other integration in this area can be turned off and turned back on. A Synapse Link profile can be paused. A dual-write map can be stopped. An OData integration is a client that you can simply stop calling. Nothing is destroyed in any of those cases, so the pattern people carry into Fabric is that a link is a switch.

Link to Microsoft Fabric is not a switch, because the lakehouse it created is not somewhere your data was copied to. Dataverse holds the managed OneLake store, and Fabric holds shortcuts into it. Remove the relationship and the Fabric-side object that existed only to express that relationship is removed too.

The data itself is still in Dataverse. The lakehouse is not.

What goes with it

The lakehouse is rarely the only thing that has been built. By the time anyone considers unlinking, there is usually a layer on top:

  • The SQL analytics endpoint that Fabric provisioned alongside the lakehouse.
  • The default Power BI semantic model, and any report bound to it.
  • Notebooks, pipelines and dataflows that reference the lakehouse tables.
  • Downstream shortcuts from other workspaces pointing at it.
  • Anything parsing the lakehouse name, which brings its own problem.

That last one is worth a separate warning. Microsoft states explicitly that you should not take a dependency on the generated lakehouse name. It carries environment, profile and workspace segments and is not stable. A pipeline that resolves the lakehouse by display name is already fragile before anyone unlinks anything; reference workspace and lakehouse by ID instead. A large share of the example pipelines in circulation do the opposite.

When unlinking is still the right call

It often is. Environments get rebuilt, a proof of concept in the wrong workspace needs moving, a profile was configured against the wrong Fabric capacity, or the CSV-format history of an older Synapse Link profile means it cannot be linked to Fabric at all and a clean start is simpler.

The point is not to avoid the operation. It is to treat it as a rebuild rather than a toggle, and to know what has to be recreated before you begin rather than discovering it from a broken report.

What to check first

List what references the lakehouse. Notebooks, pipelines, semantic models, and shortcuts from other workspaces. This is the list you will have to recreate, and it is always longer than expected.

Find anything that resolves by name. If it exists, fix it now regardless of whether you unlink, because the name is unstable on its own terms.

Export the modelling, not the data. The data comes back on the next sync. The semantic model definitions, measures and relationships do not, unless someone saved them.

Confirm the re-link prerequisites still hold. Relinking needs the same conditions the first link needed: System Administrator in the Power Platform environment, Power BI workspace admin, and Power BI Premium or Fabric capacity in the same Azure geography as the Dataverse environment. If any of those changed since the original setup, the rebuild stalls at a permissions error rather than at the point you planned for.

Budget the resync time. The initial conversion to Delta/Parquet runs up to an hour and longer for large tables. That is downtime for everything reading the lakehouse, not a background task.

The general lesson

Managed services remove work by owning objects on your behalf, and the objects they own are the ones they can also remove. That is the trade, and it is usually a good one. The failure mode is assuming an object you can see in your own workspace is therefore yours to keep.

Before anyone runs an operation on a managed integration, the useful question is not "can I undo this" but "what does this service own, and what does it do with what it owns when the relationship ends".

Share this article

The work behind this series

Six patterns, and the four published limits that actually decide which one survives production — service protection, OData throughput, business-event ordering and recurring-integration redelivery.

Mudassir Marwat

Mudassir Marwat

Founder & CEO, Cognilium AI

Mudassir Marwat's argument is that ERP systems record decisions they never optimise.

Founder & CEO of Cognilium AI; 37 AI agents in production across four products; 4 production AI products built and operated; three clouds in production (AWSGCPAzure)
Agentic AIRAG → GraphRAG retrievalVoice AIMulti-Agent Orchestration
In short

Key takeaways

  • Unlinking Dynamics 365 from Microsoft Fabric deletes the Fabric lakehouse rather than detaching it.
  • The source data remains in Dataverse; the Fabric-side lakehouse, SQL analytics endpoint and default semantic model do not.
  • Notebooks, pipelines, reports and cross-workspace shortcuts that reference the lakehouse all break.
  • Microsoft says not to depend on the generated lakehouse name, which is unstable; reference by workspace and lakehouse ID.
  • Relinking needs the original prerequisites to still hold, and the initial resync can take an hour or more.
What goes wrong

Common mistakes to avoid

  • Treating unlink as a reversible toggle because every neighbouring integration behaves that way.
  • Unlinking without an inventory of what references the lakehouse.
  • Relying on the lakehouse display name in pipelines, which is fragile before any unlink and broken after one.
  • Assuming semantic models and measures return with the data on relink.
  • Planning the resync as a background task rather than as downtime for everything reading the lakehouse.

Frequently Asked Questions

Find answers to common questions about the topics covered in this article.

No. The source data stays in Dataverse and in the ERP. What is deleted is the Fabric lakehouse, which was an expression of the link rather than an independent copy you owned.
Not through unlinking, which removes the lakehouse. If the goal is to stop the data moving while keeping what has been built, the question to answer first is whether what you need to keep is the lakehouse itself or the modelling on top of it. The second can be preserved independently; the first cannot.
Plan on the initial sync and Delta/Parquet conversion running up to an hour, and longer for large tables. Steady-state refresh then runs on a similar cycle. Everything reading the lakehouse is unavailable until the first pass completes.
Do not rely on it. Microsoft explicitly says not to take a dependency on the generated name. Anything you rebuild should reference workspace and lakehouse by ID.
Azure Synapse Link for Dataverse writes Delta-Parquet into an ADLS Gen2 storage account you provision, so the storage is yours and stopping the profile does not delete it. That is a different trade, with a storage account to manage, and it is the right one when ownership of the destination matters more than the operational saving.

Still have questions?

Get in touch with our team for personalized assistance.

Contact Us

Still have a question this did not answer?

The person who wrote this article answers these. Describe your setup and what you are stuck on — you will get a straight answer, including where we think the approach is wrong.

Related Articles

Continue exploring related topics and insights from our content library.

12 min
1
Mudassir Marwat
August 1, 2026

Your optimizer is only as good as its write path. How should it read and write Dynamics 365?

Microsoft's integration overview for finance and operations apps publishes six integration patterns, and two of those six rows are containers holding several documented surfaces each. This is the map an IT buyer should hold before any companion app touches the ERP — what each surface is for, which limits are actually enforced today, what a read costs versus a write, and the thirteen narrower questions underneath this one.

words
Read Article
9 min
2
Mudassir Marwat
August 1, 2026

Why does your OData integration slow down at a few thousand records an hour?

Microsoft's own integration sizing examples put OData at a peak data volume measured in records per hour, and the batch data API examples two orders of magnitude above it. Here is the table Microsoft publishes, the caveat it attaches, the validate chain that explains the number, and the four OData behaviours that make a working integration slower or quietly wrong.

words
Read Article
9 min
3
Mudassir Marwat
August 1, 2026

Which Dynamics 365 service protection limits are actually enforced?

The three limits Dataverse actually enforces per user per server, what happens when you cross one, and why a retry loop makes it worse.

words
Read Article

Explore More Insights

Discover more expert articles on AI, engineering, and technology trends.

Personalized for You

Curated content recommendations based on your current reading and interests.

Trending
120%

Does row-level security carry from Dynamics 365 into Fabric?

Same topic cluster: ERP Write-Back & Integration
Same author: Mudassir Marwat

It does not. Extensible data security is bypassed for Synapse Link, so lakehouse access shows every legal entity and cost price. What to rebuild.

Mudassir Marwat
5 min read
ERP Write-Back & Integration
Read Article
Trending
42%

Does Dynamics 365 match product receipts to invoices automatically?

High priority content
Related topic cluster: Procure-to-Pay Agent Operations

Yes, in the background, hourly or daily, where a three-way policy exists. It also has a retry limit, so some lines stop being tried altogether.

Ali Ahmed
5 min read
Procure-to-Pay Agent Operations
Read Article
Trending
120%

Where does the storage bill land for Link to Microsoft Fabric?

Same topic cluster: ERP Write-Back & Integration
Same author: Mudassir Marwat

Not on Azure. Fabric link storage is charged to Dataverse capacity and shows up in the Power Platform admin center, where nobody is looking.

Mudassir Marwat
4 min read
ERP Write-Back & Integration
Read Article
Trending
109%

Business events give you no ordering guarantee. What do you build instead?

Same topic cluster: ERP Write-Back & Integration
Same author: Mudassir Marwat

Microsoft states it under a heading called Limitations - the order in which Finance and Operations emits business events isn't guaranteed to preserve the order in which they're delivered. The control number is a dedupe key, not a sequence. So you build consumers that are idempotent, derive state from the record rather than the event sequence, and reconcile against the ERP rather than against the event stream.

Mudassir Marwat
8 min read
ERP Write-Back & Integration
Read Article
Trending
109%

Is BYOD retired?

Same topic cluster: ERP Write-Back & Integration
Same author: Mudassir Marwat

Microsoft's transition FAQ answers this under its own heading, on a page revised in July 2026 — a retirement date for BYOD hasn't been determined, and Microsoft recommends transitioning in the same sentence. Both halves are the answer. Here are the five Microsoft pages checked, the four dates Microsoft documents for Export to Data Lake, why any single-date summary of it is wrong, and why a bounded no is still not a reason to stay.

Mudassir Marwat
8 min read
ERP Write-Back & Integration
Read Article
Trending
109%

Why do your data events never fire for some entities?

Same topic cluster: ERP Write-Back & Integration
Same author: Mudassir Marwat

Microsoft names the class exactly - when a data entity uses a view as its primary data source, data events don't trigger. Not all views, not all entities - the entity's primary data source. This article gives Microsoft's wording and its stated reasons, the separate temporary-table case that raises an error instead of staying silent, and the published throughput figures that Microsoft says the environment does not explicitly throttle.

Mudassir Marwat
8 min read
ERP Write-Back & Integration
Read Article

Smart Recommendations

Our AI analyzes topic clusters, author expertise, and content relationships to surface the most relevant articles for you.

Topic Matching
Author Expertise
Content Quality
Personal Interests

Questions on this?

Talk to an engineer

Schedule a call