Premium App metrics

[Bamak]

Hi  

Hi   Premium App metrics is very useful to monitor your capacity activity (memory consumption , refreshes , dataset sizes etc ...)

I have a question, please on this part related to memory consumption  ?

I read that a dataset loaded for refresh is loaded twice at the same time

Once for refresh and a second time, due to possible solicitation via the report view

How can we observe the phenomenon here?

My dataset that is refreshed has a count value  = 1 (not 2?) and the metric for size  seems to match the size of the dataset (not * 2)

Thank you very much for your help and congratulations

Christophe

[v-yangliu-msft · Accepted solution]

Hi  @Bamak  ,

Active memory is the memory used to process datasets that are currently in use

We cannot check whether the data set is used for refreshing or for requesting through the report view. This is determined by the system. Capacity operations are classified as either interactive or background. Interactive operations include rendering requests and responding to user interactions (filtering, Q&A querying, etc.). Background operations include dataflow and import model refreshes, and dashboard query caching. And interactive operations are always prioritized over background operations to ensure the best possible user experience. If there are insufficient resources, background operations are added to a waiting queue until resources free up.

Total queries and total refreshes provide an idea of whether there are interactive (queries)  or background (refreshes) operations done on the dataset.

Your data set is loaded twice at the same time. Total queries represent the number of requests sent, which are interactive operations, so your requests through the report view will be displayed here, and Total refresh represents the number of refreshes. It is a background operation, so your refresh will show that it is 1 here.

Regarding the relevant content and measures of premium app metrice, you can check in this link:

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

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.