Forum Discussion
paginated report - automated refresh using cached data ?
Hi, I have a paginated report that has stored procedures as its dataset and is set to refresh every 10 minutes.
When published to the service - you can see it start the refersh in the browser on the 10 minute mark but no new data is returned.
I found this link which has an odd note that i can't seem to find any further info on.
Data retrieval guidance for paginated reports - Power BI | Microsoft Docs
"All report datasets are cached on a per-session basis for up to 10 minutes beyond their last use. A dataset can be re-used when submitting new parameter values (filtering), rendering the report in a different format, or interacting with the report design in some way, like toggling visibility, or sorting."
(I also tried 11 minutes refresh, still has same data)
In this reports case - the report is to be like dashboard that is constantly updating every 10 minutes - no parameters are actually passed as the stored proc has the logic to use current time.
any ideas ?
2 Replies
- v-zhenbw-msftCommunity Support
- frano72Helper IV
Hi v-zhenbw-msft - thanks. That video only covers "refresh" not "autorefresh".
I have posted another forum post with more information here :
autorefresh in paginated reports not working (ie r... - Microsoft Power BI Community