How to Check Power BI Workspace Capacity

Knowing how much capacity your Power BI workspace is using is essential for keeping your reports running smoothly and your costs in check. When your capacity gets overloaded, report refreshes can fail, user interactions become sluggish, and the insights you need are delayed. This guide will walk you through a few different ways to check your Power BI workspace capacity, from a quick glance in the admin portal to a deep dive with the official metrics app.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Bother Checking Your Workspace Capacity?

Before jumping into the "how," let's quickly cover the "why." Monitoring your workspace capacity isn't just a task for server administrators, it's a critical practice for anyone who builds or relies on Power BI reports. Here’s why it matters:

• Performance: The most immediate reason is performance. A capacity nearing its limit will slow everything down. Reports will load more slowly, slicers will take longer to respond, and scheduled data refreshes might start to fail. Proactive monitoring helps you spot bottlenecks before they frustrate your end-users.
• Cost Management: If you're using Power BI Premium or a Fabric capacity, you're paying for that dedicated hardware. If you regularly overload your capacity, you might be forced to scale up to a more expensive tier. By understanding which workspaces and data models are consuming the most resources, you can optimize them and potentially avoid unnecessary costs.
• Governance & Cleanup: Let's be honest, Power BI workspaces can get messy. Over time, they can fill up with outdated reports, demo datasets, and duplicate content. Checking your capacity often reveals these unused assets that are taking up valuable space, giving you a perfect opportunity to clean house and maintain a tidy environment.

A Quick Refresher: Shared vs. Dedicated Capacity

In the Power BI world, your content resides in either a shared or a dedicated capacity.

• Shared Capacity: This is the standard for Power BI Pro and Free licenses. Your workspaces live on a pool of resources shared with other Microsoft customers. While you don't manage the overall capacity, you are limited by things like individual dataset size (1 GB for Pro) and total tenant storage (10 GB per Pro user, pooled).
• Dedicated Capacity: This is a feature of Power BI Premium (Per User or Per Capacity) and Microsoft Fabric. You get a set amount of computational power and memory reserved just for your organization. This provides more reliable performance and access to larger dataset sizes. This is where checking and managing capacity becomes most crucial, as you have a finite resource pool to manage.

While the following methods are primarily aimed at users with dedicated capacity, the principles of keeping models lean and workspaces clean apply to everyone.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Use the Power BI Admin Portal for a Quick Check

If you're a Power BI administrator and need a high-level overview of your capacities and storage, the Admin Portal is the quickest place to look. It gives you a straightforward summary of storage usage across your environment.

Here’s how to access it:

