Forum Discussion
Premium App metrics
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
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.
1 Reply
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.