Low code authoring of paginated reports

nisrinivasan1 · ‎07-25-2023

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.

Low_code_authoring_of_paginated_reports

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.

Low_code_authoring_of_paginated_reports

You can also create a paginated report from your Workspace. Choose the dataset and select “Create paginated report”.

Low_code_authoring_of_paginated_reports

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.

Low_code_authoring_of_paginated_reports

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.

Low_code_authoring_of_paginated_reportsYou 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.Low_code_authoring_of_paginated_reports

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.

Low_code_authoring_of_paginated_reports

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.

Low_code_authoring_of_paginated_reports

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.

Low_code_authoring_of_paginated_reports

The video below walks you through the steps as well.

https://www.youtube.com/watch?v=y26Ob07WjVc

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.

Low_code_authoring_of_paginated_reports