• 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 – Know What Your Premium Capacity Can Handle

July 21, 2019   Self-Service BI

Power BI Premium capacities give enterprises access to their own dedicated resources in the cloud. With this access enterprises can distribute Power BI content as widely as they choose; it also lets them unlock greater scale, better performance and advanced capabilities that are not available to Power BI users on shared capacities. All of these are possible because you can choose how a Premium capacity’s resources get utilized. 

Today we highlight a recently released tool that can help you understand how much user load your capacity can handle when used. During Microsoft Business Application Summit in Atlanta last June, we introduced a tool for automating load testing  of a Premium capacity. A video run through of the tool is available here ( watch from the 31:00-minute mark)

The tool uses PowerShell to create automated load tests against your capacities, and lets you choose which reports to test and how many concurrent users to simulate.

The tool will generate load on a capacity by continuously rendering each report with new filter values (to prevent unrealistically good performance due to report caching) until the token required for authenticating the tool against the service expires. 

Using the new tool, capacity administrators can get a better understanding of how many users their capacity can handle in a given time frame.

The tool can also be used by report authors who want to understand the user load effect of performance improvements measured with Power BI desktop’s Performance Analyzer 

While the tool is running, users are able to both see the renders happening in real time on their browsers, as well as connect to the XMLA endpoints of the capacities being measured with SQL Server Profiler to see the queries execute as they come.

As the load test is executing, its effects will also be visible in the premium capacity metrics app’s Datasets page. Capacity admins can use this tool to generate load and see how that load shows up. Be sure to read the Premium Deployment whitepaper section about identifying overload in the metrics app beforehand.

To see the effects of the load test in the metrics app after the test has been run, admins should expand the “datasets” tab of their metrics app landing page and initiate an on-demand refresh by clicking “refresh now”. Admins should expect up to a 15 minutes lag from the time the test starts generating load until the time that load is visible in the metrics

To host the tool and other future tools and utilities,  we established a new GitHub repository. The entire repository is Open Source and users are welcomed to contribute, add other tools and repositories related to Power BI Premium and Embedded capacities and improve the existing ones. 

Please be mindful of the existing load on your capacities and make sure not to run load tests during top usage times.
We look forward to hearing your feedback from using the tool and your contributions to the repository!

The Power BI Premium team

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

&#8211, Capacity, handle, Know, Power, Premium
  • Recent Posts

    • Tips on using Advanced Find in Microsoft Dynamics 365
    • You don’t tell me where to sit.
    • Why machine learning strategies fail
    • Why Some CRM Initiatives Fail
    • Lucas Brothers To Write And Star In Semi-Autobiographical Comedy For Universal
  • 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