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

c90e4ada a949-4c03-ab80-a6076ae23bf2 on 06 Jul 2020 00:16:45

RE: Stop Dataset refresh

Yes, much needed!

vamsi krishna madineni's profile image Profile Picture

33b4e9b7 b524-4c9c-9b4a-b149c6a92290 on 06 Jul 2020 00:16:45

RE: Stop Dataset refresh

Please add this feature.

vamsi krishna madineni's profile image Profile Picture

c42a4981 e9aa-4926-86c3-83865b2b687a on 06 Jul 2020 00:16:44

RE: Stop Dataset refresh

This feature is badly needed for both scheduled and on demand refreshes.

vamsi krishna madineni's profile image Profile Picture

c90e4ada a949-4c03-ab80-a6076ae23bf2 on 06 Jul 2020 00:16:44

RE: Stop Dataset refresh

Yes, much needed!

vamsi krishna madineni's profile image Profile Picture

50a4a9e2 a173-4832-942f-ed165d651871 on 06 Jul 2020 00:16:44

RE: Stop Dataset refresh

very much needed

vamsi krishna madineni's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 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

ed1c645b 666f-4f29-92cb-fe7448140f0a on 06 Jul 2020 00:16:17

RE: Stop Dataset refresh

YES!!! Please add this feature.

vamsi krishna madineni's profile image Profile Picture

8e3488df 1023-45e8-8743-252c333c7f0d 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

3b7181d0 ba7f-4d93-b0b7-746dde496ba7 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

05f6e94b e179-43af-8f20-ae949a11399b 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.