Dataset refresh duration and performance monitor

[Anonymous]

Hi.. Need your help guys...

I have designed a new report in PBI Desktop and have published the same in PBI On-Premise Report Server.

I have seen options in other BI tools to find the below. I would like to know if this is possible in PBI Report Server.

1. I have scheduled automatic refresh of a report for every 1 hours and for the entire day. Would like to know how many successful refreshes for the day and how many failures for the same dataset refresh (if failed).

2. How much time taken for the dataset refresh every hour?

3. Any way to display the last data refresh time in the report?

4. Is there any way to hide this big banner since it is occupying half of my laptop screen?

Please help..

[cbarrettEM · Accepted solution]

Your report server database stores this data, probably called BIReportServer. I run a dashboard on my PBIRS to monitor all user activity using the tables and views in this schema.

1. Could be tricky, but maybe do a count of rsSuccess vs rsInternalError in 'Status' field in ExecutionLog3 view, or ExecutionLogStorage table

2. Inside view 'ExecutionLog3', field 'TimeDataRetrieval'

3. Inside the table 'Schedule', field called 'LastRun Time'

4. Unsure; doubtful though

[Anonymous]

No GUI option is readily available? to monitor the performance on dataset refreshes?

[Anonymous]

@Nolock    @PattemManohar 

Please advice. Need your help.