Scott A on 22 Nov 2017 02:54:28
The current method of setting up scheduled refresh in the Power BI service is clunky and nearly unusable--not to mention an RSI nightmare.
Some better solutions:
--Option for "Refresh every X minutes/hours/days"
--Ability to schedule more frequently
--Powershell to create/update Scheduled Refreshes for Datasets
- Comments (14)
- Merged Idea (1)
RE: New way to schedule refreshes
One more thing, can we please have the option to choose between 12 and 24 hour time format?Even if it is not all users, many users are accustomed to the time format specified in the standard ISO 8601.
RE: New way to schedule refreshes
I have been looking at scheduled refresh times and noted that this is very limited. It simply states -
Daily / Weekly and On the hour (00) and on the half hour (30).
Please can the refresh times be increased and made far more flexible?
The logic/reasoning behind this is due to the
- Monthly Refresh - I have been requested for a Monthly refresh and the option is simply not there? The report needs to remain static month on month.
- 00/30 - timing of the number of reports which are being refreshed - logical to include 45 / 15 rather than a large number of reports / dashboards being refreshed at 00 / 30.
- We need some flexibility - could this something like the following times be added i.e. (15) / (45) etc.
RE: New way to schedule refreshes
Yes need this option to schedule more frequently. I did not realise this idea was already here? I started another idea asking for the same thing particularly moving over from other BI tools which had better scheduling tools.
https://ideas.powerbi.com/ideas/idea/?ideaid=c337398d-eb5e-eb11-8fed-281878bda47d
RE: New way to schedule refreshes
Impossible to stagger the schedule to refresh my many reports for the start of day. They all hit my reporting DB at the same time and is chugging slowly.
RE: New way to schedule refreshes
It would be helpful to have a dropdown for every x minutes, x hours etc. rather than having to put an entry for every 30 mins, it's tedious. There are some datasets that I would like refreshed quicker than 30 mins but there is no option.
RE: New way to schedule refreshes
The entire Scheduled Refresh page needs to be re-designed. From a user interface aspect, it has serious flaws.
1) I have an Enterprise gateway installed on my machine. Yet I see this yellow exclamation every time I log in saying, "You have no personal gateway installed". like I'm doing something wrong. The service needs to detect if there is ANY type of gateway installed on the machine, and only if NOTHING is, display the message. AND, give the user the option to dismiss it forever, for the current machine.
2) Why must I specify a Gateway BEFORE I tell it to keep my data up to date or not. I had a case where the Gateway was deleted on purpose. Now I'm going to get failure emails every day until MS decides to stop (takes about a week, I think). I should be able to shut that off at the top, BEFORE I specify a gateway.
I'm actually with Microsoft on the functionality of the 8 refreshes per day, every half hour. In the early days around the time of GA, it was ONCE per day, with no ability to specify the time. Then it was 3 times per day, then 6. Premium will get you 48. I'm thankful for how far it has come.
And have you ever looked at the ACTUAL refresh time compared to the SCHEDULED time? I have seen it vary by as much as 20 minutes. If MS gives you the ability to schedule to the MINUTE, you're going to expect it to be just so, and it won't happen, and you'll be disappointed. Remember, this is NOT SQL Server Agent, a tool many Power BI developers are intimately familiar with.
If you need it more than every half hour, look into streaming datasets, PUSHING data into Power BI via a stored procedure, or connect it to Azure Stream Analytics.
RE: New way to schedule refreshes
i do not understand why reports, like from exchange online mailbox, which is refreshed in about a minute can only be scheduled 8 times per day. We are checking payments and it does not cover our opening ours.
RE: New way to schedule refreshes
Agree with all comments. We need more granularity to schedule refreshes for a growing list of customers - so that they're not running at the same time when their data sets are living in the same Capacity. Ideal is 1-minute increment. Anything more frequent than 30 minutes would help.
RE: New way to schedule refreshes
This is extremely important. I have several reports to refresh and it is becoming impossible to stagger the schedule for all of them. I would prefer to just choose exact times for refreshes, but even 10 or 15 minute increments instead of 30 would make things much better.
RE: New way to schedule refreshes
At least give us 10 minute increments. You are cause issues on the node trying to run too many refreshes at once because you only give us 30 minute increments to choose from. We need to spread the schedules out.