• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Power BI Premium Capacity Metrics app makes navigating and viewing metrics at workspace level easier!

December 18, 2018   Self-Service BI

Thanks to all the great feedback we’ve received from our recent admin survey and from the Power BI Ideas feedback site. The Power BI Premium Capacity Metrics (version 1.10) app provides a comprehensive view of workload operations such as dataset and dataflow refreshes, dataset evictions, dataset queries, paginated report data retrieval/execution, and system metrics in the capacity for the past seven days. This all provides a more in-depth view into the health of a capacity.

image 15 Power BI Premium Capacity Metrics app makes navigating and viewing metrics at workspace level easier!
Summary available on the dashboard


Summary of the changes:

(A) Removed Filter page from the report and added the ability to filter by capacity Id and dates to each of the datasets, paginated reports and dataflows workload pages.

(B) Report displays the last refresh time (UTC)

(C) We are happy to support cross-highlight and aggregation at both the datasets and workspace level.  The admin can now easily visual the cumulative resource consumption at the workspace level to make data driven decisions with migration or assignment of workspaces to a capacity.

image 19 Power BI Premium Capacity Metrics app makes navigating and viewing metrics at workspace level easier!

(D) In the Query Waits tab (image below) , the query wait time distribution histograms is bucketed by query wait time  split into hourly intervals reported in milliseconds as <= 50ms , 50-100ms , 100-200ms , 200-400ms 400ms-1sec , 1 sec-5 sec and > 5 seconds intervals. Long wait times could be a sign that a capacity running hot. It may also mean that the datasets themselves could benefit from optimizations and further investigation is needed.


image 20 1024x555 Power BI Premium Capacity Metrics app makes navigating and viewing metrics at workspace level easier!

Installing the app

Let’s get started by installing the service app. If you have a previous version of the app already installed, it’s best to delete it from your apps and then hit CTRL-F5 to refresh to avoid confusion with versions.

The app can be installed by searching for “Power BI Premium Capacity Metrics” in the Power BI apps or by clicking here to get it now.

image 21 Power BI Premium Capacity Metrics app makes navigating and viewing metrics at workspace level easier!

Known issues during installation of the app

We are working on making improvements in the current service app installation experience. You may experience some delay during installation. We highly recommend you hit F5 on the app page and wait for the refresh of the report to complete before accessing the app. You can confirm the refresh status by checking the refresh history on the dataset settings.

2e9b3884 f6c9 4b19 841a 816df812f655 Power BI Premium Capacity Metrics app makes navigating and viewing metrics at workspace level easier!

After a couple of minutes since installation, if the screen appears blank as below, please hit F5 to refresh the page to get the dashboard, report and dataset links.

Additional steps to use the Premium Capacity Monitoring app with Power BI Embedded

This same app can be used to monitor any A SKU capacities you may have in Power BI Embedded. They will appear in the report provided you’re an admin of the capacity. Refresh of the report can fail unless you grant certain permissions to Power BI on your A SKUs. This can be done by opening your capacity in the Azure portal, clicking on Access control (IAM) and adding the “Power BI Premium” app to the Reader role. If you’re unable to find the app by name, you can also add it by its client Id: cb4dc29f-0bf4-402a-8b30-7511498ed654.

 Power BI Premium Capacity Metrics app makes navigating and viewing metrics at workspace level easier!

Moving forward

Now that you have the app installed, you can see metrics about all the capacities in your organization for which you are an admin. You can now make more informed decisions and more effectively manage the premium capacities, workspaces and datasets in your organization. These metrics are just the start. More detailed metrics and tooling will become available in the following weeks and months. And be sure to submit your ideas for more any suggestions.

Learn more about what Power BI premium is, monitoring premium capacities and how Power BI Premium works.

Check out “Managing Microsoft Power BI Premium capacities to your entire organization” YouTube session by Josh Caplan and Adam Saxton at Ignite 2018.

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Capacity, Easier, Level, Makes, Metrics, Navigating, Power, Premium, viewing, Workspace
  • Recent Posts

    • WHEN IDEOLOGY TRUMPS TRUTH
    • New Customer Experience Needs and Commerce Trends for 2021
    • A data transformation problem in SQL and Scala: Dovetailing declarative solutions
    • George Wallace Joins Laverne Cox For Comedy Titled ‘Clean Slate’
    • How Microsoft Azure DevOps and Dynamics 365 CRM Work Together to Improve Service Responsiveness
  • Categories

  • Archives

    • February 2021
    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited