Forum Discussion
Dateformat.error We couldn't parse the value as DateTime Value (Works in PQ but broke in PBI)
I created a table with dates in Excel & added to Power Query/Data Model which I imported into PBI
In PBI it is stating an error in the Query Editor being 'Dateformat.error We couldn't parse the value as DateTime Value'. It worked for a while but broke after I refreshed the data
There are no spaces etc on the source dates
FYI - My locale is Australia & hence the DD/MM/YYYY format
3 Replies
Can you try Change Type -> Using Locale...
gdbaerg Thanks but unfortunately doesn't work as both my source data & locale data are in DD/MM/YYYY
Hi Lightice83
Thanks for reaching out to us.
First you have to remove these two steps,
then select Using Locale
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
