Which datasets are loaded into memory of premium capacity?

[Martin_Hubsters]

Hi,

Is there a way to look up which datasets are currently loaded into memory of my premium capacity? Or is there a log where I can see which datasets have been loaded and unloaded when and why (memory needed for other dataset, memory needed for dataset refresh, dataset outdated after refresh, timeout, ...)?

Thank you!

[Martin_Hubsters]

Thank you @Anonymous , I'll give it a try and see whether it supports my use case. I want to show my report authors/developers, that it makes sense to reuse or extend and existing dataset, instead of just uploading another copy of the dataset for lazyness, which then requires additional space in memory and might kick out someone else's dataset. Especially for localization, users tend to upload another specific dataset instead of adding translations to the exising one.

[Anonymous]

Hi @Martin_Hubsters ,

Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. Thanks in advance.

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. 

[Martin_Hubsters]

Thank you @Anonymous ,

The Capacity Metrics app looks promising. With the eviction count I can at least see how often evictions happen and to which datasets and whether there is an issue with that at all in my capacity. Acctually, what I want to see is whether I could reduce swapping datasets in and of of memory in order to improve performance by combining datasets into one or reducing dataset size. And if no evictions happen, then perfromance bottlenecks must be somewhere else.

[Anonymous · Accepted solution]

Hi @Martin_Hubsters ,

The Health tab in the Capacity settings area in the Admin portal provides a metrics summary about your capacity and enabled workloads.

You can use the Power BI Premium Capacity Metrics app to get the more comprehensive information you need about your dataset.

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.