Forum Discussion
Post ProdigyImporting data from a Dynamics 365 Business Central solution into Fabric by a direct connection
Community SupportHi 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
Post ProdigyHi, 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.