Forum Discussion

mmmmm_98's avatar
mmmmm_98
Frequent Visitor
1 year ago

Paginated Reports Rendering Extremely Slow

Hi i need some clarification,
i created a paginated report and the source for the paginated report was power bi semantic model but now im confused why when i load the power bi report normal report that using the same semantic model as paginated report didnt take so much time to load compare to when im opening the paginated report?

1 Reply

  • Hi mmmmm_98 - Paginated reports are built to handle vast amounts of data, often for print-ready outputs. The report generator retrieves the entire dataset and formats it for all pages before displaying it. This "all-at-once" approach can slow down performance compared to the dynamic, on-demand loading in Power BI reports.The slower load time of your paginated report compared to the standard Power BI report, even though both use the same semantic model, can be attributed to fundamental differences

     

    Standard Power BI Reports: These leverage in-memory processing for interactive visuals. They query and render only the necessary data for the current view, which is more efficient and leads to faster load times​Optimize your dataset and queries by reducing the volume of data fetched.Review the complexity of your report layout and parameters.If hosted on shared capacity, consider upgrading to Premium capacity for better resource allocation.

     

     

    Ref: Links

     

    Paginated reports in the Power BI service - Power BI | Microsoft Learn

    Troubleshoot report performance in Power BI - Power BI | Microsoft Learn