{"id":4879,"date":"2019-04-09T09:17:56","date_gmt":"2019-04-09T09:17:56","guid":{"rendered":"https:\/\/www.gigxp.com\/?p=4879"},"modified":"2020-04-13T07:01:39","modified_gmt":"2020-04-13T07:01:39","slug":"powerbi-report-server-performance-tuning","status":"publish","type":"post","link":"https:\/\/www.gigxp.com\/powerbi-report-server-performance-tuning\/","title":{"rendered":"PowerBI Report Server Performance Tuning Best Practices (PBIRS)"},"content":{"rendered":"
In this article, we are going to highlight the PowerBI<\/a> Report Server performance tuning<\/strong><\/em> best practices. Since the PBI report server is an enterprise reporting<\/a> solution, it is imperative to optimize the performance<\/a> of the overall server.<\/p>\n\n\n
\n Workload Bench<\/strong><\/td>\n 8 Core & 32 GB RAM<\/strong><\/td>\n 16 Core & 64 GB RAM<\/strong><\/td>\n<\/tr>\n<\/thead>\n\n \n Power BI Report Heavy (PBIX)<\/strong>\u00a0(>60%)<\/td>\n 1,000 users<\/td>\n 3,000 users<\/td>\n<\/tr>\n \n Paginated (RDL) Report Heavy (SSRS)<\/strong>\u00a0(>60%)<\/td>\n 2,000 users<\/td>\n 3,200 users<\/td>\n<\/tr>\n \n PBIX Heavy Reports<\/strong><\/td>\n 50 Concurrent user loads<\/td>\n 150 Concurrent user loads<\/td>\n<\/tr>\n \n SSRS Heavy Reports<\/strong><\/td>\n 100 Concurrent users<\/td>\n 160 Concurrent users<\/td>\n<\/tr>\n \n PBIX Heavy Reports (Total User base)<\/strong><\/td>\n 1000<\/td>\n 3000<\/td>\n<\/tr>\n \n SSRS Heavy Reports (Total User Base)<\/strong><\/td>\n 2000<\/td>\n 3200<\/td>\n<\/tr>\n \n \u00a0View the Report uses as a reference<\/strong><\/td>\n 8 core<\/a> (PBIX)<\/p>\n 16 core<\/a> (PBIX)<\/p>\n