Forum Discussion
How to cancel refresh
- Hi there
The only way to currently do this is to restart your On-Premise Gateway
Just to add another alternative solution to this...
I had an API-initiated refresh hang for hours (normally it takes 1 minute). No idea why. All other refreshes were fine. I tried restarting the Gateway multiple times. Did nothing. Tried taking the Dataset over using another user. Nothing.
Finally I republished that Dataset (via the PBIX) and that killed the hung refresh.
(og response from 2021, now slightly outdated)
The definitive way to cancel a stuck dataset refresh in Primium workspace was described here:
Cancelling a Power BI Premium Dataset Refresh (elegantbi.com)
I have tried all the solutions described above, and they do or do not work depending on the specifics of where the refresh process has gotten itself stuck. However, all of them are trying to force the refresh api to recognize a failure and exit the process.
This solution works always. This is directly instructing the actual tabuar ssas engine running you pbi instance to drop a refresh process. Takes about 1 minute.
It looks like that solution is for Premium only. I'm on Pro.
You're correct though, all of these other solutions only work some of the time depending on how the refresh got "stuck". I tried republishing again when that same Dataset got stuck again later and that time it didn't work.