Forum Discussion
thomas9921
5 years agoFrequent Visitor
Dataflow refresh is being paused by DIV/0 error
I have a dataflow that I cannot refresh due to a DIV/0 error. When I refresh the same query in desktop it just refreshes the fille and loads the DIV/0 error as Error. I would like the dataflow to do ...
AlexisOlson
Super User
5 years agoI'd recommend handling the errors (e.g. with try ... otherwise) rather than letting them flow through.
See here for more detail:
https://bengribaudo.com/blog/2020/01/15/4883/power-query-m-primer-part-15-error-handling