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

[rubayatyasmin]

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. 

[rubayatyasmin]

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

[miguel]

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

[v-gchenna-msft]

Hi @rubayatyasmin ,

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

[rubayatyasmin]

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.

[v-gchenna-msft]

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.

[rubayatyasmin]

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

[v-gchenna-msft · Accepted solution]

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