Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Power bi report server tables schema

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.
Status: New
Comments
AnilKumar
Helper II

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
Community Support

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