Paginated report performance issue

[SmilikaL]

I have been working paginated report, the report loading is really long time almost 1min and export to excel of the same report it take 2min but when I ran the same query with the same paramters in dax studio it took 6-9 sec. Could you someone help me to get the solution of workarounds to improve the performance. Thanks in advance

[Anonymous]

Hi @SmilikaL 

It looks like your paging report is experiencing performance issues. Here are some possible ways to mitigate:

Check if most of your time is spent retrieving data.

If rendering time is an issue, try simplifying the layout and formatting of your report.

Sometimes, delays can be caused by authentication to the source database.

Solved: Paginated Report slow first time it is run (Power ... - Microsoft Fabric Community

If a local data gateway is used, the cost of opening and closing the connection can be high.

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

Regards,

Nono Chen

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