Forum Discussion

prathyoo's avatar
prathyoo
Advocate II
3 years ago

How do I cancel a dataflow gen2 refresh?

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

 

Regards

Need Help

10 Replies

  • ScottPowell's avatar
    ScottPowell
    Regular Visitor
    3 years ago

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

    Scott

    • prathyoo's avatar
      prathyoo
      Advocate II
      3 years ago

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

       

       

      • jwelch's avatar
        jwelch
        Microsoft Employee
        3 years ago

        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.

  • Rarely's avatar
    Rarely
    Frequent Visitor
    2 years ago

    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

  • webchris's avatar
    webchris
    Advocate III
    2 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

     

    • webchris's avatar
      webchris
      Advocate III
      2 years ago

      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...

    • webchris's avatar
      webchris
      Advocate III
      2 years ago

      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. 😞

  • Thayerthompson's avatar
    Thayerthompson
    New Member
    1 year ago

    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.