Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
robarivas
Post Patron
Post Patron

How to cancel refresh

Any ideas on how to cancel a refresh in the service? I'm not seeing it in the options below.

 

Capture.PNG

 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi there

The only way to currently do this is to restart your On-Premise Gateway




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

13 REPLIES 13
Anonymous
Not applicable

Unsure what happened, I am assuming MS finally heard our cries for help, but there is now a cancel refresh button, I just found it:

 

mmicsa_1-1670270909026.png

Nice going MS, took a few years, but you finally got there.

Hope it helps someone.

WATYF
Helper II
Helper II

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

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

AndreyBear
Advocate I
Advocate I

We tricked a stuck refresh into dropping by doing a dataset takeover.  Give it a try.

This was the only thing that worked for us.

v-gizhi-msft
Community Support
Community Support

Hi,

 

I think you can vote for this idea:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34788757-stop-dataset-refresh 

 

Best Regards,

Giotto

Thanks @GilbertQ and @v-gizhi-msft 

 

That's seems crazy to me but I appreciate the answer.

Pleasure, happy to help




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi there

The only way to currently do this is to restart your On-Premise Gateway




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Considering how impractical this solution is I think it is not a real solution at all as you could also say reboot the computer and it has the same effect. There should be some method to stop unintended refreshes from proceeding without restarting the gateway!

I fully agree. After publishing a report to a workspace I don't want it's dataset to start refreshing anyway, because I need to change a parameter to point to the correct database. As my update takes over an hour, I need to wait for this before I can update the parameter and manually refresh again for the correct DB connection.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors