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

[jmiliani74]

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:

1. 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?

2. 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?

3. 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)?

[v-prasare]

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

[v-prasare]

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

[Olufemi7]

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:

• Link Dataverse to Microsoft Fabric

• Fabric Link FAQ

• Change tracking for F&O virtual tables

[Murtaza_Ghafoor]

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

[jmiliani74]

Hello , 

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

Best regards, 

[v-prasare · Accepted solution]

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

[Murtaza_Ghafoor]

Hello @jmiliani74,
Did you try this option ?

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