Getting data from Dynamics 365 Business Central to put them in Fabric

[pmscorca]

Hi,

in order to get data from a Dynamics 365 Business Central solution to put them in a Fabric lakehouse it seems that the method better is to use Dataverse between Business Central and Fabric.
I don't know how getting data from Business Central to Dataverse and if the table data load is full or incremental and if a load date or a modified date is added.
Well, any helps to me, please? Many thanks

[pmscorca]

Hi, thanks for your reply.

Using the bc2adls tool it seems a bit complex to do.

I'm trying to a recap about bringing data from a Dynamics 365 Business Central solution into a Fabric lakehouse:

1. from Dynamics 365 Business Central to Fabric --> Business Central supports native integration with Dataverse. The data loading into Datavers is a synchronization process. In Dataverse the BC tables are represented as virtual tables (similar to view concept);
2. from Dataverse to Fabric --> in Dataverse it is possible to use the Link to Fabric, that is a Power Apps feature. The data remain in Dataverse and the link is represented as a Fabric shortcut; no ETLs or copies is necessary to bring Dataverse data into Fabric, so why using a data pipeline or a dataflow gen2? A such Data Factory feature could be used after that the Dataverse data are virtually entered in Fabric to manage a full or incremental load from a first lakehouse to a second (destination) lakehouse.

Ultimately, it seems that the Business Central data remain in BC and it is important to know the existence of a modified date or a load date in order to manage an incremental load. Moreover it is important to know how BC manages the Dataverse integration (as a replica of entire tables?).

It could be useful to have a Dataverse mirroring or a Business Central mirroring in Fabric.

[v-pagayam-msft]

Hi @pmscorca ,

You are right.BC integrates with Dataverse using virtual tables, but these may not be directly used in Fabric shortcuts unless materialized. To analyze or load data incrementally, you may need to replicate the data into physical Dataverse tables.

Shortcuts work for real-time access (only with physical tables).

Use Dataflows Gen2 or Data Factory for full/incremental loads and historical tracking.

Many BC tables have LastModifiedDateTime or similar fields for incremental logic.

For true mirroring, BC data should first be materialized in Dataverse, then linked or loaded into Fabric.

Hope this helps!
Thank you.

[v-pagayam-msft]

Hi @pmscorca ,
Thank you for reaching out to us on Microsoft Fabric Community Forum!

To bring data from Dynamics 365 Business Central into a Microsoft Fabric Lakehouse, it is recommended to first integrate Business Central with Dataverse, and then ingest the data into Fabric using Dataflows Gen2 or Data Factory pipelines. Business Central supports native integration with Dataverse via the Admin Center, where core tables like Customer, Items, and Sales can be synced ,some as virtual tables. Once the data is in Dataverse, you may use Power Query or pipelines to load it into a Lakehouse. For more details, refer to these resources.
Solved: How to integrate business central data to fabric o... - Microsoft Fabric Community
Introduction to Microsoft Fabric and Business Central - Business Central | Microsoft Learn
Set up your Dataverse connection - Microsoft Fabric | Microsoft Learn
Real-time data warehousing with Microsoft Dataverse and Fabric zero-copy integration - Microsoft Pow...

Hope this helps.If so,give us kudos and consider accepting it as solution.

Regards,
Pallavi G.