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!

Reply
JorgeRM
Regular Visitor

Premium Capacity Metrics for Power BI Report Server

Hello,

 

Is there any reports, utility or program for Power BI Report Server similar to Premium Capacity Metrics?

 

if so, how can I take it?

 

Kind regards

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

So you could use the Windows Performance Monitor to capture logs for the overall server resource usage such as CPU, Memory, Disk and Network usage. But to allocate that to specific reports is not really possible. There would be some information in the ExecutionLog3 view in the Report Server database. And you could potentially trace some of the SSAS profiler events to get detailed usage. but the problem with that is that Report Server dynamically loads and unloads report models on demand and the databases get hydrated with GUIDs for names and I don't know of any way of easily correlating those back to a given report.

View solution in original post

4 REPLIES 4
v-henryk-mstf
Community Support
Community Support

Hi @JorgeRM ,

 

As @d_gosbell  said, the metrics application is an exclusive feature of pbi service premium, which has a monitoring role for the content in the premium volume. There is no similar feature option available in the powerbi report server.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

d_gosbell
Super User
Super User

So you could use the Windows Performance Monitor to capture logs for the overall server resource usage such as CPU, Memory, Disk and Network usage. But to allocate that to specific reports is not really possible. There would be some information in the ExecutionLog3 view in the Report Server database. And you could potentially trace some of the SSAS profiler events to get detailed usage. but the problem with that is that Report Server dynamically loads and unloads report models on demand and the databases get hydrated with GUIDs for names and I don't know of any way of easily correlating those back to a given report.

d_gosbell
Super User
Super User

Unfortunately there is nothing like this pre-built for Report Server

Thank you for the response.


Then, is there any way to know the usage and the resources that the reports are having on the server?


We´re planning to increase our server usage and we would like to know some metrics about it.


Kind regards

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors