Paginated report is slow - Load data page by page

[Swethr09]

Hi Community,

Paginated report is slow even with a simple query. And I already have filters and parameters in place. I was wondering if there is a way to load data page by page. Like, Report will first load the data of first page, display it and load the data of other pages on background. Is there any way to achieve this and will it improve the performance?

[v-yiruan-msft · Accepted solution]

Hi @Swethr09 ,

Power BI Paginated reports are designed to work on a page-by-page basis. This means that the report is sent one page at a time, which can help with performance. However, if you’re still experiencing slow performance, there could be several factors at play. Here are some suggestions to improve the performance of your Power BI Paginated reports:

Design the report to support pagination: As mentioned earlier, paginated reports send a report one page at a time. Designing your report with this in mind can help improve performance. 

Optimize your data retrieval: Make sure your data retrieval is efficient. This includes using stored procedures, limiting query result sizes, and optimizing field names.

Limit access to the report: You can configure the report to use item-level security. This can help improve performance by limiting the number of users who can access the report at any given time.

Check your capacity settings: In your workspace settings, under Admin Portal -> Capacity Settings, you can specify a memory (capacity) provided for the paginated reports to be used on the Power BI Service.

Consider upgrading your capacity: If many users are opening the report at specific times of the day or month, you might consider increasing query throughput by migrating the dataset to Azure Analysis Services, or a Premium capacity.

Best Regards