How to Check Power BI Capacity

Ensuring your Power BI reports are fast and reliable is essential, and it all comes down to managing the "capacity" powering them. Think of capacity as the engine for your Power BI environment, if it's overworked, your dashboards will sputter and stall. This guide will walk you through how to check your Power BI capacity, understand what the metrics mean, and give you practical tips for keeping everything running smoothly.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is Power BI Capacity and Why Does it Matter?

In simple terms, a Power BI capacity is a dedicated set of resources - like processing power (CPU) and memory (RAM) - that runs your reports and dashboards. When a user opens a report, runs a DAX query, or refreshes a dataset, it uses up some of those resources. If too many users or processes demand resources at once, performance can slow down for everyone.

Understanding and monitoring your capacity is vital for a few key reasons:

• Performance: It helps you pinpoint why reports are slow and identify resource-hogging datasets or visuals.
• Cost Management: For those on Premium plans, monitoring usage ensures you're on the right-sized plan (SKU) and not overpaying for resources you don't need.
• Reliability: Proactive monitoring prevents capacity "overloads," where Power BI actively delays or throttles report rendering to protect the system, leading to a frustrating experience for your users.

Power BI offers a few main types of capacity:

• Shared Capacity (Power BI Pro): When you have a Pro license, your content is hosted in a shared environment with other Microsoft customers. You have less control and visibility, but it's great for smaller teams.
• Premium Per User (PPU): A hybrid option that gives individual users many Premium features without the cost of a dedicated capacity. It's essentially a special, souped-up version of shared capacity.
• Premium Capacity (Dedicated): This is your own private set of resources, which you purchase based on size (SKUs like P1, P2, etc.). It offers the most power, control, and ability for deep monitoring.

First Step: Check Your License and Workspace Settings

Before diving into admin portals, the easiest place to start is by checking your own license and the settings of your workspaces. This tells you what kind of capacity you're using at a basic level.

1. Check Your License Type

Your license gives you a clear indication of your default power level.

1. Log in to the Power BI service (app.powerbi.com).
2. In the top right corner, click on your profile picture or icon.
3. A small window will appear, displaying your username, email, and license type. It will say "Pro user," "Premium per user," or indicate a Free license.

If you have a Pro license, any content you save in your personal "My Workspace" is on shared capacity. However, a workspace can still be on a dedicated Premium capacity, even if you are just a Pro user.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Check a Specific Workspace's Capacity

If you want to know if a specific workspace has access to dedicated resources, you can check its setting directly.

1. In the Power BI service, navigate to the workspace you want to check.
2. Click the three dots (...) next to the workspace name and select "Workspace settings."
3. In the settings pane, click on the Premium tab.

Here, you'll see a toggle for "Capacity." If it's turned off, the workspace is on shared capacity. If it's on, a dedicated capacity is assigned to it, and the name of the capacity will be shown. You can often tell if a workspace is Premium just by looking at its name, admins will often add a diamond icon next to it to signify its status.

For Admins: Using the Power BI Admin Portal

If you're a Power BI Admin for your organization, you have access to a much more powerful tool for monitoring: the Admin Portal. This is the central command center for managing all dedicated capacities in your tenant.

Steps to Access Capacity Settings:

1. Log in to the Power BI service.
2. Click the Settings gear icon in the top-right corner.
3. Select Admin portal from the dropdown menu.
4. On the left-hand navigation pane, find and click on Capacity settings.
5. Select the Power BI Premium tab and click on the name of the capacity you want to investigate.

Once you select a capacity, you'll see two key areas: Health and Management. The Health tab gives you at-a-glance metrics on how much your resources are being used. You'll see visuals for:

• CPU Usage: This shows the percentage of processing power being used over time. If your usage is constantly spiking to 100%, it's a major red flag that the capacity is overworked. It's like a car engine constantly running in the red zone.
• Memory Usage: This tracks how much of the capacity’s RAM is being used by loaded datasets. Large or inefficiently designed datasets can consume a lot of memory, crowding out other tasks.

