Forum Discussion

dwikar's avatar
dwikar
Helper 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
Community 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

  • dwikar's avatar
    dwikar
    Helper I
    8 years ago

    Thanks 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

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      8 years ago

      Hi dwikar,

       

      Please click on the failed job and see detail message: 

       

       

       

      Best Regards,
      Qiuyun Yu

      • dwikar's avatar
        dwikar
        Helper I
        8 years ago

        Thanks again v-qiuyu-msft, unfortunately that doesn't really bring any more details (which makes it a bit hard to resolve).