DataFormat.Error: We couldn't parse the input provided as a Date value

[Kianzad]

Hello guys,

I am very confused as to why I keep getting this error. I have received a xlsx file with lots of data, upon loading the data PowerBI correctly recognizes two date columns and changes them into the date format. This doesn't seem to cause any problems at first glance, but when I hit apply I get this error that there were 11 columns with errors. I can see that the only error I get is on the date 29-02-2021 - all other dates get in just fine. At first I thought it was because it assumed I was using an american calendar and that there is no 29th month, however 18-02-2022 works just fine. Does anyone have an idea as to why 29-02-2021 doesn't work as a date format? This is the only date that seems to be causing me an error, and within the original data file there is no difference between these rows and other rows in terms of format.

[Mehul · Accepted solution]

Its b/c 2021 is NOT a leap year hence no 29 days for Feb.

[Kianzad]

Thanks alot Mehul,

I realize that there is some errors in the data that I've been provided!