Forum Discussion
Helper IIOctober version Reportserver not refreshing on a schedule?
Memorable MemberI 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.
niallhannonI 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.
- niallhannon
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.
- stretcharm
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.