topic Monitoring and reporting on usage in Report Server

Monitoring and reporting on usage

Anonymous — Fri, 16 Mar 2018 12:57:00 GMT

Sooo

Old SSRS used to expose some useful perfmon metrics you could monitor. It also had its executionCatalog which would tell you who was accessing what reports and approximately how badly these were performing as you got TimeDataRetrieval, TimeProcessing, TimeRendering values. You also got a pile of additional data related to the datasets and performance in an XML field. So you could see which reports were slow and which bits of which reports were slow.

With PBI-SSRS we seem to have none of this. No perfmon metrics at all! Some new ItemAction types (can anyone point me at any documentation that explain what these are) but TimedataRetrieval, TimeProcessing, TimeRendering are all 0 all the time. There is never any further data.

There's a lot of logging taking place in the installation directory whihc I don't seem to be able to direct somewher elese as per this thread

https://community.powerbi.com/t5/Report-Server/Power-BI-Log-Files/m-p/368703#M4233

Tracking failed scheduled data refreshes in PBI reports doesn't seem to be somehting you can monitor in an immediately obvious manner.

Theres a separate request for some info about what's in the log files that are produced here

https://community.powerbi.com/t5/Report-Server/Power-BI-Report-Server-Log-Files-Administration/m-p/377091#M4449

So right now, for production environments you basically have to cross your fingers and over provision. You can't really get a detailed understanidng of whats going on. I'm assuming this must be on the backlog somewhere but it really does need to be addressed so that enterprise adoption of this can be undertaken.

many thanks

Steve

Re: Monitoring and reporting on usage

Anonymous — Wed, 04 Apr 2018 13:18:46 GMT

Unfortunately, I too don't have a solution to this. Does anyone have any idea of what is going on here? I see the same issues with my execution log files and cannot see anything of real value.

Re: Monitoring and reporting on usage

duelr — Mon, 07 May 2018 22:33:45 GMT

Necro bump! How do we get the perfmon data back??? We were using it to collect SSRS data via DataDog's WMI check, now we can't do that at all!

Way to take a step backwards MSFT!

Re: Monitoring and reporting on usage

Anonymous — Mon, 01 Oct 2018 17:39:28 GMT

MSFT PLEASE ADD THIS BACK!

We use this too in SSRS and not having it in PBIRS is a nightmare.

Re: Monitoring and reporting on usage

vickyd — Thu, 29 Nov 2018 21:50:58 GMT

Agree. Really need this! Was so useful with SSRS reports as we knew exactly who is doing what and how long reports are taking to execute etc.

I suppose we may need to put it out as and "idea"and hope it gets voted enough for Microsoft to consider it.

Re: Monitoring and reporting on usage

dianaschnuth — Mon, 08 Apr 2019 17:56:07 GMT

*bump*

Wondering if this has gotten any traction? I only found a couple of related ideas to upvote on the Power BI Idea site, and they weren't particularly popular (yet).

Re: Monitoring and reporting on usage

jsavageau — Tue, 20 Aug 2019 18:37:23 GMT

*BUMP

I can still gather stats on performance of RDL reports but nothing of much use on PBI Dashboards.

Re: Monitoring and reporting on usage

Anonymous — Wed, 21 Aug 2019 07:57:49 GMT

Yeah we've manmaged to get some info on who is looking at the PBIX reports and when they are being updated and refreshed but nothing on performance.

We have been using Perfmon to look at the server to see if it was under any stress. The only pain point we found was a large number of reports set to refresh at the same time (8am seems popular) so we spaced them out a bit and that fixed the issue.

Re: Monitoring and reporting on usage

Anonymous — Thu, 04 Feb 2021 00:31:11 GMT

ANNOTHER BUMP!

Re: Monitoring and reporting on usage

josef78 — Fri, 05 Feb 2021 22:36:50 GMT

Hi,

some additional performnace metrics are possible get from DMV of integrated SSAS instance, but is not right solution.

Also I want expose perf mon metrics of SSAS and RS components of PBIRS.

Re: Monitoring and reporting on usage

josef78 — Sun, 07 Feb 2021 16:45:11 GMT

There idea for it

https://ideas.powerbi.com/ideas/idea/?ideaid=77102b24-4d69-eb11-8fed-281878de77da

Vote up

Re: Monitoring and reporting on usage

GarthMJ — Thu, 19 May 2022 12:55:02 GMT

Adding my voice to this and voted for the idea too!

Re: Monitoring and reporting on usage

Anonymous — Mon, 09 Jan 2023 13:09:20 GMT

Hi there!

Someone here could help me to know where I can find information details about Tables, Metadata, and description of the tables inside Capacity Metrics and Usage Metrics as well. Some documentaion would help too. Thank you so much