Optimizing Power BI Report Builder performance

Hi, manhil29 

If you want to optimize the performance of paginated reports in the Power BI service, you can first refer to the overall process of the report performance optimization guide below and optimize each part according to the following process:

Troubleshoot report performance in Power BI - Power BI | Microsoft Learn

Secondly, you can refer to the following paged report practices:
The first document will tell you how to design a paged report

Design tips for reports in Power BI Report Builder - Power BI | Microsoft Learn

The second one will explain how to get the best performance for our paginated reports from the data retrieval aspect.

Data retrieval guidance for paginated reports - Power BI | Microsoft Learn

Generally speaking, we need to reduce the number of unnecessary columns introduced into the visual objects of paginated reports. Your main data set has more than 69,000 rows. You can refer to the following optimization suggestions for large paginated reports:

Process large Power BI paginated reports - Power BI | Microsoft Learn

In the following document, we recommend that you use capacity to improve the performance of paginated reports. Make sure that each of the previous steps is optimized to the extreme, and then consider whether to use premium capacity. Since my workspace is in shared capacity without a license, it may cause performance issues.

Paginated reports capacity planning for Power BI Premium - Power BI | Microsoft Learn

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.