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 then throw this error below.
The dataflow has no error, I have gone through all the applied steps in pbi desktop file and the data do not show any error message etc.
as a troubleshooting step, I have removed all the DATE columns from the table from with the PBI Desktop, still it throw below error.
I have also tried the replace error and replaced the values in all date columns with a future date 31/12/2024, still getting the error,
ImkeF or ChandeepChhabra Need your expertise here on how to locate the actual file that is causing this error and how do we resolve this.
9 Replies
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.
