Forum Discussion
Data load error error: [DataFormat.Error] We couldn't parse the input provided as Date value
Hi,
I have a dataset that retrieves data through Analysis Server and it contains more than 200k rows. I get the error below when I try to refresh, but it doesn't show the date values with the error, it only says 'Unknown'. Since there are too many rows, I cannot identify the error. I have tried the steps Change type->Using Locale.. but it doesn't work. In power Queries, all columns are green at the top, probably because it doesn't allow the import of the error value. It just blocks the data refresh..
Please help, I'm losing ranking 😞
/Mari
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
3 Replies
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-Lag0VOiTsThe 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