Forum Discussion
Incremental refresh parameters "We couldn't parse the input provided as a DateTime value"
I am trying to set up a incremental refresh of a datset in the service. I have a merged query that I am filtering on "Start Time", which is a datetime column. It works fine in PB Desktop but when I upload to the service and try to refresh I get the below error:
Data source error{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"We couldn't parse the input provided as a DateTime value."}}],"exceptionCulprit":1}}}
Is there anyway of knowing which column this error message applies too?
3 Replies
- amitchandak
Super User
psteve , your datetime column is not getting the correct value. Open data transformation it should show you the error. Try to change data type and check
Hi psteve ,
It means Power BI can't recognize the input value as date value.
it could get the wrong date format.
5/22/2020(Month/Day/Year) correct
5/22/2020(Day/Month/Year) wrong
Best Regards,
Jay
Hi psteve ,
Did your problem be solved? If the last reply helped you, please consider accept it as a solution.
Best Regards,
Jay
