Forum Discussion

jmiliani74's avatar
jmiliani74
Frequent Visitor
7 months ago

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

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 ...
data engineering
data pipeline
lakehouse
Murtaza_Ghafoor's avatar
Murtaza_Ghafoor
Icon for Super User rankSuper User
7 months ago

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's avatar
jmiliani74
Frequent Visitor
6 months ago

Hello , 

 

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

 

Best regards, 

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support
    6 months ago
    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