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!
