Forum Discussion
Automatic Page refresh for published reports in PowerBI Service
Hi,
I am searching for a way to see automatic page refresh for a report in powerbi service.
I know that Powerbi Desktop has an option for APR, looking similar option in published report.
I have developed a report using a direct query connected with SQL server which I can see live numbers in report whenever the DB is updated, but every time the report page got refreshed only after clicking the refresh button, I want to have this as automatic refresh.
Pin Visuals to Dashboard and also using Push Dataset does not helped me since I want to use filters.
Also I have checked on "Pin Live Page" but again the data is getting refreshed only after refreshing the report manually.
Is there a way to call report api to refresh the page using powershell? or any other workarround?
1 Reply
- nandukrishnavsCommunity Champion
I assume you are using a shared workspace. If that is the case, the minimum refresh interval is 30 min.
If you have dedicated capacity, then the minimum refresh interval is 1 second.
Refer to this https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh#restrictions-on-refresh-intervals
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