Forum Discussion

jmiliani74's avatar
jmiliani74
Frequent Visitor
6 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
Olufemi7's avatar
Olufemi7
Icon for Super User rankSuper User
6 months ago

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: