Missing timestamp using inline Common Data Model dataset of ADLS gen2

Achates Chen 21 Reputation points
2022-04-21T01:50:58.28+00:00

I am using inline dataset to read data from CDM in dataflow. It is strange that I found the CREATEDDATETIME and MODIFIEDDATETIME are missing value, while other fields look ok. The source data is from D365 F&O which we exported by using "Export to datalake" function. I did verify the source CSV file, timestamp is there. The purpose of the timestamp is to capture new data so I can only import new data to data warehouse.

194867-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,083 questions
0 comments No comments
{count} votes

Accepted answer
  1. MarkKromer-MSFT 5,206 Reputation points Microsoft Employee
    2022-04-21T18:17:08.797+00:00

    Did you set the date/time formats when importing the schema?

    195311-image.png


0 additional answers

Sort by: Most helpful