Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
While trying to import data source from excel with the following data:
ProductKey | CustomerKey | Sales_Date | Quantity |
2233 | 19069 | 12/6/2022 | 1 |
1872 | 1646 | 12/6/2022 | 1 |
1872 | 1645 | 12/6/2022 | 1 |
1872 | 1638 | 12/6/2022 | 1 |
1872 | 1635 | 12/6/2022 | 1 |
108 | 19063 | 12/6/2022 | 1 |
1703 | 17685 | 16/6/2022 | 1 |
1703 | 17684 | 16/6/2022 | 1 |
1703 | 17568 | 16/6/2022 | 1 |
1703 | 17567 | 16/6/2022 | 1 |
1705 | 13201 | 19/5/2022 | 1 |
1705 | 13200 | 19/5/2022 | 1 |
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.
Solved! Go to Solution.
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 !
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 !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.