Can I run a query to quantify the memory footprint of a published Power BI report?
I want to identify datasets on our Premium capacity (P2) that are at risk of failing, because they are getting too large for the capacity.
In the Power BI Premium "Capacity Metrics App it is possible to view the size of a Power BI "artifact" (dataset) relative to the "Dataset Refresh Limit" (see yellow line in screenshot below). Based on this Guy in a Cube video, I am assuming artifact size vs dataset refresh limit is a good ratio to assess the risk of a Power BI refresh failing (Or to pre-emptively identify datasets that need optimizing).
Limitations of the Capacity Metrics app, incude:
Metrics aren't shown in real time
You need to manually investigate each Power BI report to view the artifiact metrics.
you can't set up alerts.
Therefore, my question is, is there an alternative way to run a query to obtain the memory/RAM consumption of a published Power BI report?
I have read this post that suggests running a Dynamic Management View (DMV) query in DAX studio against a Desktop PBIX file can return the size of columns and tables. Such as
SELECT dimension_name AS tablename,
attribute_name AS columnname,
datatype,(dictionary_size/1024) AS size_kb
I can also run this same DMV against the XMLA endpoint (Tabular Server), but I am unclear if this would provide the "True" memory footprint / artifiact size of the Power BI dataset in the Service. For example both the memory/RAM usage linked to the
the dataset refresh
users interacting with the report (Temp tables being produced by the execution of DAX queries etc.)
Can anyone advise if there is a way to run a query to obtain the memory/RAM consumption of a published Power BI report?
Thanks in Advance
Screenshot from Premium Capacity ap showing artifact size
Thanks @lbendlin . Yes, it apears the DMV only provides a partial picture of the total memory usage. I was looking to replicate the equivalent view that the capacity metrics app produces. It seems the Capacity app provides the same view of RAM & CPU usage in the Power BI Service, that the Task Manager produces on the desktop. When you say "eviction stats" do you mean the "Evidence" Tab in the Capacity Metrics App (see below)?