Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Report metrics

I would like to see which PowerBI report is consumping the maximum CPU utlization and server memory. What is the best way to pull this data from PowerBI service?

Also, let me know what  sort of datapoints helps understanding the report performance.

 

 

2 Replies

  • Reports are not consuming CPU or memory.  Datasets consume CPU (when rendered) and memory (when they are loaded into the capacity).  If you have Direct Query connections then queries initiated by visuals consume memory and CPU.

     

    Please be more specific which performance you are concerned about - frontend UX, or backend data management?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  Anonymous ,

    If you are a Power BI Premium user, you can use the Power BI Premium Capacity Metrics app.

    Power BI Premium Capacity Metrics app provides information about capacity utilization such as CPU, memory consumption by reports/datasets. You can check this information in the Health Centre under the Admin portal at a high-level. Go to Get Apps -> Search Power BI Premium Capacity Metrics App -> Install it.

     

    This is the related document, you can view this content:

    https://docs.microsoft.com/en-us/power-bi/admin/service-premium-metrics-app

    https://docs.microsoft.com/en-us/power-bi/admin/service-admin-premium-monitor-capacity

    https://www.cittabase.com/five-ways-to-check-power-bi-usage/

     

    Best Regards,

    Liu Yang

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