Forum Discussion

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

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

3 Replies

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
  Super User
  7 years ago
  Hi Anonymous ,
  It showed error in the power query itself.
v-yulgu-msft
Microsoft Employee
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

Related content