topic Re: Dataset refresh duration and performance monitor in Report Server

Dataset refresh duration and performance monitor

Anonymous — Thu, 04 Apr 2019 07:37:31 GMT

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

Re: Dataset refresh duration and performance monitor

Anonymous — Thu, 04 Apr 2019 12:33:41 GMT

Nolock PattemManohar

Please advice. Need your help.

Re: Dataset refresh duration and performance monitor

cbarrettEM — Thu, 04 Apr 2019 13:44:33 GMT

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

Re: Dataset refresh duration and performance monitor

Anonymous — Fri, 05 Apr 2019 08:40:49 GMT

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