Forum Discussion
Solved
How to cancel refresh
Any ideas on how to cancel a refresh in the service? I'm not seeing it in the options below.
- 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.
Recently discovered - Cancel Refresh rest api call works, but only on "enhanced" refreshes, which are started via rest api while adding one or more parameters as per this doc.
Also, see Cancelling Power BI Dataset Refreshes With The Enhanced Refresh API - Chris Webb
Incidentally, enhanced refreshes are superfast. So fast that we are skeptical and testing. 🙂