Forum Discussion
Data Format.Error We couldn't parse the input provided as date value
I have power BI dataflow and I am connecting to this via import connection. and then this goes through few steps (see snip below) When I close and apply it then pulls all data from PBI dataflow and ...
Instead of the transformation
each DateTime.FromText(_, [Format = "dd/MM/yyyy HH:mm:ss"])you could try some extra error catching like this
each try DateTime.FromText(Text.Trim(_), [Format = "dd/MM/yyyy HH:mm:ss"]) otherwise nullThe Text.Trim should help if you have extra whitespace and the try ... otherwise will handle errors.
Thanks again AlexisOlson after looking very sharply I noticed this special character in the excel files that this query connects to