Forum Discussion

micwebnet's avatar
micwebnet
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Why is cancelling refresh so heavy weight?

Whenever I cancel a refresh I mistakenly start in Power BI Desktop it takes forever to truly cancel. The app hangs (ghosts) and even after it becomes responsive, interactivity is impacted. On a large report this can drag for a good minute. Why can't cancel literally kill the ongoing refresh and go back to existing data set?

 

Thanks, Michael

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Well, having a couple of times been forced to kill PBI after waiting several hours for a stuck query to cancel, I think this is something the developers to pay some attention to. (And, no, ending the mashup processes didn't do the trick: they were all idle anyway. It was the cancelling that was taking hours, not just the query.)

  • ColinG's avatar
    ColinG
    Frequent Visitor
    2 years ago

    micwebnet You are a MS employee? Why are you asking us? lol....

     

    I have recently, within the last 3 or 4 weeks, been experiencing the same thing. Does anyone have any more info on this?

  • mateoc15's avatar
    mateoc15
    Icon for Advocate II rankAdvocate II
    2 years ago

    I was getting this during the process of recovering an unsaved file.  That's saved locally.  My data sources are all behind a VPN, so I just disconnected the VPN.  Something similar might work if you delete or just move the files it's trying to connect to, or disconnect from the internet, turn off the database server, etc.  Got an error message pretty quickly, reconnected and fixed from there.