Data load error error: [DataFormat.Error] We couldn't parse the input provided as Date value

[Anonymous]

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]

Thank you for your quick reply!
I went over all the steps, but the columns are still green at the top, i.e no errors identified. It's like the load is blocked because of incorrect values in the data import, could that be the case? 

[amitchandak · Accepted solution]

@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]

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