Forum Discussion

niallhannon's avatar
niallhannon
Helper 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
stretcharm's avatar
stretcharm
Memorable Member
8 years ago

Well spotted. Yes it should warn you somewhere if youve not loaded it from the correct version.

 

The first release of report server didn't let you so I knew that it needed a special version.

I didn't expect it to let you get this far.

 

 

 

 

niallhannon's avatar
niallhannon
Helper 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
    Memorable 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