Forum Discussion
Power Bi’s scheduled refresh
We currently use Power Bi’s scheduled refresh to refresh our dashboards every 30 mins. However, the ask is if there is any way we can reduce that to say every 15 mins. Can we upgrade our Power BI service for instance so that more frequent refreshes are an option? Or can we use Power Flow to write something ourselves to handle the refresh frequency? Is Direct Query an option for a dashboard of this size (the pbix is 30meg +)?
You have a few options:
1 - Use direct query and set up page refresh ( eg every 2 mins)https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
2 - Use Power BI Rest API and Azure automation runbook to schedule the refresh every 15mins
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset-in-group
1 is easier to set up, but you may encounter "slow" report. This is when you need to use composite model.
2 requires you being a Power BI admin and set up a runbook on Azure. But if you can do 2, there will be so many things that you can do e.g refresh a single targeted table in a dataset
1 Reply
- Tutu_in_YYC
Super User
You have a few options:
1 - Use direct query and set up page refresh ( eg every 2 mins)https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
2 - Use Power BI Rest API and Azure automation runbook to schedule the refresh every 15mins
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset-in-group
1 is easier to set up, but you may encounter "slow" report. This is when you need to use composite model.
2 requires you being a Power BI admin and set up a runbook on Azure. But if you can do 2, there will be so many things that you can do e.g refresh a single targeted table in a dataset