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!