Failed to import datetime string from .csv file

[thomasdang]

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!