Why is cancelling refresh so heavy weight?

[micwebnet]

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

[mateoc15]

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.

[ColinG]

@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?

[Anonymous]

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

[ImkeF]

I don't know why it takes so long, but I know a shortcut 😉 

https://wp.me/p6lgsG-13m