In this blog, I will discuss how to create paginated reports in Power BI.
First, run your Power BI desktop.
Data Sample
Prepare the sample data in an Excel sheet. Please check the below figure.
Load Data
Click on the GetData icon.
![]()
In the navigator window, please select the respective Excel worksheet and click on the "Load" button.
![]()
Design Report
Please observe the below snapshot on the right side. The columns are available under the Field tab.
In the visualization pane, please find the 3 dots and click on that and select the IMPORT FROM MARKETPLACE option, so that we can import the new visualization by clicking the "ADD" button.
Add Grid by MAQ software visualization.
Onclick of that icon, Grid BY MAQ, the visualization will appear on your page layout. Click on the checkbox which is in Fields pane.
Fields pane => sheet3 => click on checkboxes.
For designing a paginated report, click on the FORMAT option and use the below information.
- Grid Configuration - you can customize table data text size and pagination for maximum rows
- Title - you can add a title (change color, font etc).
- Background - you can add a background color to your report.
- General - you can set the height and width of the report.
- Border - you can set border for your report.
Please find the below snapshot for the designed report.
![]()
Summary
That's all.
We just used Power BI to get data from an Excel sheet and generate a paginated report.