Power BI currently provides refreshes daily and weekly; however, that isn't frequent enough for real-time dashboards. We run a service and need data refreshed often throughout the day, so we use VBA to refresh the data every 15 minutes. VBA isn't supported on the Power BI sites though, so we can't use those for our dashboard. We need a more granular refresh mechanism built into the "system."
9 Comments
- It would also be great if there was more advanced options on the refresh schema. Eg. I would like to refresh on table in a dataset of 10 tables once a month but the rest of the tables daily. I know how to work around this but the option would be nice though.
- This is important. I was hoping for implementation of continuous querying on Direct QUERY DATABASE. These days， all data are realtime, meaning even hourly updates are horrible. I want minute by minute updates.
SreejithAdvocate I
Has this been prioritized or in your development pipeline? This would have been a great feature, since modeling the data not flexible with RestApi as much as with PBI desktop tool. The PBI desktop is great, but real time data refresh will be a significant feature.- SreejithHi @Will Thompson can you please provide tentative date when this feature will be rolled out?
- I'm running into time out problems because I have too many reports going at once on the refresh. It would be great to stagger them out 5-10 minutes apart instead of 30 min.
- Our Premium Capacity often has issues with more than 6 schedules running at once (throttle). This occurs more because users can only select half hour increments. I'm okay if you keep the 48 times a day limit but let users select more time slots than on the hour or half hour. Some users need to run 48 times within a shift for example. ALSO, you should let us set how many times to retry and how many minutes apart. For example, retry 3 times 5 minutes apart upon failure.
- I have the same needs as the comment from G. Weaver earlier. It will be great if on powerbi.com we can setup the scheduled refresh for different datasets querying data from the same db/sql server at very specific time, at least 5 mins apart (e.g. 12.05, 12.10, 12.15, 12.20, etc) instead of on mins 30 or the full hour only.
The ability to create customized data refresh intervals is now available via REST API, to learn more: https://docs.microsoft.com/rest/api/power-bi/datasets/refresh-dataset-in-group
- Status added:Completed
Recent ideas
Display the Business Names in Power BI report when using ODBC connection to connect to Datasphere.
Currently we are only able to see the technical names displayed in Power BI when the Datasphere report is exposed to Power BI using the ODBC connection. It would be better if we have the option to di...