Forum Discussion
Can Dynamics 365 Finance data be queried in Fabric using metadata mirroring?
Super UserDescription / 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
Super UserHello @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