HOWARD A PETREE on 11 Aug 2020 14:51:18
Please consider adding back the Scheduled Refresh times to every 15 minutes at least and consider adding a selection to schedule every 10 minutes. This will help organizations further disperse report timing to reduce the load on the databases being queried and the Premium Nodes on the hour and half hour when current Scheduled Refreshes are now scheduled. Thank you for your consideration.
- Comments (4)
RE: Expand Scheduled Refresh Times to 10 or at least 15 minutes
Limiting the Scheduled Refreshes to the Hour and Half-Hour puts a strain on our system and our Users ability to use our Dashboards and Reports on occasion. As others have suggested, the 10 or 15 minute option would be of great value to us.
RE: Expand Scheduled Refresh Times to 10 or at least 15 minutes
Thank you for your input on this. I respectfully disagree. This is a problem regardless. If all of the reports are kicking off on the half hour and hour, our databases continue to get a load from the node at those times. Providing the ability to spread Scheduled Refreshes beyond the half hour and hour times will most certainly help reduce the load on databases at those particular times. I am not as concerned for the node as I am for certain databases within the AT&T network.
RE: Expand Scheduled Refresh Times to 10 or at least 15 minutes
We don't necessarily need MORE refreshes per day but we need the ability to stagger the refreshes so that we don't have all of our reports trying to refresh at the same time. Spreading this out so that there is no queue should be the same amount of data transfer and less strain on the system. Maybe the answer is not to be able to refresh every 10 minutes but to be able to stagger the start times while maintaining the 30 minute refresh frequency minimum. If we could start some reports at :05 and some at :15 and :30 and :45 and have them recur a minimum of 30 minutes later that would essentially be the same amount of data though and spread the workload.
RE: Expand Scheduled Refresh Times to 10 or at least 15 minutes
The pre-cursors to Power BI were Excel PowerPivot models and PowerView reports in SharePoint running Excel Services. It was all a pain to get set up and working. This goes back 7 years to Excel 2013. The BEST you could do for a refresh time was ONCE PER DAY. Then Power BI came out and they eventually offered 3 per day, then more, and now we're at 8 per day for non-Premium Workspaces, and what, 48 for Premium? Every half hour at the top and bottom of the hour?
The things you have to remember are that A) This is NOT SQL Agent where you can schedule a job to run as often as every 10 or 15 seconds, B) It has come a long way from ONCE per day to the options you have now, and C) There's a LOT of datasets getting refreshed at every cycle point and there is no guarantee that yours will happen right at 00 minutes or 30 minutes and 00 seconds.
I don't think this is an issue of functionality so much as it is a question of capacity on the part of the Microsoft Cloud. Think about it, if they open this up to every 15 minutes, that is potentially TWICE the amount of data Microsoft is going to have to move. Every 10 minutes would be up to THREE TIMES as much as it is now.
I once saw my dataset get refreshed about 8 minutes after the scheduled time.
I just don't see Microsoft opening this up any time soon.