Create Paginated Reports in Power BI

Introduction to Paginated Reports

  • Descendant of SQL Server Reporting Services. 
  • Created in Power BI Report Builder. 
  • Part of Power BI Premium or power BI Premium Per user. 

When are they the right fit?

  • Operational reports with tables of detail. 
  • Headers and footers are needed. 
  • Customized sort orders. 
  • Clickable headers. 
  • Rendering tabular data. 
  • Data is located in separate Power BI workspace 

Getting Data

The first step in creating a report is to get data from a data source. Though this process might seem similar to getting data in Power BI, it is different. Power BI paginated reports do not use Power Query when connecting to data sources. 

Getting data in a Power BI paginated report does not involve data cleaning steps. In fact, data is not stored in a Power BI paginated report dataset. When data is refreshed on the report, it is retrieved in an unaltered form from the data source, according to the query that was used to retrieve it. 

Create a Paginated Report

Similar to Power BI, add visuals to the design surface. 

Work with Charts and Tables

Two ways to add a chart to your report are: Select the Chart button, select Insert Chart, and then draw your table on the canvas. 

Right-click the report canvas, select Insert, and then select Chart

Publish the Report

To publish your report, select File >Save as and then select Power BI Service. Your report will now appear in Power BI service.  

You can upload paginated reports to your My Workspace or any other workspace, as long as the workspace is in a Premium capacity. 

Kirjoittaja Tero Ramu on konsultti, joka on T-Basella tutustunut aiheeseen.


Ota yhteyttä, jos tarvitset apua Power BI:n kanssa tai olet kiinnostunut muista palveluistamme. Autamme sinua mielellämme.

Ota yhteyttä

Seuraa meitä somessa:




Tutustu myös näihin: