Forum Discussion
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 (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 ?
6 Replies
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 descIs your SQL Server Agent running? Check the activty monitor as all schedules show under the category Report Server wth a GUID name.
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.
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.
