Dropdown values for Paginated Reports in Power BI service are very slow to load

[aishahslmn]

Hello, I created a few paginated reports with dynamic dropdown but the values in the next dropdown takes a very long time to load. The datasource is from SQL Server. This happens when I run the report in Report builder and Service. Can someone explain why is this happening and the solution to this? 

Thank you in advance.

[Anonymous]

Hi  @aishahslmn ,

Here's a related case, you can check out:

Solved: Extremely slow paginated reports due to high conne... - Microsoft Fabric Community

If you didn’t use a gateway, you can follow this document to troubleshoot report performance in Power BI:

https://docs.microsoft.com/en-us/power-bi/guidance/report-performance-troubleshoot

This is the related document, you can view this content:

Solved: Paginated Reports in Power bi service are very slo... - Microsoft Fabric Community

Paginated Reports Rendering Extremely Slow - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.