Colin Jemmott on 08 Aug 2017 01:02:26
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?"
Administrator on 12 Sep 2018 05:38:28
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.
- Comments (14)
RE: Power BI Premium Performance Monitoring
Any update on this feature? We need to be able to monitor several usage metrics within our organization to ensure a good user experience by avoiding bottlenecks and increase capacity when needed. I've seen the "Power BI Premium Capacity Metrics" report, but am also really interested in seeing more detailed metrics like report/dashboard load times, highest used reports/dashboards and least used so they can be pruned.
RE: Power BI Premium Performance Monitoring
Check out the blog for new monitoring capabilities for Power BI Premium Capacity
https://powerbi.microsoft.com/en-us/blog/new-monitoring-capabilities-for-power-bi-premium-capacities/
RE: Power BI Premium Performance Monitoring
We just implemented Power BI Premium and our need is to be able to see how much storage space workspaces are taking up in the node. Any chance at all that we'll be able to see the sizes of the workspaces in our node? Is this something that MS is considering?
RE: Power BI Premium Performance Monitoring
'I am the PowerBI Admin for our company, we are working hard to extend this tool, due to its promises but we have always some concerns doing so, as Microsoft seems to be slow in developing much needed administration capability. This subject is key for us and of course for Microsoft.
As we are growing our usage of PowerBI, in particular with Premium it is becoming really urgent to have a much lower granularity on Premium Capacity load understanding.
We are not able to understand the Workspaces/Datasets usage/impact on the Premium which is somewhat sad:
-When each Workspace/Dataset is impacting
-How much it is impacting, how it is impacting (CPU/Memory?), how long, how frequent?
We shall also have the ability to ban Workspace/Datasets that are definitively badly impacting Capacity and jeopardizing the other contents.
We shall be able to have dashboard helping slicing, understanding those metrics, and reaching the Workspace/Dataset owner to work with them.
I have already raised our concerns and expections on this aspect months ago, and this is sad that we are stuck with the current barely useless information. What can we do with it actually? Purchase a new capacity when we hit limits? What limits? To move what? We can't know.
Happy to be contacted and involved as needed.
RE: Power BI Premium Performance Monitoring
'@josh caplan Are you planning to open up a discussion around features?
RE: Power BI Premium Performance Monitoring
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
RE: Power BI Premium Performance Monitoring
Would love to see some sort of response from Microsoft on this. Is it on any roadmap anywhere?
RE: Power BI Premium Performance Monitoring
'@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.
RE: Power BI Premium Performance Monitoring
Power 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.
RE: Power BI Premium Performance Monitoring
'@cjemmott where did you find the metrics for CPU & Memory usage