1. Log in to the Power BI Service (https://app.powerbi.com).
2. Click the Settings gear icon in the top-right corner of the screen.
3. From the dropdown menu, select Admin portal.
4. In the Admin portal menu on the left, navigate to Capacity settings.
5. Select the specific Power BI Premium or Fabric capacity you want to inspect.

Here, you'll see a management tab that provides a simple visual breakdown. It will show you the total storage your capacity SKU provides and how much of it is currently being used. A helpful summary table lists all the workspaces assigned to that capacity, along with the size of each one. This view is excellent for at-a-glance health checks and identifying which workspaces are your biggest storage hogs.

However, this view only tells you about storage. To understand the processing load - like CPU usage from report interactions and data refreshes - you need a more powerful tool.

Method 2: Install the Fabric Capacity Metrics App for a Deep Dive

For a truly detailed understanding of what's happening inside your dedicated capacity, Microsoft provides a free template app called the Microsoft Fabric Capacity Metrics app. This app connects directly to your capacity's monitoring data and presents it in a multi-page Power BI report, giving you visibility into every operation.

It’s the best way to troubleshoot performance problems, understand consumption patterns, and make data-driven decisions about optimization and scaling.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Install and Use the App:

1. Get the App: From the Power BI Service, click Apps on the left-hand navigation pane and then select the Get apps button. Search the AppSource for "Microsoft Fabric Capacity Metrics" and install it.
2. Connect to Your Data: The first time you open the app, it will prompt you to connect to your data. You’ll need to enter the Capacity ID (which you can find in the Admin Portal under "Capacity settings") and the time window you want to analyze (e.g., last 14 days).
3. Explore the Reports: Once the data refresh is complete, you can explore the various report pages. Take some time to get familiar with the metrics.

Key Metrics to Watch:

• CPU Time (CU seconds): Capacity Units (CUs) are the measure of processing power on your capacity. This report visualizes the CU usage over your selected time period. Spikes at certain refresh times are normal, but sustained high usage throughout the day could indicate your capacity is overworked.
• Item Performance: This page lets you see which specific reports, datasets, and dataflows are consuming the most resources. You can filter down to an individual item and see its typical operation duration, wait times, and number of users. This is invaluable for identifying poorly optimized reports.
• Overages and Throttling: A dedicated capacity has built-in mechanisms to smooth out usage, but if demand remains high for too long, it can enter a state of "overload." When this happens, Power BI will delay or throttle certain operations, leading to slow performance. The app will visually highlight periods of overload so you can investigate what caused them.
• Refresh Operations: Use this page to monitor data model refreshes. Are they running longer than expected? Are they consistently failing? A high "Wait Time" here indicates the capacity was too busy to start the refresh when it was scheduled, a clear sign of strain.

The Metrics App transforms capacity management from guesswork into a data analysis exercise. Schedule a weekly or bi-weekly check-in with this app to proactively manage your environment.

Method 3: PowerShell for Automated Reporting (Advanced)

For Power BI administrators who are comfortable with scripting, PowerShell offers a way to programmatically retrieve capacity and workspace information. This method is perfect for automating checks, building custom reports, or integrating capacity management into other IT monitoring workflows.

To get started, you'll need to install the Microsoft Power BI management module.

Install-Module -Name MicrosoftPowerBIMgmt

Once installed, you can use a combination of commands (known as cmdlets) to get the data you need.

1. Connect to your Power BI account:

Login-PowerBIServiceAccount

1. Get a list of capacities: This cmdlet will list all capacities in your tenant and their state.

Get-PowerBICapacity

1. Get workspaces in a specific capacity: You can loop through your capacities and list the workspaces assigned to each, along with their IDs.

Get-PowerBIWorkspace -Scope Organization -Include All

While this requires more setup, it’s incredibly powerful for large organizations that need to monitor dozens of capacities or implement custom alerting. For instance, you could schedule a script to run daily and email you a list of any workspaces that have grown by more than 20% in the last week.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Tips for Proactive Capacity Management

Simply checking your capacity is one thing, actively managing it is another. Here are a few tips to keep your Power BI environment healthy:

• Optimize Your Data Models: This is the single biggest thing you can do. Use star schemas, remove unused columns, manage date tables properly, and reduce column cardinality where possible. A lean data model uses less storage and requires less CU processing for every query.
• Stagger Data Refreshes: Avoid scheduling all your major dataset refreshes for 8:00 AM. This creates a huge spike in demand on your capacity. Stagger them throughout the day or schedule them for off-peak hours overnight.
• Separate Workloads: If your budget allows, consider using separate capacities for different workloads. For example, you can have one capacity for business-critical enterprise reports and a smaller, separate one for self-service analytics and development.
• Educate Your Users: Teach your Power BI report creators about optimization best practices. Share links to performance tuning guides and explain why building efficient models is so important for everyone.

Final Thoughts

Staying on top of your workspace capacity is a foundational part of running a healthy and efficient Power BI environment. By using the Admin Portal for quick checks, the Fabric Metrics App for deep dives, or PowerShell for automation, you can ensure your reports perform well and your investments are being used effectively.

Managing the nuts and bolts of a BI platform like Power BI highlights the technical know-how often required to get an answer. We built Graphed because we believe getting insights shouldn’t require you to become an analytics tool administrator. Instead of digging through performance metrics, you can just connect your data sources - like Google Analytics, Salesforce, or Shopify - and ask for what you need in plain English. Graphed builds real-time, interactive dashboards instantly, freeing you up to uncover insights instead of managing infrastructure.