We are excited to introduce an easy new way to create and export paginated reports on the Power BI service. You can create a simple paginated report such as an inventory report with an image, textbox and a table. You can export, save or share these reports. These reports can be created from a Power BI dataset by following the steps below:
In Power BI’s left navigation pane, select the “OneLake data hub” to open a page where you can select your dataset/ datamart. You can read more here.
Choose a dataset and select “Create paginated report”. You may see variations such as “Create operational report”. Today we support creating a paginated report from existing Power BI datasets, datamarts and Fabric data warehouses.
You can also create a paginated report from your Workspace. Choose the dataset and select “Create paginated report”.
You will see an editor canvas. You may choose to insert an image (say, a company logo) or textbox at the top of your report. Read more about inserting images and textboxes.
You can also select columns from the “Data” pane. Selecting columns will add a table with a preview of the data to the report editor canvas.
You can change the aggregation by selecting the dropdowns in the Build pane. You can also add/remove totals or disable totals for all columns, from the toolbar.
You can filter the data in your table by applying filters. If you don’t want a column to appear in the table but do want to filter by it, you can drag and drop the field to the filter or right click on the Data pane. Read more about adding filters when you create paginated reports in the Power BI service.
Edit column headers or re-position your table as desired. Re-naming the column header will NOT modify the column header in your dataset, only in the table in the report.
Once you create the report, you can export to accessible pdf or Excel. All formatting including the new column header names, images and text boxes will be preserved.
The video below walks you through the steps as well.
You can also look at the diagnostics of the report from the “View” tab in both “Editing” and “Viewing” modes. Read more about diagnostics for paginated reports.
Editing mode:
An example of the Diagnostics looks like below
Follow Power BI blogs for regular updates on paginated reports!