The export of paginated reports is slow

[jonyzhang]

I have an embedded paginated report that queries our own MySQL database, which contains approximately 10000 pieces of data. It takes a long time to export to Excel on the Power BI web or desktop, with a total export time of approximately 3000 pieces of data taking 30 seconds. However, it only takes about 0.7 seconds for me to directly query MySQL using the executed SQL.

[jonyzhang · Accepted solution]

After localization, the main cause affecting performance has been identified. The problem is still with the configuration of this PBI report itself. In the last column (image column), do not select any values in the red box of the screenshot (PBI may download each image during rendering). Leave it blank

[v-xiandat-msft]

Hi @jonyzhang ,

You can try this:

Data Model Optimization: Ensure that the data model in Power BI is optimized for performance. This includes minimizing the number of columns, avoiding unnecessarily calculated columns or metrics, and ensuring that indexing is done correctly in the MySQL database. A well-structured and optimized data model can significantly reduce the time required to export data.

Exporting large amounts of data may encounter certain limitations or timeouts. Please consider filtering or reducing the amount of data exported at one time!

Consider using an API to mitigate slow times

Export Power BI embedded analytics paginated reports API - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

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

[jonyzhang]

Then I looked at the metrics for downloading the report and found that the Rendering time actually took 120 seconds