You are currently viewing Power BI Paginated Report
Power BI paginated reports

Power BI Paginated Report

Paginated Report is a very functional feature of Power BI reporting that does not get talked about enough probably because Power BI desktop is screen-centric and does not require printouts to be utilized. In this article, we would learn about what paginated reports are, why we need them, how to create them, and what benefits they bring to your business.

What are Paginated Reports?

A paginated report is simply a tabular report formatted to fit well on a page(s). Paginated Reports make your reports more print-friendly and pixel-perfect. They are called pixel-perfect because it gives users control over the page layout of their report i.e., what is printed on paper looks exactly like what is seen on the screen. Paginated reports are ideal for creating sales invoices, receipts, purchase orders, and generally, tabular data. Power BI paginated reports are descendants of SQL Server Reporting Service (SSRS), a reporting software hosted on SQL Server, which was first introduced in 2004. The same file extension (.rdl) as SSRS reports are used by paginated reports. This makes it easy to create paginated reports from SSRS reports.

Why do you need them?

In comparison to printing regular Power BI reports that contain tables, only the rows that can be seen on the page will be printed but with a paginated report, you have the entire report printed out into several pages. In the table below, you’ll see that not all rows are visible, and users may have to use the scrollbar to see other rows. When we try to print this, only the visible parts on the screen get printed.

 

Differences between a Paginated Report and Power BI Report