- Lab
-
Libraries: If you want this lab, consider one of these libraries.
- Data
Analyze Power BI Capacity Consumption
You administer your organization's Power BI capacity, and users keep hitting slow reports. In this lab, you'll measure utilization against the capacity limit, find the peak periods and the items behind them, and decide how to resolve the throttling.
Lab Info
Table of Contents
-
Challenge
Measure capacity utilization against the capacity limit
To start, you'll import the capacity export into Power BI Desktop, relate its two tables, and measure utilization against the capacity limit.
-
Challenge
Identify peak consumption periods
You will count the hours over the limit, chart utilization by hour, and compare the peaks with the throttling stage.
-
Challenge
Compare interactive and background operations by workload
You will split utilization into interactive and background operations and find the workload whose consumption changes on a throttled Monday.
-
Challenge
Identify the items responsible for peak consumption
You will rank the items by what they consumed and chart when the items behind the peak run.
-
Challenge
Determine whether to rescale, reschedule, or move workloads
To finish things, you'll test the cases for rescaling, moving, and rescheduling, and determine the action that resolves the throttling.
-
Challenge
The last objective
Welcome to the final objective! This is your last chance to experiment in the environment. Clicking End Lab will end this little world that flittered into existence just for you.
About the author
Real skill practice before real-world application
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Learn by doing
Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.
Follow your guide
All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.
Turn time into mastery
On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.