topic Databricks to Dataverse migration via ADF copy data in Data Engineering

Databricks to Dataverse migration via ADF copy data

DivyaKumar — Fri, 03 Oct 2025 12:16:13 GMT

Hi team,

I need to load data from databricks delta tables to dataverse tables and I have one unique id column which I am ensuring via mapping. Its datatype is GUID in dataverse and string in delta table. I ensured that column holds unique values. Since this data type conversion is not happening via single copy data activity with source as databricks and sink as dataverse, I split the copy data into 2 - one from databricks to ADLS and other from ADLS to dataverse. databricks to ADLS worked fine. second copy data is done with upsert logic and mapping also done, but it throws error as below:

"ErrorCode=TypeConversionFailure,Exception occurred when converting value '7c820e84-Oce8-4ce6-aeOa-f25501c3399e' for column name 'xxx' from type 'String' (precision:-1, scale:-1) to type 'Guid' (precision:, scale:). Additional info: Could not find any recognizable digits."

please help how to solve

Re: Databricks to Dataverse migration via ADF copy data

-werners- — Fri, 03 Oct 2025 12:34:38 GMT

That is not a valid guid.
Dataverse will check this.

http://guid.us/test/guid

Re: Databricks to Dataverse migration via ADF copy data

reddyharsha — Wed, 11 Feb 2026 13:04:17 GMT

Hi ,
Can you please let me know how we can load the data from data bricks gold to dataverse with optimized way.
currently we are experiencing performance issue with Web API.
can you please let me know the approach so we can load millions of records in less time.