topic Re: Is there any way to cancel the ongoing refresh of DF Gen2? in Dataflow

Is there any way to cancel the ongoing refresh of DF Gen2?

rubayatyasmin — Tue, 13 Feb 2024 06:21:07 GMT

So, I am trying to load some tables in LH using DF Gen2. I was wondering if there is any way to cancel the dataflow refresh. because one of my table is going to idel state. Last time it took 8hrs to give me the failure message. And another refresh is on-going from the morning. 🙄 Why I have no idea. I am guessing my query naming convention is not correct. I used a special character '&' in my query name. I am not sure though.

Re: Is there any way to cancel the ongoing refresh of DF Gen2?

Anonymous — Tue, 13 Feb 2024 06:44:26 GMT

Hi rubayatyasmin ,

Thanks for using Fabric Community.

As of now the UI feature to cancel refresh is not available but it can be done via API :

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

timeline for the cancel feature :

https://learn.microsoft.com/en-us/fabric/release-plan/data-factory#cancel-refresh

Re: Is there any way to cancel the ongoing refresh of DF Gen2?

rubayatyasmin — Tue, 13 Feb 2024 07:28:07 GMT

Wow!! VSCode extension worked like a charm. Loved it. I didn't knew about it. Thanks. Many thanks

Re: Is there any way to cancel the ongoing refresh of DF Gen2?

Anonymous — Tue, 13 Feb 2024 07:50:10 GMT

Hi rubayatyasmin ,

Glad to know that your query got resolved. Please continue using Fabric Community for your further queries.

Re: Is there any way to cancel the ongoing refresh of DF Gen2?

rubayatyasmin — Tue, 13 Feb 2024 08:43:00 GMT

Yeah, that worked. But I am failing to start the refresh again. Any idea why?

I am trying to refresh it and it is saying that DF is refreshing then nothing happens.

Re: Is there any way to cancel the ongoing refresh of DF Gen2?

Anonymous — Tue, 13 Feb 2024 09:09:53 GMT

Hi rubayatyasmin ,

Apologies for the issue you have been facing. I would like to check are you still facing this issue?

It's difficult to tell what could be the reason for this performance. I would request you to wait for sometime and try again.

If the issue still persists, please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Hope this helps. Please let us know if you have any other queries.

Re: Is there any way to cancel the ongoing refresh of DF Gen2?

rubayatyasmin — Tue, 13 Feb 2024 09:59:24 GMT

yeah, this issue still persists. it's been two and half hours still couldn't trigger the refresh.

Re: Is there any way to cancel the ongoing refresh of DF Gen2?

miguel — Tue, 13 Feb 2024 14:37:31 GMT

There isn't a REST API to cancel a Dataflow Gen2 today. We will be adding API support in the future for Dataflow Gen2, but today we do not have a REST API for Dataflow Gen2.

Using non-supported methods could potentially set your Dataflow Gen2 into an undesired state.

Do reach out to the support team for further help so they can investigate your scenario:

https://support.fabric.microsoft.com/support