I currently have no way of monitoring my Power BI Premium server. As we add more and more users to our single EM1 PBI Premium server, I am sure at some point we will run into performance issues. However currently there is no way to see the load on the server. Here are two things that would help: 1. Server level usage metrics reports. Currently I can only view this by workspace, and I have 50+ workspaces, so there is no way to know the overall views or active users. 2. Server level performance reports. There are lots of metrics I could ask for (memory, I/O, storage, load times, etc.) but my basic question is "how do I know when I need to upgrade?"
16 Comments
- First version of this feature has been released: https://powerbi.microsoft.com/en-us/blog/new-monitoring-capabilities-for-power-bi-premium-capacities/. More to come.
- Yes, more would be better. Plus some customers would love the ability to setup 'alerts's.
- cjemmott
Advocate IV
It appears very limited usage metrics were added in the August release. There are three metrics: CPU, Memory thrashing and Direct Query. I would love to see more, but this is a great start. - I am in a similar situation. I have publishers, and cannot see many of the statistics to answer user questions about performance (spinning icon, refresh failures with only a suggestion to add more capacity)... I'm paying almost 100k a year to have 450 POTENTIAL publishers, and 1500 potential viewers, and I have no way other than audit logs to see who is viewing what, and how often. This really needs a better path to administration... Right now I'm totally guessing on ROI with what I'm giving vs what I'm getting
- Agreed, the current KPI (green/yellow/red) report doesn't even come close to filling this need. We need to be able to see actual Capacity utilization details (CPU, Memory, Queries), over time, by Workspace at the very least.
- '@cjemmott We are using Power BI Embedded Capacity on Azure, not Power BI Premium. On azure portal I can see only 2 metrics Query duration and Threads, no information on CPU/Memory usage. Are these metrics only available for PowerBI Premium.
- cjemmottPower BI Embedded capacity usage is monitored within the Azure portal. Check the "Usage measurements (Power BI Premium)" section here: https://docs.microsoft.com/en-us/power-bi/service-admin-premium-manage Still much too limited for my needs.
- '@cjemmott where did you find the metrics for CPU & Memory usage
- Would love to see some sort of response from Microsoft on this. Is it on any roadmap anywhere?
- We are already hitting our premium capacity limits and there is no way to tell which reports are consuming the most resources - Also the last 7 day trend doesn't help much in case we want to test certain optimizations. This definitly needs to be improved
