Dataflow refresh is being paused by DIV/0 error

Question

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.

alexisolson · Answer

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

v-cazheng-msft · Answer

Hi&nbsp;thomas9921&nbsp;
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.
&nbsp;
If you want to keep this error, you can take this workaround. Replace Errors with a text value.

&nbsp;

&nbsp;
Best Regards
Caiyun Zheng
&nbsp;
Is that the answer&nbsp;you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
&nbsp;
&nbsp;