Forum Discussion

dibaSFP's avatar
dibaSFP
Icon for Advocate I rankAdvocate I
5 years ago
Solved

Export to file (PDF/PPTX) REST API - shorten preview or lift limits?

Hi everyone,

 

Export to PDF via REST API has been made available as preview feature sind 03/2020 (https://powerbi.microsoft.com/de-de/blog/export-report-to-pdf-pptx-and-png-files-using-power-bi-rest-api/).
According to the current documentation of planned changes, GA is suprisingly planned for 09/2021 (https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave1/power-bi/planned-features).
 
As the preview status limits the exports to 50 pages per hour for the whole capacity this is a huge problem for our PBI Embedded solution. We have about 2000 reports having several pages and numerous users. 50 pages an hour is rather ... a drop.
 
Is there any way, how we could mitigate/change this limitation (and/or could someone decides to shorten the preview timeframe)?
 
Regards,
DibaSFP

7 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional

    Hey dibaSFP ,

     

    take a look at Microsoft PowerAutomate.

    There you can export a Power BI Report to a PDF. This you could trigger to start daily automatically:

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

    Best regards
    Denis

    Blog: WhatTheFact.bi

    • dibaSFP's avatar
      dibaSFP
      Icon for Advocate I rankAdvocate I

      Dear selimovd,

       

      thank you, I will take a look into the feature! But I guess it will not solve the problem for our Power BI Embedded web application and its numerous users.

       

      Regards,

      DibaSFP

      • selimovd's avatar
        selimovd
        Icon for Most Valuable Professional rankMost Valuable Professional

        Hello dibaSFP ,

         

        why not?

        You can start the export via PowerAutomate with the RESTAPI:

        Calling Microsoft Flow from your application | Power Automate Blog

         

        This can start the creation of a PDF with Power Automate and send it directly to the logged in user.

        Maybe I forgot a point, but for me it seems to be a solution.

         

        You could also think to create a paginated report and send it as PDF, this might be an easier way.

         

        If you need any help please let me know.
        If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

        Best regards
        Denis

        Blog: WhatTheFact.bi

    • Walter_Adams's avatar
      Walter_Adams
      Frequent Visitor

      There is another reason why this solution is problematic for some. Doing the "Print to PDF" via Power Automate requires a licensing of "premium capacity" which comes currently at a cost of 5000 USD per month. 
      Nice for those who already have this license but a bit on the rediculously expensive side for others who simply want to generate 1 PDF a month.