Publish to Web Issue - Takes too long for published reports to refresh (sometimes over an hour)

[Yannis_exe]

Hello,

The last four days all our published reports need 1 hour (or in some cases a bit more) to be updated from the time that the dataset is refreshed.

Note that all these reports are in import mode (most of these have a minimal dataset i.e. 3col x 10 rows) and run for almost a year now - up until four days ago as soon as the dataset was refreshed the published reports refreshed almost instantaneously.   

I'm aware of "the data is cached for one hour from the time it is retrieved"   from  Publish to web from Power BI

but the next paragraph also states " Data refreshes are automatically reflected in your embedded report or visual. When data is refreshed for an import data model in the Power BI service, the service clears the data cache, making data update quickly" 

which was also explained analytically in a Microsoft Power BI Blog from 23 October, 2020 "Updates to Power BI Publish to web for better public reporting":

"Now, we’re rolling out a change to help make data updates work better. When your import dataset in Power BI refreshes, we’ll clear the publish to web cache. The updated data for will load once the cache entry is cleared, which is often very soon after the refresh occurs.  For very popular embed codes or embed codes that generate many queries, it’s still possible to take up to 60 minutes to see the updated data."

So, for the last four days it seems that something is not working properly and  PBI Service don't clear the Publisht to Web Cache when the import dataset is refreshed.

Have anyone else experienced the same issue? 

[Anonymous]

Hi , @Yannis_exe 

Currently, no similar problems have occurred. Did this happen to you in the last 4 days?

It can be seen from the official documentation that in most cases, the data is updated nearly simultaneous with the import of the data. However, for reports with many distinct queries, it may take some time to update. Since each element and data value is cached independently, when a data update occurs, a user may see a mix of current and previous values. Therefore, we recommend staging your work ahead of time, and creating the Publish to web embed code only when you're satisfied with the settings. If your data will refresh, minimize the number of refreshes and perform the refreshes at off hours. We don’t recommend using Publish to web for data that needs to refresh frequently.

Best Regards,
Community Support Team _ Ailsa Tao

[Yannis_exe]

Hi Ailsa,

Thanks for the input. 

Yes, this is happening for the last week only (although most of the reports originally published a year ago and refreshed without any delay).

Please note that regardless the content and the time(s) a report is refreshed there's always a delay of almost one hour for the published to web report to refresh.

For example, one report/dataset only refreshes once every morning (08:00 am EET) and another report/dateset refreshes every 15min - both Published to Web reports need almost one hour to be updated.

Note that the report that refreshes every 15min consists of a tiny dataset (3col x 15rows) and two visuals - one table and one linechart (with no slicers, etc)  

[heliojsjr]

Same problem here...