Forum Discussion

nagarajansub123's avatar
nagarajansub123
New Member
1 year ago
Solved

Customized Paging while browse in the power BI Service

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 expo...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

alicegray's avatar
alicegray
Icon for Helper I rankHelper I
1 year ago

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