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

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.