Forum Discussion
Mirrored Dataverse in Fabric
- 4 months ago
Hi pmscorca,
Interesting question honestly, because the Dataverse + Fabric integration story is getting richer very quickly… but also a bit confusing sometimes with all the different concepts around, Fabric Link, Mirroring, OneLake exposure, Shortcuts, SQL endpoints Lakehouses.
As far as I know today, there is not yet a dedicated native Fabric item whose only purpose is something like "browse/query mirrored Dataverse storage directly" in the same way you might expect a standalone connector or explorer experience. That said, Fabric can absolutely consume Dataverse data natively today through different integration paths, depending on the architecture and setup.In practice, the two main paths are :
- Fabric Link (via Azure Synapse Link for Dataverse), the most stable and production-ready option today, exposes Dataverse tables as Delta tables in a Lakehouse.
- Dataverse Mirroring, currently in preview, more native Fabric experience but still evolving.
From there, Dataverse data is usually consumed through Lakehouse tables, SQL analytics endpoints, shortcuts, notebooks, or semantic models rather than through a separate dedicated "Dataverse mirrored reader" item.
So I think your idea actually makes a lot of sense
A more explicit/native experience for exploring and governing mirrored Dataverse data inside Fabric would probably make things much clearer for many users. Right now, the ecosystem is evolving pretty fast, and Microsoft seems to be progressively converging operational and analytical workloads into the same platform experience.Useful references:
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-view-in-fabric
- https://learn.microsoft.com/en-us/fabric/mirroring/overview
- https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts
- https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-overview
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/fabric-link-faq
Hope this helps clarify the current landscape a little bit
And honestly, I would not be surprised if Microsoft expands the native Dataverse/Fabric experience further over time.
Hipmscorca,
asTamanchu mentioned in his nice answer, the topic is evolving fast. By now Microsoft has added to the mention link via Synapse also a direct link. Check out this docs for more info and also a compare to the other options.
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-view-in-fabric
Best regards!