Forum Discussion

Lightice83's avatar
Lightice83
Icon for Helper I rankHelper I
3 years ago

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 v...
Need Help
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
3 years ago

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.