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.&nbsp;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;

thomas9921 · Answer

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.&nbsp;When I refresh this in a dataflow, the refresh pauses and says it could not refresh because of a DIV/0 error.&nbsp;

Forum Discussion

Dataflow refresh is being paused by DIV/0 error

Related content

DataFlow Incremental Refresh

Incremental Refresh on Dataflow sourced from SharePoint

Incremental Refresh Dataflow Gen2

Dataflow gen2 - Incremental refresh

Microsoft Fabric Capacity Paused