Forum Discussion
DataFormat.Error: We couldn't parse the input provided as a Date value. Details:
Good day,
I am having difficutly on generating my report as part of my data import from excel shows "DataFormat.Error: We couldn't parse the input provided as a Date value." It was fine as previously the environment doesnt require full length of timeline to be show in the report but now we need to present in 24/7 so I tried to change it from selecting on filter to be select all and it happens.
I'm a newbie on powerbi and the senior who managing the report had left without handover. None of our member knows how to fix. Can someone guide me how can i fix this?
3 Replies
Hi Anonymous ,
This is related with the format of the data and the region used on your report best way of fixing this is to change the type based on location:
https://www.myonlinetraininghub.com/change-type-using-locale-with-power-query
Be sure that you do this before the step Changed Type.
Where did you do this new step? You need to do it before the changed type step
