Forum Discussion

frano72's avatar
frano72
Helper IV
5 years ago

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