Help: Paginated Report embed PowerBI has freeze issue when fetching data

[NamNguyen0311]

Hi everyone,

I use paginated as a tool to extract csv and use power bi as interface and filters. During the process of fetching data I often encounter freezing like in the article below:

https://community.fabric.microsoft.com/t5/Desktop/Paginated-Reports-Fetch-limit/td-p/2449787

When using 1 user to fetch data, I can get more than 2 million easily.

Even though my capacity is set to high performance at P4 Premium, I still encounter the above situation when 2-3 users are active at the same time and the amount of data frozen when reaching the 1.6 million data mark.

I don't know how to handle this issue at the moment, please give me advice to improve.

Thank everyone.

[Anonymous · Accepted solution]

Hi, @NamNguyen0311 

Thanks for the info! Based on your description, it is true that when multiple users load more than a million rows of data at the same time, the consumption of CUs increases significantly, resulting in a freeze issue when fetching data.

Fabric operations - Microsoft Fabric | Microsoft Learn

Capacity and SKUs in Power BI embedded analytics - Power BI | Microsoft Learn

Here are some recommendations to help you optimize the performance of your paginated reports:

1.Apply query parameters in paginated reports to ensure that only the necessary data is queried before it is rendered, which can reduce unnecessary burden.

Create parameters for paginated reports in Power BI Report Builder - Power BI | Microsoft Learn

2. Try to coordinate multiple users to access a large amount of data at the same time to avoid excessive consumption of CUs.

View diagnostics for Power BI paginated reports - Power BI | Microsoft Learn

3.Consider using a data warehouse, lakehouse, or other tool to store data in a semantic model. Paginated reports can read data from the semantic model, which takes advantage of the fast data reading capabilities inside the Power BI service.

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

Try limiting the number of rows per page in a paginated report to reduce the amount of data per load and improve responsiveness.

Process large reports - SQL Server Reporting Services (SSRS) | Microsoft Learn

SSRS Best Practices for Performance and Maintenance

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

Power BI paginated reports are essentially the same as ssrs, and children are paginated reports. The optimization approach to ssrs is basically applicable to Power BI paginated reports.
The above is what I can think of at the moment and the optimization method provided by the documentation.

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.