Azure Memory Thrashing metric available for Power BI Embedded
Posted on Wednesday, May 9, 2018
An Azure Memory Thrashing metric is now available for Power BI Embedded. This metric shows the percentage of memory being thrashed from the RAM of your resource, relative to the total size of RAM in the resource.
When your resource is not at full capacity, it can contain all the datasets being used, so this metric is on 0%. When you're trying to use datasets that, combined, are bigger than what your resource can contain (for example, when multiple users are trying to open reports or refreshing multiple datasets at the same time), the memory starts paginating datasets, performance degrades, and the metric jumps up.
Note that this metric is relevant only for Import mode datasets, because they're hosting data in memory. This metric does not monitor datasets that are using DirectQuery or live connection to Analysis Services.