topic Can Dynamics 365 Finance data be queried in Fabric using metadata mirroring? in Data Engineering

Can Dynamics 365 Finance data be queried in Fabric using metadata mirroring?

jmiliani74 — Thu, 05 Mar 2026 09:25:40 GMT

Description / Problem Statement

Hello everyone,

I’m currently working on an analytics architecture involving Dynamics 365 Finance & Operations (F&O), Dataverse, and Microsoft Fabric, and I’d like to clarify whether a specific integration scenario is currently supported or on the roadmap.

Context

Dynamics 365 F&O exposes its data through Dataverse, where F&O entities typically appear as virtual tables.
When using Link to Microsoft Fabric (Fabric Link), only physical Dataverse tables with change tracking enabled are supported.
As a result, to make F&O data available in Fabric today, it is usually necessary to:
- Materialize F&O entities into physical Dataverse tables
- Enable change tracking
- Accept additional Dataverse storage consumption, since Dataverse generates Delta/Parquet replicas

This approach works, but it introduces:

Extra Dataverse storage costs
Data duplication (operational data being materialized purely for analytics)
Additional operational complexity

What I’m trying to understand

Microsoft Fabric supports different mirroring approaches, including metadata mirroring (shortcut-based access), where:

Data remains in the source system
No physical copy is written into OneLake
Fabric queries data through metadata/shortcuts only

Given this, my questions are:

Is it currently possible (or planned) to connect Dynamics 365 F&O tables to Fabric using a metadata-only mirroring approach, similar to how shortcuts work for other platforms, without materializing data into Dataverse storage or OneLake?
Has Fabric (or Dataverse) considered supporting F&O virtual tables directly, so they could be queried from Fabric without requiring physical Dataverse tables and Delta replication?
Some community discussions suggest that Dataverse-based replication might no longer be the optimal long-term approach for large F&O analytical workloads.
- Is there any official guidance or roadmap indicating a shift toward a different integration pattern (e.g., direct metadata mirroring or another Fabric-native approach)?

Re: Can Dynamics 365 Finance data be queried in Fabric using metadata mirroring?

Murtaza_Ghafoor — Sun, 08 Mar 2026 07:03:08 GMT

Description / Problem Statement

I’m currently working on an analytics architecture involving Microsoft Dynamics 365 Finance & Operations, Microsoft Dataverse, and Microsoft Fabric, and I would like to clarify whether a specific integration scenario is currently supported or planned on the product roadmap.

Short Answer:
Today there is no native way to directly expose Dynamics 365 F&O virtual tables from Dataverse to Microsoft Fabric using Fabric Link for Dataverse.

Fabric Link supports only physical Dataverse tables that have change tracking enabled, not virtual tables.

Work around

Yes it is possible, in my current assignment, instead of going for the mirroring or synapse link, what i did i created a external table shortcuts in fabric lakehouse and from there i queries dynamic F&O data in Lakehouse SQL Endpoints.

If this helps, ✓ Mark as Kudos | Mark as Solution| Help Others

Re: Can Dynamics 365 Finance data be queried in Fabric using metadata mirroring?

Olufemi7 — Tue, 10 Mar 2026 00:26:00 GMT

Hello @jmiliani74,

No, Dynamics 365 F&O virtual tables cannot be queried directly in Microsoft Fabric using metadata-only mirroring. Fabric Link supports only physical Dataverse tables with change tracking, so you must materialize virtual tables or use ETL pipelines to access F&O data in Fabric. No public roadmap currently indicates support for direct metadata-only queries.

References:

Re: Can Dynamics 365 Finance data be queried in Fabric using metadata mirroring?

Murtaza_Ghafoor — Tue, 10 Mar 2026 20:44:22 GMT

Hello @jmiliani74,
Did you try this option ?

Work around

If this helps, ✓ Mark as Kudos | Mark as Solution| Help Others

Re: Can Dynamics 365 Finance data be queried in Fabric using metadata mirroring?

v-prasare — Fri, 13 Mar 2026 08:49:14 GMT

Hi @jmiliani74,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

Re: Can Dynamics 365 Finance data be queried in Fabric using metadata mirroring?

v-prasare — Mon, 16 Mar 2026 09:59:39 GMT

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

Re: Can Dynamics 365 Finance data be queried in Fabric using metadata mirroring?

jmiliani74 — Tue, 17 Mar 2026 16:42:41 GMT

Hello ,

could you share an example of this kind of configuration with Dynamics FO ? please

Best regards,

Re: Can Dynamics 365 Finance data be queried in Fabric using metadata mirroring?

v-prasare — Mon, 23 Mar 2026 10:50:17 GMT

Hi @jmiliani74,
You can’t set up external table shortcuts directly for Dynamics 365 F&O data. Fabric Lakehouse shortcuts work only after the data is exposed through a supported source (such as external storage or physical Dataverse tables). The shortcuts documentation explains how shortcuts work in general, but it does not provide an F&O‑specific or end‑to‑end setup, nor does it enable direct access to F&O virtual tables.

Thanks,
Prashanth