Forum Discussion
Power BI Report Server - Scheduled refresh not triggering
We have installed the lastest Power BI Report Server (October) which includes the features for scheduled data refreshes. The options for scheduling are now appearing in the options but they doesn't seem to trigger at all.
Having gone through the https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh-troubleshoot we still don't have any luck and the log isn't showing anything regarding scheduling.
Anyone got this working? Any suggestions for further troubleshooting?
Thanks in advance!
7 Replies
Hi dwikar,
Please go to SSMS, please execute the query below:
Use <your report server DB name> Go select c.Path, c.Name,rs.ScheduleID,s.StartDate,s.LastRunTime,s.LastRunStatus from Catalog c
join [dbo].[ReportSchedule] rs on c.ItemID=rs.ReportID
Join Schedule s on rs.ScheduleID=s.ScheduleIDYou will find the ScheduleID for the corresponding report, then go to SQL Server Agent -> Jobs, find the job based on ScheduleID, check the job history about this job.
Best Regards,
Qiuyun YuThanks v-qiuyu-msft! This was just the kind of help and guidance I was hoping for.
Looking at the SQL Server Agent jobs now explains why it happened:
Next question is why and what to do about it? What kind of server access is missing for the account?
As an addition improved logging and some information directly through the portal would be appreciated for this.
Best regards,
Daniel
Those are the Shared Schedule definitions.
You need to add the schedule on each powerbi document.
Click the 3 dots on the powerbi doc and select Manage. Then add authentication before adding an entry under scheduled refresh.
You can also test it by selecting refresh now.
We have set the schedules for the reports as well and "Refresh Now" is working - the scheduled refreshes are not firing though.
Thanks!
