Skip to main content

Power BI

Needs Votes

Stop Dataset refresh

Vote (728) Share
vamsi krishna madineni's profile image

vamsi krishna madineni on 10 Jul 2018 12:21:12

Please provide option to stop refreshing dataset after refreshing manually...

If there are any performance issues in database this would lock down the table...

I even observed that reports doesnt get published until the refresh is done...

Comments (78)
vamsi krishna madineni's profile image Profile Picture

1c7a5439 757c-4c3d-8e8d-4812a0a86117 on 06 Jul 2020 00:11:12

RE: Stop Dataset refresh

There are really two places where we need a way to stop/cancel a refresh:

1. At the Power BI Service level - (the Gateway data refresh) - if you click that button by mistake or have an automatic refresh scheduled that fires but you do not want it to run after it has already started, there needs to be a way to cancel/stop it.

2. At the local PBIX file level, you can start the refresh in Power Query when it says your Preview of the data is out of date and then again when you do a Close & Apply, it does another complete refresh.

Would be nice if you had just refreshed the data in the Preview that the Close & Apply realizes this and does not do another full refresh.

Adding a way to cancel a refresh both on the Service or with in the local PBIX file would be very helpful.

Thanks!

vamsi krishna madineni's profile image Profile Picture

52c1a6eb b98b-4ad3-af7b-11fba8302109 on 06 Jul 2020 00:11:06

RE: Stop Dataset refresh

Two really key problems: one is that the Refresh button doesn't have a pop up 'Are you sure you want to start the refresh?' to avoid accidental pressing; two is that refreshes can be of uncertain time (e.g. new pbix upload, changed parameters).

I can post this message as I now have 3 hours to wait until the refresh is done. I *think* I must have clicked on the refresh button accidentally....but who knows?

Really difficult to manage various refreshes if you can't stop them.

vamsi krishna madineni's profile image Profile Picture

2ea4d23e 8558-476f-94d5-7754dd5a3d47 on 06 Jul 2020 00:11:03

RE: Stop Dataset refresh

I have seen this occur more than once and on different datasets, so there isn't any pattern to it.

vamsi krishna madineni's profile image Profile Picture

8997d9e4 8790-4b6b-acd4-3cf650cb5659 on 06 Jul 2020 00:10:05

RE: Stop Dataset refresh

For now, kill the query on the SQL server side. But a Cancel button is needed.

vamsi krishna madineni's profile image Profile Picture

55a2c58f f9e1-4530-a604-d33d00f7e820 on 06 Jul 2020 00:09:43

RE: Stop Dataset refresh

If a report refresh is lasting too long, we may want to lower some dataset parameter on the service, to temporarily shorten history for example, and respawn the refresh.
Now, I have to wait 6 hours, for the timeout to be triggered, before I can proceed with no refresh. I CANNOT restart capacity right now.
This feature is highly expected (it works fine on desktop)

vamsi krishna madineni's profile image Profile Picture

b9e0eea3 2d4b-451f-b3df-fc9f8be7c9dd on 06 Jul 2020 00:09:00

RE: Stop Dataset refresh

This is a must for future releases. I need to have the option to stop scheduled refresh activities.

vamsi krishna madineni's profile image Profile Picture

f2f87ddc 9921-4ed7-9013-bc9dbc684496 on 06 Jul 2020 00:08:51

RE: Stop Dataset refresh

There should be a cancel button.

vamsi krishna madineni's profile image Profile Picture

91552e7c 3de2-43b1-8f26-05d3456ad53b on 06 Jul 2020 00:08:46

RE: Stop Dataset refresh

I find it incredible that I cannot stop scheduled refreshes. Please add this feature.

vamsi krishna madineni's profile image Profile Picture

be076bc5 54bf-4838-9a03-db7ef5c3ac68 on 06 Jul 2020 00:08:39

RE: Stop Dataset refresh

We cannot let other data set refresh to be started until this manual refresh to be completed. Which runs for 3 hours and no option to disable/stop the data set Manual refresh.

This need to implemented ASAP.

vamsi krishna madineni's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:08:33

RE: Stop Dataset refresh

as soon as possible please
make my life easier