cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abbytank
Frequent Visitor

Date Data format error

Hi everyone,

 

While trying to import data source from excel with the following data:

 

ProductKeyCustomerKeySales_DateQuantity
22331906912/6/20221
1872164612/6/20221
1872164512/6/20221
1872163812/6/20221
1872163512/6/20221
1081906312/6/20221
17031768516/6/20221
17031768416/6/20221
17031756816/6/20221
17031756716/6/20221
17051320119/5/20221
17051320019/5/20221

 

The power query is showing the following error:

DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
29/2/2021

 

Here is what I did, I have changed the data type using locale with data types of English(UK) sample: 29/03/2022 and English(US) sample: 03/29/2022, none helped.

 

I have also, splitted the column to three columns and remerged, and still not working. 

 

Please help.

 

Thank you in advance.

1 ACCEPTED SOLUTION
serpiva64
Super User
Super User

Hi,

you have a problem in your data.

2021 is not a leap year so you can't have 29/2/2021 and that's the cause of the error

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

View solution in original post

1 REPLY 1
serpiva64
Super User
Super User

Hi,

you have a problem in your data.

2021 is not a leap year so you can't have 29/2/2021 and that's the cause of the error

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors