Failed to import datetime string from .csv file

thomasdang — Wed, 11 Oct 2023 04:26:21 GMT

Hello PowerBI Experts,

We have a .csv files which contains header line and a datetime field such as:

OrderID, CreateDate, ItemName

123456, 2023-10-04 19:48:47.123456, ApplePie

When I tried to import this .csv file (from AWS S3) into my DW via creating a new "Data pipeline (Preview)", in the step "Connect to data destination", I specify the OrderDate as Datetime, and the destination field name as "CreateDatetime". When I execute it, I got the following error:

ErrorCode=UserErrorSqlDWCopyCommandError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=SQL DW Copy Command operation failed with error 'Column 'CreateDatetime' of type 'DATETIME2' is not compatible with external data type 'Parquet physical type: BYTE_ARRAY, logical type: UTF8', please try with 'VARCHAR(8000)'.

I tried to change the date field in different formats such as:

2023-10-04 19:48:47

2023-10-04T19:48:47

2023-10-04T19:48:47.123456

...

but still getting the same error.

Would you please help? Thanks so much!

topic Failed to import datetime string from .csv file in Developer

Failed to import datetime string from .csv file