Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Connect to Dynamics365 from Azure Data Factory

(1) ShareShare
ReportReport
Posted on by 4
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
  • Suggested answer
    Valentin Castravet Profile Picture
    27,988 Super User 2025 Season 1 on at
    Connect to Dynamics365 from Azure Data Factory
  • Suggested answer
    YUN ZHU Profile Picture
    81,912 Super User 2025 Season 1 on at
    Connect to Dynamics365 from Azure Data Factory
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,351 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,029 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans