Forum Discussion

niallhannon's avatar
niallhannon
Icon for Helper II rankHelper II
8 years ago

October version Reportserver not refreshing on a schedule?

I have "Version 1.1.6514.9163 (October 2017)" Power BI Reportserver and have set up a scheduled refresh on a power bi report.   The schedule seems to execute as I can see it happening in the logs (...
Scheduled data refresh
niallhannon's avatar
niallhannon
Icon for Helper II rankHelper II
8 years ago

This is strange. The report doesnt seem to refresh its data actually.

 

I ran a refresh on it yesterday and it was fine, and overnight after a scheduled refresh it is now showing old data. Is there some sort of caching going on?

 

Even when I edit the report I can see the old data but the report scehdule says it refreshed this morning ok. And the source data it should be pulling in is more uptodate.

 

Very odd.

stretcharm's avatar
stretcharm
Icon for Memorable Member rankMemorable Member
8 years ago

Maybe try resetting by createing a template from your pbix the adding as a new document into Report Server. See if this has the same issues.

 

I put a little query into my docs to show when the data was refreshed on the dashboard.

 

SELECT SYSTEM_USER as CurrentUser, @@SERVERNAME as Server, GetDate() as RefreshTime