question

rguerraalmeida avatar image
0 Votes"
rguerraalmeida asked HimanshuSinha-MSFT commented

Dataverse Export to DataLake 2 - columns createdOn and updatedOn with no values

Hello, we have an export from a Microsoft Dynamics Dataverse to an Azure Data Lake Gen 2 container, both cloud based, that subsequently will be used in a Data factory linked service.

We have no control over the Export or the columns exported, and we realized that the createdOn and modifiedOn columns on the produced .csv don't have a single value exported.

Is this a bug ? Can someone help us out why this is happening ?

Thanks in advance.

azure-data-factoryazure-data-lake-storage
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @rguerraalmeida ,
Thanks for the ask and using the Microsoft Q&A platform .
At this time, we are reaching out to the internal team to get some help on this . We will update you once we hear back from them.
Thanks
Himanshu

0 Votes 0 ·

Hello @HimanshuSinha-MSFT, thanks for the quick reply, let me give you an update since i'm still solving this issue, but its not related to the export from dataverse, but the parsing of dates in the data factory from a inline dataset. Since i didnt have access to the proper model.json i made a mistake analysing the columns in the .csv, and i can say now that the export is being done correctly.

As said i'm still investigating the why of sometimes not parsing all date format on the data factory, but the problem lies elsewhere.

Again thanks for the quick reply.

0 Votes 0 ·

Hello @rguerraalmeida ,
Good to hear back from you , let me know how it goes .
Thanks
Himanshu

0 Votes 0 ·

0 Answers