Dateformat.error We couldn't parse the value as DateTime Value (Works in PQ but broke in PBI)

[Lightice83]

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

[v-xiaotang]

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.

[gdbaerg]

Can you try Change Type -> Using Locale...

[Lightice83]

@gdbaerg  Thanks but unfortunately doesn't work as both my source data & locale data are in DD/MM/YYYY