Importing data from a Dynamics 365 Business Central solution into Fabric by a direct connection

[pmscorca]

Hi,

I need to evaluate a possible manner to import data from a Dynamics 365 Business Central solution into Fabric using a direct connection between two these platforms.

This mode should be as better as possible solution in terms of performance and costs.

I've noticed that Fabric has two connectors, Dynamics 365 and OData ones.

Could implementing a data pipeline using Dynamics 365 connector as a source be a very good solution by a direct connection?

I think that it should be a very good thing having a major and direct integration between Microsoft Dynamics 365 Business Central and Microsoft Fabric!

Any helps to me, please? Thanks

[v-hashadapu]

Hi @pmscorca , Thank you for reaching out to the Microsoft Community Forum.

No, you cannot use the Dynamics 365 connector in Microsoft Fabric for a direct connection to Business Central unless your Business Central data is explicitly synced to Dataverse and even then, the integration is limited to a small set of entities like customers and contacts. This is because the Dynamics 365 connector is designed for Dataverse-based apps like Dynamics 365 Sales, not Business Central’s native tables.

The only officially supported and direct integration method today is via the OData connector, using Business Central's published OData endpoints. This allows you to connect pipelines or notebooks in Fabric to BC, but it comes with performance limitations, especially around throttling, paging and data volume.

For better performance or large-scale ingestion, the most flexible and scalable approach is to use a notebook in Fabric with Python or Spark to connect directly to the Business Central APIs. This gives you full control over paging, filtering and batch logic while maintaining a cost-efficient pipeline.

OData Web Services - Business Central | Microsoft Learn

Set up your OData connection - Microsoft Fabric | Microsoft Learn

API (v2.0) for Dynamics 365 Business Central - Business Central | Microsoft Learn

Integrating with Microsoft Dataverse - Business Central | Microsoft Learn

Connect to Microsoft Dataverse - Business Central | Microsoft Learn

Integrate with Microsoft Dataverse via data sync - Business Central | Microsoft Learn

[pmscorca]

Hi, thanks for your reply.

It could be very useful to have a mirroring feature for implementing a direct connection between BC and Fabric.

[v-hashadapu]

Hi @pmscorca , A mirroring feature to enable a direct connection between Business Central and Microsoft Fabric would indeed add significant value. I recommend submitting this idea to the Microsoft Fabric Ideas, this is the best way to influence future updates. Microsoft actively reviews community feedback when planning new features, so your input could help shape upcoming developments in Fabric. Make sure to get as many upvotes as possible.

[pmscorca]

Hi, thanks there is already a such idea that I've voted, here
Mirroring from Dynamics 365 Business Central into ... - Microsoft Fabric Community
This idea needs votes.
It seems strange that there isn't a direct integration between two Microsoft platforms, isn't it?

[v-hashadapu]

Hi @pmscorca , Thanks for the update. Hope it gets implemented as a feature soon.