Customized Paging while browse in the power BI Service

[nagarajansub123]

Hi

My report fetching more than ten thousand records in sometime, they are feeling taking more time for getting records, they want to get the records by 100 or minumum size, but they want to export entire thousand records

we can do custom pagination through Stroed procedure, if we export the data then , the excel having 100 records not entire sets of the data

Is there any way to overrite the populating records in the default pagination

[alicegray]

Hey! 

When you paginate data using stored procedures or parameters, your Power BI report only fetches the visible page size data. However, overriding a default pagination directly inside a report is not possible. Instead, you can follow few steps: 

• Avoid pagination in the visual 
• Use DAX measures dynamically 
• Export data using paginated reports 
• Add a “Download All Data” Button using Power Apps custom builder 

[v-sshirivolu · Accepted solution]

Hi @nagarajansub123 ,
In Power BI, implementing pagination such as retrieving 100 records at a time through a stored procedure significantly boosts performance for large datasets. However, this approach restricts exports to only the visible data, and Power BI does not allow exporting all records when pagination is in use.

The most effective solution is to set up two queries: one optimized for paginated visuals and another that loads the entire dataset for export purposes, which can be hidden in the report. Alternatively, you can use a slicer or parameter to let users toggle between paginated and full-data modes before exporting.

For seamless exporting with large datasets, Paginated Reports in Power BI Premium are the best option, as they enable full dataset exports without these limitations.

Please refer these documentation References:

Export limitations in Power BI

What are paginated reports in Power BI? - Power BI | Microsoft Learn

Regards,
Sreeteja

[v-sshirivolu]

Hi @nagarajansub123 ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

[v-sshirivolu]

Hi @nagarajansub123 ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

[v-sshirivolu]

Hi @nagarajansub123 ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

[Akash_Varuna]

Hi @nagarajansub123 Power BI doesn’t support true server-side pagination with full export.If you use custom paging via stored procedure, only current page data gets exported.To allow full export, create a separate export page without pagination logic.Users can browse with paging and export all data from the export page.