Dataflow refresh is being paused by DIV/0 error

[thomas9921]

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 the same. Is that possible? 

To be clear, I don't want to filter the rows with errors. I still want them to load. 

[v-cazheng-msft]

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!

[thomas9921]

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. 

[AlexisOlson]

I'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