Forum Discussion

lovishsood1's avatar
lovishsood1
Copper Contributor
Feb 03, 2025

OData Connector for Dynamics Business Central

Hey Guys,

 

I'm trying to connect Dynamics Business Central OData API in ADF but I'm not sure what I'm doing wrong here because the same Endpoint is returning data on Postman but returning an error in ADF LinkedService.

https://api.businesscentral.dynamics.com/v2.0/{tenant-id}/Sandbox-UAT/ODataV4/Company('company-name')/Chart_of_Accounts

 

 

azure data factory
Azure ETL
Azure Integration Runtime
Copy Activity
Linked Service

2 Replies

  • rajeshgan's avatar
    rajeshgan
    MCT
    Aug 24, 2026

    Since the same Business Central OData V4 endpoint is returning data successfully in Postman, I would first compare the authentication used in Postman with the authentication configured in the ADF Linked Service.

     

    For Business Central SaaS, I would recommend using Microsoft Entra ID/OAuth authentication rather than relying on legacy authentication methods.

     

    A few areas worth checking:

    • Confirm that the tenant ID and Business Central environment name used in the OData URL are correct.
    • If ADF is using a service principal, ensure that the Microsoft Entra application is also configured in Business Central under Microsoft Entra Applications and has the required Business Central permission sets.
    • Verify that the ADF Linked Service is requesting authentication against the correct Microsoft Entra tenant.
    • Test the OData service root first before testing the company-specific endpoint. This can help determine whether the failure is occurring during authentication or while accessing the published Business Central web service.
    • Also check whether the company name contains characters/spaces that require URL encoding.

     

    Since Postman is already working, I would especially compare the access token/authentication configuration between Postman and ADF. If you can share the exact error returned by the ADF Linked Service test connection, it should be possible to narrow this down further.

  • dfkconsult's avatar
    dfkconsult
    Brass Contributor
    Feb 24, 2025

    Checkout these posts

     

    https://learn.microsoft.com/en-us/answers/questions/1538522/how-can-i-connect-to-bc-using-adf-with-odata-api

    https://learn.microsoft.com/en-us/answers/questions/1858160/business-central-connector-for-azure-data-factory

    https://community.dynamics.com/forums/thread/details/?threadid=ddd7a24f-654e-4f02-b656-c0772a55e8bd

    https://www.encorebusiness.com/blog/how-to-use-an-odata-connection-with-service-principal-authentication-for-dynamics-365-business-central/

    https://stackoverflow.com/questions/76411322/how-to-use-azure-data-factory-to-take-business-central-data-and-put-into-azure-s

    https://www.linkedin.com/pulse/azure-data-factory-configure-linked-service-business-central-nguyen-6ga7c