Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dataflow refresh error - (400) Bad Request

Hi Community, I need some help with debugging an dataflow error, please help.   I have a dataflow that was refreshing okay as per schedule until 17th April. It gave error on 18th April and then ag...
Dataflow
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi Anonymous ,

 

According to your bug report, I haven't reproduced your problem for the time being. You might as well try to delete the data source (File->Options and Settings->Data Source Settings->Clear Permission) and reconnect to see if it works. If it still doesn’t work, please provide a screenshot of the error message and I will answer you as soon as possible.

 

Let me know the result immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

v-henryk-mstf 

 

It is at the service level, giving failure on scheduled refresh.  There was some discrepancy at the data level in a date column, which we have corrected.  Now, we are getting the error as

 

 

"DataFormat.Error: We couldn't parse the input provided as a Date value.

Details
2019-09-18T18:30:00Z

"

 

The dates are coming from a calculated column in a SharePoint list, which is a calculated column and type is "Date Only."

 

I am currently examining the formula.  

 

Can you provide some input for the date error please?