Forum Discussion
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 ...
Hi thomas9921
You can consider deal with the error in the Desktop and refresh can be successfully. For handling this error, you can refer What is Div/0! Error in Excel? and Quick tip to prevent #DIV/0! Errors.
If you want to keep this error, you can take this workaround. Replace Errors with a text value.
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
As a dataset, I am able to refresh these queries and the end result for the errors is that it shows as an error. This is what I want.
When I refresh this in a dataflow, the refresh pauses and says it could not refresh because of a DIV/0 error.