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

Connect to Dynamics365 from Azure Data Factory

(1) Share

Report

Posted on by BE-02061520-0

Hi All

Apologies if this is not the right forum and feel free to redirect me if necessary.

We have a Business Central Dynamics 365 setup and we’re trying to use Azure Data Flow to connect to the Dynamics system and extract data. Trying to setup the linked server in ADF and I’m getting the below error. Not sure if it’s a configuration change which need to happen on Dynamics or something which I’m missing in ADF.

The below is the error I’m getting on testing the connection.

Input Payload is invalid, validation result - '[/Connector or activity name: Dynamics_Connector, connector or activity type: Dynamics, error: The domain of this endpoint is not in allow list. Original endpoint: 'businesscentral.dynamics.com'/]'

Service url: https://businesscentral.dynamics.com/xxxxxxxx-bxxx-xxxx-9xxx-xxxxxxxxx0/xxxxxxxxxxod
Authentication: Using my personal credentials.

Any hints would be greatly appreciated!

Regards
Brian

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (2)

Report

Hi, as far as I know, this standard Connector is used by CRM (Sales, customer service, etc.). For BC, you need to use Odata or API to connect.

Hopefully other experts can give you better advice.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (2)

Report

Yun Zhu is correct, you have to use odata/api. Hope this helps as well :

Extract data from Business Central - Business Central | Microsoft Learn
How to connect Business Central to Azure Data Factory - Microsoft Q&A

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No

Join the conversation

Community site session details

Connect to Dynamics365 from Azure Data Factory

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Connect to Dynamics365 from Azure Data Factory

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates