07 Mar Creating Paginated Reports in Power BI Report Server

Paginated reports are reports created to be printed or shared. From the name, they are formatted to fit well on a page. Paginated reports can be used to run many pages and are usually laid out in a fixed format which has detailed customization. They are stored and managed on the Power BI Report web portal and we can edit them using the Report Builder. This report can as well be viewed on the browser or on a mobile device. In this post, we will learn how to create paginated reports in Power BI report server.

How to create Paginated Reports using Report Builder

The first step is to install a report builder to create reports for Power BI Report Server. We can install using the procedure below;

• Navigate to the Power BI Report Server web portal
• Select New
• Select Paginated Report.

This will guide you through the installation process.

After it has been installed, Report Builder opens to the New Report or Dataset screen.

We then Select the wizard for the kind of report we’re interested in creating which might be table or matrix, chart, map e.t.c.

The Chart Wizard

Let’s demonstrate further by clicking on the chart wizard to show how we can create a visualization in a report.

After selecting the Chart wizard, we will see “Choose a dataset”, bring in our dataset or choose a shared dataset on a server.

Then choose our chart type. For example, Bar, Column, Area, Line. We will use the Bar chart type in this tutorial.

Afterwards, we arrange the fields by dragging them to the Categories, Series, and Values boxes.

we then Select Next → Finish

Design your report

Now we’re now in the Report design view where we take a step further to design our report.

We can view our data by clicking on Run and as well go back to the Design view by selecting Design.

There is an availability to modify our chart to what we want exactly by changing the layout, legends, values and also add any visualization ranging from map, matrixes, tables e.t.c. You can also add headers and footers for multiple pages.

Save the Report to Report Server

When we’re done working on our report, we can save it to the Power BI Report Server using the following;

1. Open the File menu.
2. Select Save as, and save it to the report server

Afterwards, you can view your report on the browser.

Conclusion

In this post, we have learnt how to create paginated reports in Power BI by following the steps above.