The 'increment' argument is out of range

[Anonymous]

Hello all,

Im receiving these error while trying to refresh the data. I've gone through every applied steps to look for the error and i suspect might have got to do with this custom column but Im not sure where the error is, since the refresh preview worked fine

Please help me.

[v-yanjiang-msft]

Hi @Anonymous ,

Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft]

Hi @Anonymous ,

According to the error message, it's usually caused by negtive value of a duration. Please try to debug and check the value in your file to see if there is any negative number which is not expected.

Best Regards,
Community Support Team _ kalyj

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

[Anonymous]

Hi @v-yanjiang-msft 

Thank you for this.

Ive checked my file and you are right with the -ve values.

Which I've tried reaggregating again and the error still presist.
 

Not sure how else should i proceed with this. Do I also need to approah this directly from the source as well?

[v-yanjiang-msft]

Hi  @Anonymous ,

I think you should prevent the negtive value produced in each step, instead of changing it to positive in the next step.

Best Regards,
Community Support Team _ kalyj

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