Forum Discussion
Optimizing Power BI Report Builder performance
Thanks Jianpeng Li for sharing the resources and links to optimize. I now understand that I am using dataset paramter to fetch data for subreports based on Project ID. I will try to change the approach and use dataset filter or Tablix filter to fetch the data for subreports only once and display the data in subreports based on Project ID. While I work on changing the approach, my understanding is the subreports dataset are queried for each row in the main report with 69,000+ rows. Please confirm and also if my assumption is correct, is there a way to stop refreshing the subreport datasets for every row in main report. This would definitely improve the process as well as performance.
Hi, manhil29
The paging report refreshes at the page level, and I didn't find the option or documentation related to limiting row refreshes. You need to optimize your query by following the tips above. Then enable more load for your paged reports in power BI service.
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.
Thanks Jianpeng Li! I was busy making changes into my report builder files using the links you shared. Here is what I observed based 2 approaches I took.
Just to repeat, I am using Power BI Semantic Model as data source for all of my reports, and my main report has 70K+ records (now) and it has 3 subreports (one with 79K+ records now, and the other two have 285K+ records in total).
Approach 1: I used Query Paramter to get the records from Dataset for subreports
Observation: The process to fetch the data is slower. The approximate number of records for subreports for each row in main report varies between 0 and 50. I allowed the report to run for almost 8 hours and the rows fetched were nothing more than 80K+ and the report was never displayed.
Approach 2: I fetched all the records for subreport datasets in single attemp and applied table level filter to display the records for subreports
Observation: The process went on for 8+ hours but never completed. It fetched almost 125 million+ rows in total but the report was never displayed.
I presume in both of the appraoches, the report server fetches the subreport datasets for each row in the main report. Is there something I am missing or doing wrong?
Best,
Manhil29