using On Prem Dynamics 365 gives an error (MissingRequiredPropertyException: baseUrl is a required property) in the dataflow but not in the dataset or linekd service

Question

• Created a linked Service to Dynamics365 with the Dynamics365 connector (with IFT)
• Tested the connection: Succeeded
• Created a Dataset nased on that Linked Service: Test Connection: Succeedes and I Can see data.
• Use the dataset in a Copy Data : seems to work
  But
• Use this dataset in a Dataflow gives me this error:

Connection failed
Spark job failed: {
"text/plain": "{\"runId\":\"7e5effb7-3390-42d2-b979-68b6a255dc9d\",\"sessionId\":\"5d8ea97d-f9ce-4a5b-ac4b-75279be025ab\",\"status\":\"Failed\",\"payload\":{\"statusCode\":400,\"shortMessage\":\"com.microsoft.dataflow.broker.MissingRequiredPropertyException: baseUrl is a required property for DynamicsCrmSandpit.\ncom.microsoft.dataflow.broker.PropertyNotFoundException: Could not extract value from DynamicsCrmSandpit\",\"detailedMessage\":\"Failure 2022-06-22 12:07:40.256 failed DebugManager.processJob, run=7e5effb7-3390-42d2-b979-68b6a255dc9d, errorMessage=com.microsoft.dataflow.broker.MissingRequiredPropertyException: baseUrl is a required property for DynamicsCrmSandpit.\ncom.microsoft.dataflow.broker.PropertyNotFoundException: Could not extract value from DynamicsCrmSandpit\"}}

Any ideas ?

Rob

Answer 1

Hello @Rob Joosen ,
Apologies for the late reply from our side .
As we understand the ask here is why the On Prem Dynamics 365 works fine in copy activity but does not work in the Mapping data flow , please do let us know if it’s not accurate.While working with the On prem Dynamics with copy activity , I am sure that you are using Self hosted integration runtime ( SHIR ) which helps us connect the on prem to cloud .
Mapping data flow does not support SHIR and hence the error .
This is called out here : https://learn.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime#integration-runtime-types

Dataflow only supports Azure IR type and not Self hosted .

Below is feature requests logged in feedback forum and I request you please go and upvote or comment on the same .
https://feedback.azure.com/d365community/idea/8991a891-6d26-ec11-b6e6-000d3a4f032c

Please do let me know if you have any queries.
Thanks
Himanshu

---

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

Hi @Rob Joosen ,

AFAIK Dynamics 365 is currently not supported in this Microsoft Q&A platform. These are the products that are currently supported in this Microsoft Q&A platform. You may ask Dynamics 365 related questions in this community.