Turbocharge Your Power BI Premium Gen2 Capacity Metrics App

Turbocharge Your Power BI Premium Gen2 Capacity Metrics App
Reading Time: 2 minutes

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.

Image Credit: Walt Disney Company

“I’d like to help, but there’s nothing I can do…”

Image Credit: Walt Disney Company

Assuming you’re monitoring Premium capacity because you own Premium capacity, it’s possible to assign the app’s workspace to Premium capacity.

Image Credit: Walt Disney Company

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.

Image Credit: Walt Disney Company

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).

Image Credit: Walt Disney Company

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.

6 Comments

  1. When I use Tabular Editor 2 to try to connect to the XMLA endpoint for the premium capacity workspace, I get “The Database with ID = Capacity Metrics Analysis doesn’t exist in the collection” after selecting the database from the “Choose Database” dialog, and I cannot connect to it.
    Does this require Tabular Editor 3?

    1. Happens for me too. Cannot connect with Tabular Editor. Can you post an illustrated step by step on that? I keep getting that error.

  2. You wouldn’t have access to any documentation around the model itself? Measure definitions, attribute definitions, etc? Really would like to build some of my own reporting against that dataset and am stumbling around making a lot of assumptions.

  3. Migrating the models to Power BI Premium Gen 2 will not only streamline the configuration also deliver a lot of additional components.

Leave a Reply

%d bloggers like this: