topic October version Reportserver not refreshing on a schedule? in Report Server

October version Reportserver not refreshing on a schedule?

niallhannon — Fri, 10 Nov 2017 10:29:08 GMT

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 (and no errors shown in the logs) but the data on the report hasnt refreshed. If I manually "refresh" the datasource of the report then the data is refreshed ok

Anyone experiencing this issue?

Is the data for the power bi report refreshed into the ReportServer database or held elsewhere? What tables does it go into on the ReportServer DB ?

Re: October version Reportserver not refreshing on a schedule?

stretcharm — Tue, 14 Nov 2017 20:29:46 GMT

I would expect the cachced data to be stored in files, but not sure where.

Query Exection log view in your report db should show the main activities but the logs show more details. I can also see a trace file in my log folder that may help.

SELECT *
FROM [PBIReportServer].[dbo].[ExecutionLog3]
order by TimeStart desc

Is your SQL Server Agent running? Check the activty monitor as all schedules show under the category Report Server wth a GUID name.

Re: October version Reportserver not refreshing on a schedule?

niallhannon — Wed, 15 Nov 2017 09:47:00 GMT

I can see the data in the underlying tables has been refreshed but the data in the report has not.

The scheduled refresh on the power bi reportserver is executing and i can see that in the logs on the server and also in the executionlog table of the reportserver.

Strange that no one else is seeing this behaviour? I cant even find an error anywhere to work from.

Re: October version Reportserver not refreshing on a schedule?

niallhannon — Wed, 15 Nov 2017 10:13:18 GMT

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.

Re: October version Reportserver not refreshing on a schedule?

stretcharm — Wed, 15 Nov 2017 11:55:21 GMT

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.

Re: October version Reportserver not refreshing on a schedule?

niallhannon — Fri, 17 Nov 2017 11:54:20 GMT

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.

Re: October version Reportserver not refreshing on a schedule?

stretcharm — Fri, 17 Nov 2017 14:22:32 GMT

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