topic Re: How do I cancel a dataflow gen2 refresh? in Dataflow

How do I cancel a dataflow gen2 refresh?

prathyoo — Tue, 20 Jun 2023 10:32:36 GMT

My dataflow gen2 refresh has been going on for the last two hours. How can I cancel the refresh?

Regards

Re: How do I cancel a dataflow gen2 refresh?

ScottPowell — Tue, 20 Jun 2023 22:13:17 GMT

I don't think currently there is a way to cancel. I'd create an idea in the Ideas area - definitely needed.

Scott

Re: How do I cancel a dataflow gen2 refresh?

prathyoo — Wed, 21 Jun 2023 07:59:33 GMT

I have found a solution using the power bi api and power automate -

Re: How do I cancel a dataflow gen2 refresh?

jwelch — Thu, 22 Jun 2023 22:17:46 GMT

prathyoo I don't believe that is actually cancelling the dataflow. Cancelling is not a supported operation for Gen2 Dataflows yet - it's still in the works.

I'm pretty sure that is only changing metadata, and shouldn't be used like that as there will likely be unintended consequences.

Re: How do I cancel a dataflow gen2 refresh?

Rarely — Tue, 26 Sep 2023 13:14:25 GMT

I've had the same problem, but my gen 2 DF was in a pipeline.
I was able to cancel the pipeline which failed the DF.
ta

Re: How do I cancel a dataflow gen2 refresh?

webchris — Tue, 17 Oct 2023 12:21:17 GMT

Wow, I have a Fabric Dataflow Gen2 that runs for 5 hours now. It does not produce anything meaningful...

Will it be running till the 'cancel' - option has been implemented?

Will we be charged for the computation time? What's the price?

Thanks for solving this.

Re: How do I cancel a dataflow gen2 refresh?

Anonymous — Wed, 18 Oct 2023 11:11:47 GMT

So how do we deal with a long running process ? I suspect its never going to stop as it took 12 min before and we are on 2 hours now. There is not much work to be done as its a fairly small file to be loaded . Feels like the wheels have come off

Re: How do I cancel a dataflow gen2 refresh?

webchris — Wed, 18 Oct 2023 11:14:59 GMT

I just got the information from a Microsoft Employee that they are working on a "Cancel Execution" feature for Dataflows. So I think it will be there in one of the next releases...

Re: How do I cancel a dataflow gen2 refresh?

webchris — Wed, 13 Dec 2023 14:05:58 GMT

jwelch Anonymous

This is still an open issue. I thought there would be a solution.

Unfortunately, I have another flow running for 24 hours now and still cannot be stopped. 😞

Re: How do I cancel a dataflow gen2 refresh?

Thayerthompson — Fri, 10 Jan 2025 20:20:54 GMT

Has a solution been found for this issue? We have created a Dataflow Gen 2 process that features a number of queries. When attempting to publish a table, we've received an error that it has exceeded our workspace capacity. We are unable to cancel the refresh, nor delete the dataflow.

Re: How do I cancel a dataflow gen2 refresh?

pallavi_r — Sun, 26 Jan 2025 17:13:34 GMT

Hi Thayerthompson ,

If the cancel option not appearing in the service, then seems like you need to go through this approach provided by Sandeep Pawar.

https://fabric.guru/cancelling-dataflow-gen2-refresh

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi