Forum Discussion

dwikar's avatar
dwikar
Icon for Helper I rankHelper I
8 years ago

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 s...
Report Server
Report Server + PBI Premium
Report Server On premises
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

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.ScheduleID

You 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 Yu