Skip to main content
cancel
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

Reply
Lightice83
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

3 REPLIES 3
v-xiaotang
Community Support
Community Support

Hi @Lightice83 

Thanks for reaching out to us.

First you have to remove these two steps, 

vxiaotang_0-1666768534112.png

then select Using Locale

vxiaotang_1-1666768798359.png

vxiaotang_2-1666768895134.png

 

 

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
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

Announcements
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.