Fabric capacity metrics app see active memory usage

[rogerliu9]

Hi,

I'm doing capacity planning for our Power Bi Embedded premium capacity. Following these guidelines: https://learn.microsoft.com/en-au/power-bi/developer/embedded/embedded-capacity-planning.

I understand that the minimum capacity need is limited by it's max memory. We're primarily using import mode. Utilisation is low, so memory is the bottleneck for us. So it makes sense to me to monitor the active memory used by the capacity to make informed decisions. 

We've installed the Fabric capacity metrics app recently, but it seems like active memory metric isn't available. We do see the amount of static memory in GB used by each dataset. But not active memory. I'd imagine that active memory will fluctuated based on usage and refreshes.

This was available in an old app that no longer works for us:

 

Any chance we can get it in the new, non-deprecated Fabric metrics app? Or any other way to get the information?

[Anonymous]

Hi @rogerliu9 ,

According to the document, there are two metrics that can be used to monitor the memory usage of your resource: Azure Memory and Active Memory.

- Azure Memory shows the usage of memory in your resource in gigabytes, and it is available for Power BI Embedded as a platform metric.
- Active Memory shows the amount of memory that is actively used by the datasets in your resource, and it is available for Power BI Embedded as a resource log.

To see the Active Memory metric, you need to enable the Engine category in the resource logs settings of your resource. Then, you can use Azure Monitor Logs to query the AzureDiagnostics table and filter by the ActiveMemory column. You can also use Power BI Desktop to connect to Azure Monitor Logs and create reports based on the Active Memory metric.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[rogerliu9]

I was able to connect Power Bi to Log analytics in Azure monitor. And I've enabled the Engine category in Diagnostics settings in my resource. I see the AzureDiagnostics table in Logs. But no ActiveMemory column available, or other columns close to it:

 

[rogerliu9]

Thanks for the reply.

Azure memory - not sure what platform metric means here. In the Fabric capacity metrics app, I see a Item size(GB) column, is that it?

Active memory - I think this is what I need. We don't have Azure Monitor configured at all. Is there a step by step guide on how to do what you suggested? I'm trying this to start with: https://learn.microsoft.com/en-us/power-bi/transform-model/log-analytics/desktop-log-analytics-confi... Is this the right direction?

Regards,

roger