Forum Discussion
Power Bi’s scheduled refresh
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
Super UserYou 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