Power bi report server tables schema

[AnilKumar]

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??

Thanks & regards,
Vishnu Priya.

[AnilKumar]

Hi All,

I Have Power BI Report Server with some published Reports along with the scheduling (Reports). 

I want to Know

1. How many Reports are published till now?

2. In the Published repors, How many scheduled(for refreshing)?

3. What is the Current Status of them?(Like refreshed/inprogress/Failed)

Can i get this with the reportserver database using queries??

Thanks & Regards,

Vishnu Priya

[v-qiuyu-msft]

Hi @AnilKumar, 

You can run below query in SSMS: 

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'

Best Regards,
Qiuyun Yu