Forum Discussion
October version Reportserver not refreshing on a schedule?
ok think I found it. I had created the report using the Power BI Desktop but there is another Power BI Desktop specifically for reportserver (https://www.microsoft.com/en-us/download/details.aspx?id=55330)
So I saved the report using that and then uploaded it and set a schedule and it just refreshed ok from a scheduled refresh.
Strange that no errors or warnings were shown when using the other desktop tool but that seems to be the issue.
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.
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.
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