How to Get Capacity ID in Power BI
Finding your Power BI Capacity ID can feel like a hunt for a hidden key, but it's a straightforward process once you know where to look. This unique identifier is essential for unlocking advanced administrative tasks, especially when working with APIs or scripts. This article will show you two simple methods to find your Capacity ID quickly and explain why it's so important for managing your Power BI environment.
What Exactly is a Power BI Capacity ID (and Why Do You Need It)?
Before we grab the ID, let's quickly cover what it is. In Power BI, a "capacity" is a set of dedicated resources reserved for your exclusive use. This is the engine behind Power BI Premium and Microsoft Fabric, providing reliable performance and enabling larger datasets, higher refresh rates, and other advanced features. Each capacity you purchase or are assigned has a unique identifier, similar to a serial number. This is your Capacity ID - a Globally Unique Identifier (GUID) that looks something like this: 1a23b45c-6d7e-890f-1a2b-3c456d7890e1.
You might not need this ID for day-to-day report building, but it becomes critical for more technical tasks. Here are the most common reasons you'll need to find it:
- Using the Power BI REST APIs: This is the number one reason. Many API endpoints require a Capacity ID to tell Power BI which specific set of resources you want to interact with. For example, you might use it to programmatically assign a workspace to a capacity, check the health metrics of a capacity, or trigger a dataset refresh.
- Automation and Scripting: If you're using PowerShell, Python, or another language to automate Power BI administration, the Capacity ID is a key parameter for targeting your scripts to the correct environment. You can't manage what you can't identify.
- Troubleshooting with Microsoft Support: When encountering performance issues or other problems specific to a Premium or Fabric capacity, Microsoft Support will often ask for the Capacity ID to pinpoint the issue within their internal systems quickly.
- Custom Application Development: If you're building an application that embeds Power BI content or interacts with the service, the Capacity ID helps your application target the right resources for rendering reports and dashboards.
- Capacity Monitoring and Governance: For organizations with multiple capacities, using the ID is essential for building custom monitoring solutions that track usage, performance, and costs associated with each specific capacity.
Prerequisites: What You Need First
To access the Capacity ID, you'll need the right level of permission. You can't just grab this information without being an administrator. Before you start, make sure you have one of the following roles:
- Power BI Service Administrator
- Fabric Administrator
- Capacity Administrator (for the specific capacity you are targeting)
As long as you have one of those roles, you're ready to go. The process only takes a minute.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Method 1: Find the Capacity ID from the Admin Portal URL
This is by far the simplest and quickest method for a one-off task. You don't need any special tools besides your web browser. The ID is hiding in plain sight in the URL when you view the capacity settings.
Step 1: Log in to Power BI Service Navigate to https://app.powerbi.com and sign in with your administrator account.
Step 2: Open the Admin Portal Click the Settings gear icon in the top-right corner of the page. From the dropdown menu, select Admin portal. If you are a Microsoft Fabric user, this location may continue to evolve, but it will always be within the central administration area.
Step 3: Go to Capacity Settings Inside the Admin portal, find and click on Capacity settings from the navigation pane on the left.
Step 4: Select Your Capacity You'll see a list of all the Power BI Premium or Fabric capacities in your tenant. Click on the name of the capacity whose ID you need to find. This will open the management page for that specific capacity.
Step 5: Copy the ID from Your Browser's Address Bar Now, look at the URL in your browser's address bar. The long string of letters and numbers at the very end of the URL is your Capacity ID. That's it!
The URL will look something like this:
https://app.powerbi.com/admin-portal/capacities/1a23b45c-6d7e-890f-1a2b-3c456d7890e1
Just copy the GUID part of the URL, and you have your Capacity ID. You can now paste it into your API call, script, or support ticket.
Method 2: Use PowerShell to Get the Capacity ID
If you prefer a command-line interface, need to find IDs for multiple capacities, or want to build this lookup into an automated script, PowerShell is the perfect tool for the job. It’s a more scalable and repeatable way to retrieve this information.
Step 1: Install the Power BI PowerShell Module (If You Haven't Already)
First, you need the official Microsoft Power BI module for PowerShell. If you don't have it installed, open PowerShell as an administrator and run the following command:
Install-Module -Name MicrosoftPowerBIMgmt
You may be prompted to trust the repository, type 'A' for "Yes to All" and press Enter.
Step 2: Connect to Your Power BI Account
Once the module is installed, connect to your Power BI account by running this command. It will open a browser window for you to sign in.
Connect-PowerBIServiceAccount
Step 3: Get the List of Capacities
Now you're connected, you can use the Get-PowerBICapacity cmdlet to retrieve a list of all capacities your account has permission to see. Simply run:
Get-PowerBICapacity
PowerShell will return a list or table of all your available capacities, including the Id, DisplayName, Sku, and State. The value in the Id column is the Capacity ID you're looking for.
The output will resemble this:
Id : 1a23b45c-6d7e-890f-1a2b-3c456d7890e1
DisplayName : Marketing Premium Capacity
State : Active
Sku : P1
Id : 9z87y65x-4w3v-2u1t-9s8r-7q6p5o4n3m2l
DisplayName : Finance PPU Capacity
State : Active
Sku : PPUThis method is especially useful if you manage dozens of capacities and need to find a specific one quickly. You can even filter the results directly in PowerShell. For instance, to find the ID for a capacity named "Marketing Premium Capacity," you could use this command:
Get-PowerBICapacity | Where-Object { $_.DisplayName -eq "Marketing Premium Capacity" }
This filters the list and shows you only the details for that specific capacity, making it easy to copy the correct ID without searching through a long list.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Important Distinction: Capacity ID vs. Tenant ID
A common point of confusion for those new to Power BI administration is the difference between a Capacity ID and a Tenant ID. They are not the same thing and are used in different contexts.
- A Tenant ID (also known as a Directory ID) is a unique identifier for your entire organization's Microsoft 365 environment. Every user, group, and resource in your company exists within this single tenant. You use it for tasks related to authentication and global application permissions.
- A Capacity ID is an identifier for a specific Power BI capacity resource that exists within your tenant. An organization can have many capacities, but it only has one tenant.
Think of it like this: your Tenant ID is the street address for your entire office building, while each Capacity ID is the specific room number for the high-powered servers located inside that building. When you need to send instructions to a specific server room (like assigning it more work), you need the room number (Capacity ID), not just the building's main address.
Final Thoughts
Finding your Power BI Capacity ID is an essential skill for anyone managing Power BI at scale. Whether you grab it from the admin portal URL for a quick task or use a simple PowerShell command to automate the lookup, you now have the key to controlling and monitoring your dedicated resources programmatically.
While managing backend resources like capacities ensures your reports run smoothly, the ultimate goal is turning data into clear insights. At Graphed, we streamline this entire process for marketing and sales data. We connect directly to sources like Google Analytics, Shopify, and Salesforce and let you create real-time dashboards just by asking questions. This approach frees your team from manual reporting and complex tools, giving you instant answers instead of another configuration puzzle to solve.
Related Articles
How to Create Facebook Ads API for Claude Code
Create a Meta Marketing API access token that never expires, using a system user, so Claude Code can pull Facebook ad reports and manage campaigns.
ClickHouse vs Postgres: When to Switch to Columnar
Comparing ClickHouse vs PostgreSQL means matching storage architecture to workload. Row storage wins for transactions. Columnar wins for scan-heavy analytics.
Google Ads for Orthodontists: Get More Booked Consults
Most orthodontic Google Ads campaigns waste money on low-intent searches. The problem is structure, not the platform.