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
gdbaerg's avatar
gdbaerg
Icon for Helper I rankHelper I
3 years ago

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

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

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