Edit

Share via


Create paginated reports that you can export in the Power BI service (Preview)

APPLIES TO: Power BI service Power BI Report Builder Power BI Desktop

In this article, you learn how to create a paginated report with all the data from your Power BI semantic model, and then export it. The feature lets you quickly create a paginated report on the web, and apply styling. You can then export it using the rich export functionality of paginated reports, which retains the applied formatting & styling.

You can use the feature to create paginated reports in any workspace in the Power BI service, including workspaces that aren't in a Power BI Premium capacity.

Prerequisites

See the Prerequisites section in Get started creating paginated reports in the Power BI service.

Get started

See the article Get started creating paginated reports in the Power BI service for all the ways you can get started creating paginated reports in the Power BI service.

No matter which way you start, the new paginated report online editing experience opens.

Create a table

To create the table, select field names in the Data pane on the right. This pane gives you a table-and-column based view of the chosen dataset. When you find a column that you wish to add to your table, select the column.

Screenshot of selecting fields.

The selected columns appear in the Editor portion of the canvas. Give the editor a few moments to run the query on the dataset. The formatted table shows up in the Preview section of the canvas.

Screenshot of formatted table preview.

This viewer shows you a preview of your currently unsaved paginated report. Use this pane to make sure everything in your report looks good before editing or saving the report.

If columns are in the wrong order in the Build pane, don't worry. You can easily reorder the columns in the Build pane columns by dragging the columns into the desired order.

Screenshot of dragging items.

When you select a field, we use the default aggregate set on the field. You can change the aggregate behavior. Select the arrow next to the field item in the Build pane.

Screenshot of possible aggregations.

Format the table

You can format the table from the Build pane or from the Editor ribbon. In the Build pane, you can format the table using the built-in format options.

In the Build pane, select the Format tab.

Select the drop-down arrow in the Style box, and experiment with the available styles.

Screenshot of styling options.

In the Editor:

  1. To resize the width of the columns, hover over the edge of a column header, and drag the double-headed arrow that appears.

    Screenshot of resizing the width of the columns.

  2. To edit the text in a column header select the header you would like to edit, double-click and make your changes.

    Screenshot of editing text in a column header.

  3. To sort the table on a column, select the sort icon in the column header.

    Screenshot of sorting during authoring.

    After you sort it, you see the arrow icon showing the direction of the sort on the column.

    Screenshot of sorted column in authoring.

  4. Insert textboxes, images, headers and footers from the ribbon.

    Screenshot of insert ribbon in authoring.

    Note

    To revert to using the original column header based on your data source, remove and add the field again in the Data pane.

    When you export to CSV, it doesn't reflect the renamed column name. To learn more, see data renderer formats.

Edit a paginated report

If you are Viewing a paginated report that you've authored in the Power BI service, you have the option to edit the report by switching to Editing

Screenshot of Edit button.

Add images to the paginated report

Add images to the body of the paginated report

For any paginated report that you author in the Power BI service, you can insert images above or below the table in the report, into the header or footer of the report.

  1. To add an image to the body of your report, select Insert, then Image.

    Screenshot of insert image button.

    Note

    At this time, you can only insert images from your local machine or external images that are available over the internet without needing authentication.

  2. After you insert the image, you can use the Picture format tab to set an Alternate text for the image, set padding options, or set the display size option.

    Screenshot of picture format options.

To learn more about external images, refer to Add external images to paginated reports.

  1. To add images to the header or footer of the report, select Insert, then Header or Footer.

    Screenshot of picture insert header or footer.

  2. Select Image, then the location and click where you want to place the image within the header or footer.

    Screenshot of insert image web authoring.

    Screenshot of insert image cross hair.

Add text to the paginated report

For any paginated report you author in the Power BI service, you can insert text boxes above or below the table in the report, as well as the header or footer of the report.

Add a text box and begin typing

  1. To add a text box to your report, select Insert and then Text box.

    Screenshot of insert text box button.

    Note

    When you insert a new text box or select a text box, you're immediately editing the text in the text box.

  2. Begin typing within the text box.

Select, move, and resize text boxes

  1. To select a text box, click on the text box and a text box outline appears.

  2. To move a selected text box, select and drag the move indicator on the text box outline.

    Screenshot of moving a text box.

  3. To resize a text box, select the text box itself and then select and drag any sizing handle. Alternatively, press the SHIFT + arrow keys to resize horizontally or vertically.

    Note

    Text that doesn't fit within the text box area may show only while the text box is selected. Text outside the text box area doesn't show in the final design of your report. Resize the text box area to show the text you would like visible.

Format and style text in a text box

  1. After you select a text box, the Text box format tab is displayed. From this tab you can format the font style, including font, color, size, and text decoration like bold, italics, and underline.

    Screenshot of text styling options.

  2. You can format font styles at the character and line level while you're editing the text box. Or select the text box to highlight all text and format all text within the text box at once.

Delete a text box

To delete a text box, right-click a text box and select Remove. Alternatively, with a text box selected press DELETE.

Considerations and limitations when working with text

  • As with other objects in a report, you can only select one text box at a time.
  • Text boxes can't be duplicated, or copied and pasted. You can highlight, copy, and paste text within text boxes.
  1. To add a header to the report, select Header from the Insert option on the ribbon.

    Screenshot of header/footer.

  2. You can add a textbox, images, page numbers or execution times in the header/footer. You can also unselect Show on first page or Show on last page if you don't want the header/footer to be displayed on those pages.

    Screenshot of header footer options.

  3. Once you are done creating your header/footer, you can exit either by selecting the Close Header or Close Footer option or double clicking outside the header or footer area.

    Screenshot of close header footer options.

Considerations and limitations when working with headers and footers

  1. You must exit the header or footer before you can continue editing the body of the report.
  2. The format of the page number is limited. We only support absolute page numbers.

Export your report

You can export the table before or after you save it. Paginated reports have rich export capabilities to any of the supported formats, preserving full fidelity. The exported report is saved to your default Downloads folder.

For the table, DataElementName is generated using CLS-compliant format of <table_name>_<column_name>. In CSV, this controls the name of the CSV column header. To update the value for the generated DataElementName, download the report and edit it with Power BI Report Builder. To learn more, see data renderer formats.

Screenshot of list of export formats available.

Save your report

You can save the report to any workspace.

  1. On the File menu, save, download, or print your report.

    Screenshot of File menu.

  2. In Save your report, give your report a name and select a workspace.

    Screenshot of Save menu.

After you save the report, you see a success or failure notification in the top right of the editor.

  • If a report already exists where you have chosen to save, it asks you if you wish to overwrite the existing report.
  • If it succeeds, you see a link to the report. You can either follow this link or continue editing.

Considerations and limitations

  • You can create a paginated report in any workspace.
  • You can't create a paginated report from Power BI semantic models based on a live connection.
  • The online editor does not replicate all existing Power BI Report Builder functionality.
  • The online editor doesn't support hierarchies.