Skip to main content
Microsoft Idea

Power BI

Completed

Stop Dataset refresh

Vote (2364) 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...

Administrator on 07 Dec 2022 22:22:57

Update 12/7/22 - Announced 

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

Power BI User on 06 Jul 2020 00:16:44

RE: Stop Dataset refresh

very much needed

vamsi krishna madineni's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:16:42

RE: Stop Dataset refresh

This feature is really needed!! It's very annoying to wait every time you make an adjustment.
Please create somekind of a developer mode, which stops any refresh/interaction and give a manual way to do the refresh.

Just like in Excel to stop the automatic calculation of formulas....

vamsi krishna madineni's profile image Profile Picture

Milos on 06 Jul 2020 00:16:17

RE: Stop Dataset refresh

YES!!! Please add this feature.

vamsi krishna madineni's profile image Profile Picture

Power BI User on 06 Jul 2020 00:16:03

RE: Stop Dataset refresh

Must Needed Feature

vamsi krishna madineni's profile image Profile Picture

Diego MX on 06 Jul 2020 00:14:39

RE: Stop Dataset refresh

Whether it's 20 min to "apply changes" or 20 seconds every time you need to adjust a measure, it's just too much time that makes it exhausting to work with Power BI.
Obviously an answer is to plan my dashboards better, but when you're exploring it just gets increasingly more tiresome.

vamsi krishna madineni's profile image Profile Picture

Josh Power BI User on 06 Jul 2020 00:14:37

RE: Stop Dataset refresh

I observed this issue with a dataflow refresh. Dataflows show an option to cancel, but mine wouldn't cancel right away. It finally cancelled after 2 hours. This defeats the purpose of having a cancellation option - I could have just waited for the job to eventually fail. But I wanted to keep working and tried to cancel in the hope that I could avoid waiting. Having the job not cancel right away was actually worse than just waiting for it to fail since I had no idea how long it would take, and how long my development work might need to be on hold.

vamsi krishna madineni's profile image Profile Picture

Power BI User on 06 Jul 2020 00:14:34

RE: Stop Dataset refresh

I have a query that calls a function that loops through 50 excel files. Any time I make ANY change to that query (find/replace text etc), it not only loops through all the excel files again, but I can see it looping through EVERY TAB OF EVERY FILE. EVERY TIME. It takes 20 minutes to do this each time. Suffice to say I need to find a solution outside of Power BI/Power Query because of this terribly annoying issue.

vamsi krishna madineni's profile image Profile Picture

Vishal Sanap on 06 Jul 2020 00:13:43

RE: Stop Dataset refresh

Should have this basic feature of cancel dataset refresh we losing Job data load of many hours task because of this..Kindly add this feature.

vamsi krishna madineni's profile image Profile Picture

Raymond Ng on 06 Jul 2020 00:13:34

RE: Stop Dataset refresh

Stop Power BI from refreshing.

It's wasting too much time and productivity.

vamsi krishna madineni's profile image Profile Picture

Danielle on 06 Jul 2020 00:13:34

RE: Stop Dataset refresh

I need this option as well. We lose HOURS at my job trying to refresh our data. It locks everything and makes us unproductive. PLEASE add this basic feature.

Merged Idea (1)