The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Are there any tools available to perform load tests/stress tests? Can any one please help me regarding this open source tools which we can use to perform this tests? Here we are using power BI report server which we wanted to accommodate 500+ users to access the report server. so we wanted to do load test regarding the performance of the report server.
We wanted to test the report server when 500+ users login at the same time will it effect the report server. Are there are any toolls to test the performance of report server?
Solved! Go to Solution.
Hi @Anonymous ,
The intent of the load test is to determine and analyze the system performance metrics with some simulations closest to real-time usage scenarios. Stress tests can measure the system performance capacity and give more details about the performance metrics under the pressure. With load tests, we can detect performance problems earlier and can take precautions about it. Especially in peak periods, the system must preserve its own stability and in order to ensure we can achieve this, we to need test for maximum stress. At this point, we have to clarify one thing about load testing. The aim of this type of testing is not to test the system for “bugs”. The main idea of load test is to analyze system performance behavior under maximum simulated workloads. The thinking being is that if the system can manage very high, simulated workloads, then it should be able to handle production workloads that are as high or lower. If the system has failure points, then they will become readily apparent in high/higher than normal workloads, so they can be caught early before they are experienced in production.
Refer the following article and to learn more details about how to Load testing for Reporting Services:
https://www.sqlshack.com/load-testing-for-sql-server-reporting-services-ssrs/
Best Regards
Lucien
Can anyone please help ?
Are is there any way to do load test for PowerBI Report Server?
Hi @Anonymous ,
The intent of the load test is to determine and analyze the system performance metrics with some simulations closest to real-time usage scenarios. Stress tests can measure the system performance capacity and give more details about the performance metrics under the pressure. With load tests, we can detect performance problems earlier and can take precautions about it. Especially in peak periods, the system must preserve its own stability and in order to ensure we can achieve this, we to need test for maximum stress. At this point, we have to clarify one thing about load testing. The aim of this type of testing is not to test the system for “bugs”. The main idea of load test is to analyze system performance behavior under maximum simulated workloads. The thinking being is that if the system can manage very high, simulated workloads, then it should be able to handle production workloads that are as high or lower. If the system has failure points, then they will become readily apparent in high/higher than normal workloads, so they can be caught early before they are experienced in production.
Refer the following article and to learn more details about how to Load testing for Reporting Services:
https://www.sqlshack.com/load-testing-for-sql-server-reporting-services-ssrs/
Best Regards
Lucien
see if you can adapt this to RS
PowerBI-Tools-For-Capacities/Readme.md at master · microsoft/PowerBI-Tools-For-Capacities · GitHub
Can you please suggest if it is possible for PowerBI Report server also?
Are is there any other way to do load test for PowerBI Report Server.