Forum Discussion

Arul's avatar
Arul
Super User
7 years ago
Solved

Error in date column

Hi, I got the below error in my date column of my dataset. Any help would be aprreciated. DataFormat.Error: We couldn't parse the input provided as a Date value. Details: 13/04/18 Thanks, -Arul...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Arul ,

     

    Remove the last "Changed type" step under "Applied steps" list. Right click the date column, choose "Change Type"->"Using locale", then, select the right locale which displays the matched date format.

     

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Did you check the format date of your Power BI? Depend on the region is dd/MM/YYYY or MM/dd/YYYY.

Arul's avatar
Arul
Super User
7 years ago

Hi Anonymous ,

It showed error in the power query itself.