To optimise the use of an Azure resource in Power BI Embedded, we need proper monitoring to track the usage and act upon any changes. We now have integration with Azure Monitor resource metrics.
Using Azure Monitor resource metrics gives you real-time data on the status and load of your resource in an easy-to-use UI inside the Azure portal. It also gives you PowerShell commands and REST APIs to automatically monitor your resource. You can view the data by different measures and different time periods.
We’ve added two new metrics to track the load of your resource:
- Query Duration gives information on the duration of each query through completion. For example, a spike in the average duration time can be an indicator that the current SKU does not have enough query processing units (V-cores) to process the queries, and you should consider scaling your capacity. Of course, the threshold to scale up or down depends on developer’s decision, the data and the type of queries running. An average query duration can vary greatly between datasets and visualisations.
- Query pool queue length gives information on the number of queries waiting to be processed. For example, a spike in number of queries may indicate that your capacity has too many datasets being queried at the same time, causing pagination in memory – and thus, more queries are waiting to be processed. In this case, you should consider scaling up to get more RAM. Memory for each capacity can be viewed here.