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 ,

 

Check if the solutions to similar problems below can help you, if these still don’t solve your problem, please let me know in time. Looking forward to your reply.

 

Here is the reference link:
Solved: DataFormat.Error: We couldn't parse the input prov... - Microsoft Power BI Community

Power BI Error - Correcting the error: We couldn't parse the input provided as a Date value. - YouTube

 

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

Hi v-henryk-mstf , Thank you for looking into this.

 

I have tried to follow the video, not getting the desired result.  I am getting this error in the dataflow at the service.  Though my sharepoint column shows the dates correctly, I am getting all the dates here as a unique value, i.e., "2019-09-18T18:30:00Z", even before the data type change.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    v-henryk-mstf We corrected the date by converting it first to datetime and then date and it is giving the correct dates, but still we are having the 400 error on dataflow refresh.