cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
Microsoft
Microsoft

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors