Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

What are the possible test cases for testing a Power BI Premium capacity?

What are the possible test cases for testing a Power BI Premium capacity ( example : P1, P2 SKUs)?

 

The goal of the testing is to know how much workload the capacity can take 

 

Has anybody done capacity testing for dev , test and prod workloads? If so please share your experiences.

1 REPLY 1
ichavarria
Solution Specialist
Solution Specialist

Hi @Anonymous,

 

There are multiple possible test cases. Here are some of the possible ones:

 

  1. Maximum concurrent users: Test the maximum number of users that can access the capacity at the same time, while still maintaining acceptable performance.

  2. Maximum data size: Test the maximum size of data that can be loaded into the capacity, including file sizes, row counts, and column counts.

  3. Maximum query complexity: Test the complexity of queries that can be run against the capacity, including the number of joins, aggregations, and calculations.

  4. Maximum report complexity: Test the complexity of reports that can be created and rendered by the capacity, including the number of visuals, pages, and interactions.

  5. Maximum refresh rate: Test the maximum frequency at which data can be refreshed in the capacity, including incremental and full refreshes.

  6. Maximum dataset connections: Test the maximum number of datasets that can be connected to the capacity, including live connections and imported data.

  7. Maximum data source types: Test the variety of data source types that can be connected to the capacity, including databases, files, web services, and cloud services.

 

Regarding experiences with capacity testing, there are several blogs about it. 

 

Best regards, 

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and give Kudos to help the other members find it more quickly

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors