Forum Discussion

mlardner's avatar
mlardner
Frequent Visitor
3 years ago
Solved

Export to PDF limitations

When i export Power BI to PDF i am unable to export all of the page, it just exports the information viewed on the screen.

I am trying to export a list of metrics via 'Power BI Metrics'. I have seen this issue mentioned numerous times on this forum, often dating back some years (2017 in some cases) and am hoping this issue has been rectified by now (Jan 2023) Is this still a limitation of Power BI exporting to PDF, or is there another way around this i have not discovered? Please help!

  • Hi , mlardner 

    Unfortunately, in the use of Power BI, I didn't find a feature that could export a certain visual as a PDF separately.
    If you are presenting on a computer, you can try exporting a Live PPT.

    For more information, you can refer to :
    Add a live Power BI report page to PowerPoint - Power BI | Microsoft Learn

    Also, as mentioned above, you can try using paginated reports.

    Paginated reports are designed to be printed or shared. They're called paginated because they're formatted to fit well on a page. They display all the data in a table, even if the table spans multiple pages. You can control their report page layout exactly. Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service.

    For more information, you can refer to :
    A Step-by-Step Overview of Paginated Reports in Power BI (bluegranite.com)

     

    Also for your needs, you can also publish your idea to our website to optimize this product:
    Ideas (powerbi.com)

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

     

10 Replies

  • Hello, I have the same problem and I can not understand how a tool like this does not allow you to export to PDF the entire report and not only what you see on the screen. Very disappointed

  • mlardner's avatar
    mlardner
    Frequent Visitor

    Hi,

    the screenshot below shows the screen i have produced in Power BI Metrics.

    The page contains 24 metrics, however on the screen you can just see the first 6 metrics, to view the rest you have to use the scroll bar on the right hand side.

     

     

    Unfortunately when you export this to PDF it pnly includes these first 6 metrics and not the full 24 metrics. (as seen below on the PDF output)

     

     

     

    • v-yueyunzh-msft's avatar
      v-yueyunzh-msft
      Community Support

      Hi , mlardner 

      Sorry for misunderstanding your need , this is a limitation for exporting report to PDF.

      Exporting a PDF can only export what the current report page looks like, as Super User says, you can try to create paginated reports and also implement the export of your long visual PDF.

      You can try to set the page configuration, make the page size more long to fit your visual without the scrollbars.

       

       

      For more information, you can refer to :
      Page display settings in a Power BI report - Power BI | Microsoft Learn

      If this still can not meet your need , i think you can try using the paginated report mentioned by super user.

       

       

      Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

       

      Best Regards,

      Aniya Zhang

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

      • mlardner's avatar
        mlardner
        Frequent Visitor

        Hi,

         

        Thank you for your response, really appreciate it. Unfortunately by chaging the page configuration will not work, as there are too many metrics to fit onto 1 page still.

        The majority of our reporting involves a large number of metrics, which need to be viewed in a quick basic template. So we will always need to present these metrics over more than 1 page.

        This is really frustrating that 1 of the principles of Power BI Metrics is a ready to use template to create quick, scorecards with the facility for unlimited metrics built on top of each other in a long list.

        To then not have the option to export ALL of these metrics to PDF simply and quickly is really surprising, and a significant limitation. (other performance management systems are able to cope with this concept)

        i appreciate these reports are largely used interactively, but there is still the demand to export these reports and be used as hard copies for circulation at meetings.(certainly within our organisation anyway!)

        thanks agian for your help ☹️ 

  • mlardner's avatar
    mlardner
    Frequent Visitor

    thanks, what is the best/quickest way to do this in Power BI pro?

    Is this done by clicking on 'download' then 'paginated report builder'??? (this then asks me to purchase for £59.99 a year)

  • Hi , mlardner 

    According to my test in my side , i can export PDF for multy-pages in the report.

    You can not select the "Only export current page" options.

    And we can also export the "Power BI Metrics usage report" , we can view it and "save a copy" to our workspace and then export it to PDF .

    And the export to PDF limitation, you can refer to the document:
    Export reports to PDF - Power BI | Microsoft Learn

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

     

  • Hello, 

    First, you will have to publish your report online in your working space. Once the report is uploaded, open your report and click on export to pdf.