Редактиране

Споделяне чрез


Export reports from Power BI to PDF

APPLIES TO: Power BI Desktop Power BI service

You can export your Power BI reports to PDF easily, both from the Power BI service and from Power BI Desktop. Exporting to PDF is one way to share or print reports.

When you export to PDF, each page in the Power BI report becomes an individual page in your PDF document.

If your report has a sensitivity label, the label and any encryption settings carry over to the exported file, ensuring that your data remains protected even after it leaves Power BI.

Note

In Desktop, sensitivity label inheritance by the PDF is a preview feature that is on by default. You can turn off sensitivity label inheritance in PDF export in Desktop by going to File > Options and settings > Options > Preview features, and unchecking Enable setting sensitivity label on exported PDF.

Export to PDF from the Power BI service

  1. In the service, select a report to display it on the canvas. You can select a report from your Home page, Apps, or any other container from the nav pane.

  2. In the Power BI service, select Export > PDF from the menu bar.

    Select Export from the menu bar

    A pop-up appears where you can select Current values or Default values. Current values exports the report in the current state, which includes the active changes you made to slicer and filter values. Most users select this option. Alternatively, selecting Default values exports the report in its original state, as the designer shared it, and doesn't reflect any changes you made to that original state.

    Additionally, there's a check box to select whether or not to export the hidden tabs of a report. Select this check box if you want to export only report tabs that are visible to you in your browser. If you prefer to get all the hidden tabs as part of your export, you can leave this check box cleared. If the check box is grayed out, there are no hidden tabs in the report. After you make your selections, select Export to continue.

    You may also choose to export only the current page you're viewing in a report by checking the Only export current page option. By default, this option is unchecked and all pages are exported from your report.

    A progress bar displays in the upper-right corner. Exporting might take a few minutes. You can continue to work in the Power BI service while the report is being exported.

    Export progress message

    After the Power BI service finishes the export process, the notification banner changes to let you know. In Microsoft Edge, you are prompted to save or open the PDF.

    Select to open or save the PDF.

    In Google Chrome, the file options display in the lower left corner of the browser.

    Lower left corner of Chrome browser showing PDF options

    If you make no selection, by default, the PDF is saved in your Downloads folder.

Considerations and limitations

There are a few considerations and limitations to keep in mind when you work with the Export to PDF feature.

If you don't see the Export option

Visuals that aren't supported

The following aren't supported for Export to PDF. Either the PDF export option is grayed out or isn't listed at all on the Export dropdown. In some cases, such as for R visuals, the report exports but the visual renders as a gray box with an error message.

Reports that can't be exported

  • Power BI reports with more than 50 report pages currently can't be exported. Paginated reports don't have this limitation. See Print a paginated report for details.
  • Reports larger than 500 MB.
  • Reports that are owned by a user outside your Power BI tenant domain, such as a report owned by someone outside your organization and shared with you, can't be published to PDF.
  • You can share a dashboard with someone outside of your organization--someone who isn't in your Power BI tenant. However, that user can't export the shared dashboard's associated reports to PDF. For example, if you're aaron@contoso.com, you can share with cassie@northwinds.com. But cassie@northwinds.com can't export the associated reports to PDF.

General

  • Export to PDF isn't supported when the admin setting Azure private link > Block public internet access is enabled in Power BI. In this case, the export fails. The export might also fail if the admin setting Azure private link is on and Block public internet access is off.

  • Semantic model refresh operations using an XMLA endpoint.

  • In the Power BI service, URL filters aren't currently respected when you choose Current Values for your export.

  • Visuals displayed as a Data table or displayed with "Show as a table" are included in the export, but the visual displays in its default state, without the table.

  • The process of exporting the report to PDF might take a few minutes to complete, so be patient. Factors that can affect the time required include the structure of the report and the current load on the Power BI service or Power BI Desktop.

  • Background images are cropped with the visualization's bounding area. Also, when you export to PDF with reports that contain a background image, you might see a distorted image in the export if you use the Normal or Fill options for the Page Background. For best results, use the Fit option to avoid issues with your exported document. Or, remove backgrounds before exporting.

  • The Power BI service uses your Power BI language setting as the language for the PDF export. To see or set your language preference, select the cog icon Screenshot of the cog icon. > Settings > General > Language.

  • Reports with unusual custom page sizes may experience issues in export scenarios. For best results, consider switching to a standard page size for your report.

  • Reports using themes with custom fonts will have the custom font replaced with a default font.

  • While we look to provide a consistent experience, we can't guarantee the exported PDF from the Power BI service will always match the exported PDF from a local Power BI Desktop file.

  • We can't guarantee precise fidelity for Power BI reports. The resolution of exported report pages is 1,280 pixels x 720 pixels.

  • Visuals with scrollbars are exported in their default state. The visual displays all possible rows, starting with the first row. Even if you have the visual scrolled down, when exported, the visual displays unscrolled.

  • Export to PDF supports Unicode 6 and earlier. If for example, Unicode 7 is used, Power BI export displays that image as a blank box.

    Export visual with scrollbars.

  • Visuals in a drilled down state are exported in their default state.

  • The feature doesn't export any wallpaper you apply to the report. Since wallpaper isn't exported to the PDF, you should pay special attention to reports that use dark wallpaper. If the text in your report is light or white, it is difficult to read in the export to PDF process since the dark wallpaper isn't exported with the rest of the report.

  • All Power BI reports have a page margin when exported to PDF. That is, there is a band of white space at the top and bottom of the exported file.

  • If you acess a report using a bookmark, the exported report displays with the bookmark filters applied. Any filters applied at the time of the export are ignored. You can get around this by creating a bookmark with the required filters and then export the report.

  • Export to PDF isn't currently supported for tenants in the China North region.