Hi all, I have power bi report server installed and I punished some reports to it. Also added the scheduling to them.
Now I want to know how many reports are published to server and does they are scheduled and the latest status of the them like last refreshed time and state of refresh Can i achieve all this with queries??
use <Your ReportServerDB Name> select *from [dbo].[ReportSchedule] rs join [dbo].[Schedule] s on rs.ScheduleID=s.ScheduleID join [dbo].[Catalog] c on rs.ReportID=c.ItemID join [dbo].[ExecutionLogStorage] els on rs.ReportID=els.ReportID where els.Format='DataModel' and s.EventType='DataModelRefresh'