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 err...
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
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?