Export paginated report to file is Slow

[Nemanja_Utilyx]

Hello,

We have Power BI Premium license and we want to show report image on our home page.

I am using the demo code: https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-paginated-report 

Problem is it takes average of 25 seconds to get the file from server and therefor not applicable for our usecase. 

Is there something I'm missing or is this intentionally slow?

[Anonymous · Accepted solution]

Hi @Nemanja_Utilyx ,

As far as I know, the long time waiting to export to PDF/Excel can be a limitation that is explained in the document:

• The process of exporting the report to PDF might take a few minutes to complete, so be patient. Factors that can affect the time required include the structure of the report and the current load on the Power BI service.

For reference:

Limitations of exporting reports from Power BI to PDF

Export Power BI paginated reports (Power BI Report Builder) - Power BI | Microsoft Learn

Please check the workload of your capacity at the same time, too heavy workload may cause this problem, as well.

I also suggest you to try to turn off Automatic Decompression which is on by default. Some user imporve the performance by this way.

Best Regards,
Rico Zhou

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