If you’re a Power BI admin in charge of Premium capacity, you may rely on the Power BI Premium Capacity Utilization and Metrics template app to monitor your capacity.
The current version of the app relies on a handful of tables that use DirectQuery alongside others in Import mode. Perhaps you’re not interested in real-time monitoring, however, and you want to save yourself precious time while interacting with the report.
“I’d like to help, but there’s nothing I can do…”
Assuming you’re monitoring Premium capacity because you own Premium capacity, it’s possible to assign the app’s workspace to Premium capacity.
Assuming you have XMLA read/write enabled, it’s possible to connect to the dataset with Tabular Editor once the workspace is assigned to Premium capacity.
Assuming you’ve connected with Tabular Editor, it’s possible to change DirectQuery partitions to Import (don’t forget to choose the option to view Hidden Objects as many DQ tables are hidden by default).
Assuming you’ve deployed model changes, it’s possible to setup your ideal refresh schedule and have the benefit of better report performance at runtime.
DISCLAIMER: This hardcodes your capacity ID into your partition script, so if you handle multiple capacities from the same metrics app, the slicer to select another capacity will not work properly. Multiple copies of the template app can be installed for multiple capacities though if needed.