Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.