Forum Discussion
Data load error error: [DataFormat.Error] We couldn't parse the input provided as Date value
Anonymous , Open Power query and check data factSales , check the steps where it errors out. You should have some date conversion is failing or date loading itself is failing, try to correct that, by looking data at the previous step. Check for date format and what is its data type as the source
debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s
refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs
Anonymous , Open Power query and check data factSales , check the steps where it errors out. You should have some date conversion is failing or date loading itself is failing, try to correct that, by looking data at the previous step. Check for date format and what is its data type as the source
debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s
refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs
The source of the issue was incorrect data imported with an 'Unknown' date, but the only way to filter this out was to go back to the steps where the date column was still in text format and then I could exclude 'Unknown' with text filter. So you were right about checking formats in previous steps.
Thanks,
/Mari