Paginated report is loading slow

[julsr]

Hello everyone,

I have a paginated report with some filters that are being retrieved by an SQL code to bring data to the report but when doing it in PowerBI it takes more than 30 min to load but when I execute the query on SQL it runs in about 90 seconds. What could I do to improve the performance of my report?

Thanks

[bradsy · Accepted solution]

Couple of articles for you: https://learn.microsoft.com/en-us/power-bi/guidance/report-paginated-data-retrieval 

 and https://darren.gosbell.com/2023/10/diagnosing-performance-of-paginated-reports-in-power-bi/ 

[julsr]

Thanks!