Forum Discussion
Solved
Power Query failed to parse the datetime
I am importing data from data lake gen2 with PQ and having error with some columns as below. Data in column should be in time zone format. I tried to convert it to text, datetime, datatimezone using ...
Hi Vijay, According to my further testing, it sounds like a bug of Common Data Model.
When I import data with CDM, certain datatime column will be treated as Error in Navigation step. I don't even have any chance to do any transformation to fix it. If I import with file mode, the column will be firstly detected as Text, then I can convert it to timezone by using locale without any problem.
From the error message, your values are DateTime, not DateTimeZone. If needed, you can use Date.Time.AddZone to add the timezone after you convert it to DateTime.
Pat