Small and medium business | Business Central, N...

Connect the Dynamic 365 Business Central table in to Microsoft fabric

(4) Share

Report

Posted on by KP-08080536-0

I want to know is there way to connect for Microsoft dynamics 365 business central tables in to Microsoft Fabric or Azure data lake without using APIs or Odata?

If not what are the method of APIs that can be create?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (1)

Report

You can try this

https://www.bertverbeek.nl/blog/2024/04/29/from-business-central-to-dataverse-to-fabric/

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://community.fabric.microsoft.com/t5/Service/How-to-integrate-business-central-data-to-fabric-onelake/m-p/4086755

Was this reply helpful? Yes No
Suggested answer

KP - Solution Archi... 658 on at

Like (0)

Report
Hi @KP-08080536-0,

You can try with the below option

Use the OData URL from Business Central

In Fabric, create a new Dataflow.

Choose OData Feed as the source.

Enter the URL from BC (https://api.businesscentral.dynamics.com/v2.0/{tenant}/sandbox/ODataV4/Company('CRONUS%20USA%20Inc.')/Customer).

Authenticate and load the data.

Was this reply helpful? Yes No