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.
Thank you thank you thank you!!!!! I am definitely doing this! That app is such trash. This will help so much!!
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?
Happens for me too. Cannot connect with Tabular Editor. Can you post an illustrated step by step on that? I keep getting that error.
Same, would love to know if there is a way around this
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.
No, sorry. Possible it’s still in flux too. Reporting changes were recently released.
Migrating the models to Power BI Premium Gen 2 will not only streamline the configuration also deliver a lot of additional components.