Automatic Page refresh for published reports in PowerBI Service

[naveenbabu]

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?

[nandukrishnavs]

@naveenbabu 

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...

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