Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 !