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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

12 REPLIES 12
doost
Advocate I
Advocate I

doost_0-1718286829323.png

You can cancel the refresh in the workspace. If you hover next to the name of your semantic model, this will appear.
(works for both manual and scheduled refreshes)

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

Hi @igorfurnas ,

 

You can use rest API commands from power shell and you can cancel that refresh.

 

Thanks,

Sai Teja 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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