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.
Actually, you might be better off using DateTimeZone.FromText, and using the optional formatting record [Format="dd MM yyyy HH:mm:ss.ffffff zzz", Culture="de-DE"])
--Nate