cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Power BI Embedded: Exporting to PDF/PPTX/PNG very slow

Hi everyone,

 

exporting from Power BI service works fine. Exporting to PDF/PPTX/PNG from Power BI Embedded using the available API is awfully slow. A (very) simple report requires about 45 seconds. Anything more complex requires way more time (beyond several minutes).

 

Is there a way we can request more CPU/ressources for Power BI Embedded exports?

 

Regards,

DibaSFP

3 REPLIES 3
Highlighted
Resolver II
Resolver II

Re: Power BI Embedded: Exporting to PPTX/PNG very slow

HI @dibaSFP 

If you are using the Export-To API https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofileingroup then there are some limitations on this whilst the API is in preview.

Looking at the docs on this functionality, ac couple of things stand out: https://docs.microsoft.com/en-us/power-bi/developer/embedded/export-to

 

Concurrent Requests:
"A job that exceeds its number of concurrent requests doesn't terminate. For example, if you export three pages in an A1 SKU, the first job will run, and the latter two will wait for the next two execution cycles."

Note that concurrency also applies to pages within a report. So a single report containing 20 report pages/tabs will not complete until each one is rendered individually. How fast this is will depend on the capacity size.

Embedded Capacities:
You need to have the reports hosted within a workspace that is running within an embedded capacity.
The larger the capacity... the more reports you can run concurrently, plus (in theory) your reports should render faster due to the increased CPU and memory.

It could be the case that whilst this feature is in preview, it is running slower than it otherwise would normally?
It's worth testing it with a larger capacity to see if this makes any difference.

Hope this helps.

Highlighted
Frequent Visitor

Re: Power BI Embedded: Exporting to PDF/PPTX/PNG very slow

Hi Matt,

 

thanks for the information.

 

>It could be the case that whilst this feature is in preview, it is running slower than it otherwise would normally?

I hope so.

 

I have seen the limitations, but being at P2 (would be A5 in Azure) I expected a way higher performance - especially, if you are the only user exporting a report.

 

Just as a reference the announcement from 03/2020 on the availability of the feature:

https://powerbi.microsoft.com/de-de/blog/export-report-to-pdf-pptx-and-png-files-using-power-bi-rest...

 

Maybe it gets better over time (or we have to ask support to forward this feedback to the PBI Embedded Product Manager ;-)).

 

Thank you!

 

Björn

Highlighted
Resolver II
Resolver II

Re: Power BI Embedded: Exporting to PDF/PPTX/PNG very slow

Yikes! an A5 capacity but still running that slow.... that doesn't sound right.

Think it might be time to raise a support call to see if MS can identify what is happening.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors