Forum Discussion
Data Format.Error We couldn't parse the input provided as date value
It might be due to the cultural settings for the date interpretation. I'd recommend explicitly setting a culture value all of your Changed Types steps that involve a date. For example, using "en-IN" should interpret dates as "dd/mm/yyyy" instead of "mm/dd/yyyy".
https://docs.microsoft.com/en-us/powerquery-m/table-transformcolumntypes
See if this makes any difference.
Hi AlexisOlson Thanks for your reply, tried your suggestion, still getting the error, even tried to split this date column with / and into Day/Month/Year and later merged it converted to date no erros until the final step, as soon as I hit close and apply in query editor, it then loads all data (approx 39 MB) from PBI dataflow and throw this error, (Data Frrmat Error)
Is the error coming from one of the tables you're merging in (e.g. dimDates)? You might need to try a similar correction on those queries.
Thanks AlexisOlson Yes I have tried similar transformation on all tables being used in Merge for eg: (factRiskRegister, Dimdates) see below snip for the transformation applied and still the error pops up on Closed Date column,
Clicking on the error in power query inidicates there values shown in snip2
tried everything I could like split columns by delimiter, and then later merged them back to remove the time component from the column, but then when I close and apply the refresh fails
OK. Try using manual transformations that specify the format exactly.
For example, instead of the Changed Type with Locale step, try this instead:
= Table.TransformColumns( #"Previous Step Name", {{"DateCol", each DateTime.FromText(_, [Format = "dd/MM/yyyy HH:mm:ss"]), type datetime}} )