Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

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

Power Query.PNGPower BI Editor.PNG

Community Support
Community Support

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.

Helper I
Helper I

Can you try Change Type -> Using Locale...01pxcUkbO0.pngUoymtUsVQG.png

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



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors