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
igorfurnas
Advocate I
Advocate I

How to stop manually a scheduled refresh on PowerBI Web

Hello,

I have setup several datasets to update via scheduled refresh. Sometimes a refresh process that typically lasts 10-15min gets some problem and doesn´t finish succesfully. In the meanwhile it that schedule refresh keeps the status as in progress for 2 hours and I cannot start an manual refresh while that scheduled refresh hasn´t finished.

 

How can I proceed to manually stop a refresh that is currently running?

 

Best regards,

Igor

10 REPLIES 10
pankumar
Frequent Visitor

Publish a blank PBI file with same name and that would override the exisitng file.

SchavezMX
New Member

Just open the .pbix in the Power BI Desktop software and publish it to your workspace and that will override the refresh if it was stuck on endless fresh. 🙂

skiwii
Helper I
Helper I

anshul6122
Regular Visitor

An option to stop or cancel the on going refresh in power bi service
-Just open the task manager and end task name with "Microsoft Mashup Evaluation container" and Bingoo !!!! . Your refresh will stop

v-jiascu-msft
Employee
Employee

Hi @igorfurnas,

 

The scheduled refresh in the Service side is a cloud Service, which we can't control it manually for now. But we can control the gateway. Therefore we could stop the refresh in many ways. I restart the On-premises Gateway to stop the refresh in my test of on-demand refresh. You can try it for the scheduled refresh. 

 

Edit: I shut down all the gateways of my account, the scheduled refresh stopped.

How to stop manually a scheduled refresh on PowerBI Web.jpg 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-jiascu-msft,  thanks for your answer. That's helpful in some cases. In my situation I can´t always solve the problem that way since I have several datasets being updated via that gateway, If I restart it I may end up killing the refresh process of other refresh operations that are runnig at the same time. Are you aware of other ways to manually terminate a specific refresh?

Anonymous
Not applicable

 I am experiencing the same issue as you. Seems like it's been 2 years and no fix yet...

Anonymous
Not applicable

This is a serious feature missing from Power BI and it truly creates issues and hinders processes! 😕

@Anonymous @igorfurnas @igorfurnas 

To Cancle the ongoing refresh please follow below

Analyze active sessions and cancel refreshes in Power BI – Data – Marc (data-marc.com)

 

If this post helps, then please consider Accept it as the solution and give it a thumbs up.


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!
igorfurnas
Advocate I
Advocate I

Hello,

I have setup several datasets to update via scheduled refresh. Sometimes a refresh process that typically lasts 10-15min gets some problem and doesn´t finish succesfully. In the meanwhile it that schedule refresh keeps the status as in progress for 2 hours and I cannot start an manual refresh while that scheduled refresh hasn´t finished.

 

How can I proceed to manually stop a refresh that is currently running?

 

Best regards,

Igor

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