Power BI Embedded with Paginated Reports Performance Issue

[rredmer-lena]

We are experiencing a 20+ second delay when requesting a report in PDF format from the service, regardless of the capacity we have available. We have tried altering the capacity to much larger virtual machines and the delay remains. When we return the report with the viewer, the report displays in several seconds. Is there anything we can do to improve the performance of generating the PDF on the server? We are seeing very low server CPU and memory utilization in this process. We do not experience this delay when passing the PDF report output parameter to the report URL using a Premium license, this delay only happens using the Embedded services. Suggestions?

Secondly, are there any plans to provide more configurability of the report viewer? We would like to hide the menu bar, limit export options, and if we could page up/page down through the pages that would also improve usability.

[Anonymous · Accepted solution]

Hi  @rredmer-lena ,

Generally speaking, exporting a PDF usually takes quite a bit of time. Compared to several minutes to tens of minutes, 20 seconds is already quite fast.

In the operation of generating a PDF, the corresponding conversion to create the PDF file is done through Adobe’s interface. Power BI is only responsible for extracting data, transmitting data to the interface, receiving the converted file, and exporting it. Combining this with what you mentioned, ‘We are seeing very low server CPU and memory utilization in this process,’ I surmise that the main consumption in exporting a PDF is primarily in the interface’s conversion processing part.

Refer to:

Download Adobe Acrobat Reader: Free PDF viewer

If you feel that performance needs to be improved, you can also submit an idea on Home (microsoft.com)  and wait for users with the same needs as you to vote for you and help you realize the idea as soon as possible.

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.