While this view is helpful for a quick check, its metrics are aggregated. To get a truly detailed, item-by-item breakdown of what's happening, you need the Microsoft-provided monitoring app.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Go Deeper with the Premium Capacity Metrics App

For the most detailed view of your capacity's health, you need to install and use the Power BI Premium Capacity Metrics app. It's an out-of-the-box solution with pre-built reports designed specifically for monitoring and troubleshooting performance issues. All Power BI Admins should have this installed.

How to Install the App

1. Click Apps in the left-hand navigation pane and then click the Get apps button.
2. In the AppSource marketplace, search for "Premium Capacity Metrics".
3. Select the app and click Get it now. Approve the permissions and install it.
4. Once installed, open it. The app will prompt you to connect to your data. Just follow the on-screen instructions to authorize it, it will automatically find all the capacities you have admin access to.

After a bit of time to refresh and pull in the usage data (often 15-30 minutes), you'll be presented with a full dashboard. This app is where the real detective work begins and provides views that let you pinpoint exactly what's causing slowdowns.

Key Reports Inside the Metrics App

The app contains several report pages, but a few are particularly useful for troubleshooting:

1. Datasets Report

This is arguably the most valuable page. It shows you a list of every dataset on your capacity, ranked by metrics like Memory Usage, Refresh Time, and Query Waits. This quickly helps you identify which datasets are the biggest resource hogs.

Example: You check this report and find that a single dataset called "Global Sales FY2015-Present" is using 80% of your capacity's memory. This tells you immediately where your optimization efforts should be focused.

2. Overload and Throttling Reports

These pages show you if and when your capacity has been overloaded. Overload happens when demand for resources exceeds what the capacity can provide. When this occurs, Power BI starts "throttling," which means it actively delays or rejects new tasks (like loading a report or refreshing data) to keep the system stable.

This report tells you exactly when overload occurred so you can cross-reference it with user complaints or scheduled refreshes. It even identifies what percentage of time your users faced delays - a critical metric for maintaining user satisfaction.

3. Refresh Report

Slow or failing data refreshes can consume a lot of CPU for long periods. This page shows a complete history of every data refresh, how long it took, and if it succeeded or failed. Looking at this can reveal issues like:

• Multiple large refreshes scheduled at the same time, causing spikes in demand.
• A refresh that used to take 10 minutes now takes an hour, indicating a problem in the source data or query.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Practical Tips for Managing Your Capacity

Once you've used the portal and the metrics app to see what's going on, you can take action. Here are a few best practices for keeping your capacity healthy:

• Optimize Your Biggest Datasets: Use the metrics app to find your largest and most frequently used datasets. Work on optimizing them by removing unused columns, simplifying complex DAX measures, and using summary tables where possible.
• Stagger Your Data Refreshes: Avoid scheduling all your dataset refreshes at 9 AM. Spread them out during off-peak hours (like overnight) to prevent overloading the system when users are most active.
• Turn on Query Caching: For datasets serving reports that a lot of users look at, Power BI can cache the results of initial queries so that subsequent users get an almost instant load time without hitting the capacity hard again.
• Consider Incremental Refresh: For very large datasets, set up incremental refresh. Instead of reloading the entire dataset every time, Power BI will only pull in new data, drastically reducing refresh time and resource usage.
• Right-Size Your Capacity: After monitoring usage for a while, you may realize you're either consistently overloaded or barely using the resources you're paying for. This data can help you justify a move to a larger (or smaller) Premium SKU.

Final Thoughts

Checking and managing your Power BI capacity is a proactive task that pays huge dividends in performance and user experience. By moving from a simple license check to a detailed analysis within the Admin Portal and Premium Metrics App, you can transform from a reactive troubleshooter into an administrator who keeps the analytics engine running smoothly for the entire organization.

While mastering Power BI capacity is a powerful skill, we believe everyone should have access to insights without getting bogged down in server management and steep learning curves. We designed Graphed to instantly connect all your key marketing and sales data sources in one place. Instead of spending hours building manual reports or worrying about CPU throttling, you can use simple, natural language to create real-time dashboards and get answers, enabling your entire team to make data-driven decisions in seconds.