cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Power BI stress test for premium capacity

Hi all,

I have a P1 capacity and I need to perform some stress test in order to test the peak rated load and the predicted supported load. I would like to know how many users can open and refresh the same reports at the same time and which is the dependency of the cpu performance with respect to the number of connected users. 

Can someone suggest me how to obtain such information (e.g. a tool in order to get these informations)?

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I
Super User I

Re: Power BI stress test for premium capacity

Hi @SampaSim,

 

Sorry @lbendlin, I don't totally agree. Because for measuring CPU for example, the load comes mainly from the users opening reports, mostly from (complex) DAX measures. Memory is, like you mentioned, consumed by datasets and refreshes running concurrently.


There is a great stress test tool available for Premium capacities, it's explained in detail in this blog post:

Power BI Premium – Know What Your Premium Capacity Can Handle.

 

The link to the GitHub repository is: https://github.com/microsoft/PowerBI-Tools-For-Capacities.

 

I'm assuming you already know/read this whitepaper? Otherwise you really should!

Premium Deployment whitepaper 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


View solution in original post

6 REPLIES 6
Highlighted
Resident Rockstar
Resident Rockstar

Re: Power BI stress test for premium capacity

You're measuring the wrong thing. The service doesn't care much how many users are looking at one dataset. What it cares about is concurrent dataset refreshes, dataset sizes and evictions.  Bombard it with refresh requests for different large-ish datasets (1GB+ for your SKU) that you know will exceed the 25GB capacity when taken together. And then have different users request rendering of these different datasets at random.

Highlighted
Super User I
Super User I

Re: Power BI stress test for premium capacity

Hi @SampaSim,

 

Sorry @lbendlin, I don't totally agree. Because for measuring CPU for example, the load comes mainly from the users opening reports, mostly from (complex) DAX measures. Memory is, like you mentioned, consumed by datasets and refreshes running concurrently.


There is a great stress test tool available for Premium capacities, it's explained in detail in this blog post:

Power BI Premium – Know What Your Premium Capacity Can Handle.

 

The link to the GitHub repository is: https://github.com/microsoft/PowerBI-Tools-For-Capacities.

 

I'm assuming you already know/read this whitepaper? Otherwise you really should!

Premium Deployment whitepaper 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


View solution in original post

Highlighted
Microsoft
Microsoft

Re: Power BI stress test for premium capacity

@SampaSim 

 

You can use the Power BI Premium Capacity Metrics app to filter by capacity, and review performance metrics for workspace content.


Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Regular Visitor

Re: Power BI stress test for premium capacity

Thank you all!

@V-pazhen-msft @nickyvv 

With the tool that you suggested, should I simulate something like an incremental load?

Highlighted
Super User I
Super User I

Re: Power BI stress test for premium capacity

Hi @SampaSim,

Yes that's correct. Please have a look at the video and the supported PowerShell scripts. The video explains the tool pretty good.
If you're not familiar with PowerShell, ask someone who is, or from IT, to support you with it.


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


Highlighted
Resident Rockstar
Resident Rockstar

Re: Power BI stress test for premium capacity

@SampaSim   No, incremental refresh is designed to reduce load. You want more stress, not less.

 

@nickyvv  Sorry, I should have qualified my remark - in our company we actively monitor the report performance and  help developers reduce both visual rendering time as well as the number of visuals.  Out of sheer necessity as most reports are used by hundreds of users.  So in our setup user consumption of datasets that are already in memory plays a much smaller role than all the other actions.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors