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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
Regular Visitor

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
Advocate I
Advocate 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors