topic Power Bi Report Builder(Paginated Report) Dynamic in Report Server

Power Bi Report Builder(Paginated Report) Dynamic

SaulGarcia — Thu, 07 Aug 2025 08:51:39 GMT

Hi! good day everyone, i have question, this is the environment :

* Power bi Report builder

* Datasource is from semantic model

* to create dataset is with queries dax

i am trying to créate a report in power bi report builder,

with this sections:

* header

* body ( with 3 page columns )

* footer

the data is about students, and it must be displayed by year,

one year have at least 100 records

these records are

* header (the generic data student )

* body ( the body is the data subject, and it has to be displayed in 3 columns page)

* footer

Example

At this point, i am able to run one year that has only one student and get header and details

but when the year has more one record, i don know how to run massive

I want to make a dynamic header for each studentId page, and details

Can any one please help me on this?

Thanks in advance

Re: Power Bi Report Builder(Paginated Report) Dynamic

jaineshp — Fri, 08 Aug 2025 11:34:53 GMT

Hey SaulGarcia,

Based on your requirements for handling multiple students with paginated reports, here are the recommended steps:

1. Dataset Structure

Ensure your DAX query returns all required fields: StudentID, StudentName, Year, Subject details
Order the dataset by StudentID first, then by any subject sequence you need
Include all header information (student details) in each row to avoid lookup issues

2. Report Layout Configuration

Create a List control as your main container
Set the List to group by StudentID - this is crucial for the dynamic behavior
Inside this List, place your header, body table, and footer elements

3. Header Implementation

Place header elements in the List header section
Use expressions like =First(Fields!StudentName.Value, "YourDatasetName") for student info
This ensures each student page shows their specific details

4. Body Section (3 Columns)

Add a Table/Matrix inside the List for subject details
In Table properties, set Columns = 3 and configure column spacing
Alternatively, use 3 separate Table controls side by side with filtering expressions

5. Page Break Configuration

Go to List Group Properties → Page Breaks tab
Enable "Between each instance of a group"
This creates separate pages per student automatically

6. Footer Setup

Place footer content in the page footer section of the report
It will render consistently across all student pages

Testing Recommendation: Start with 2-3 students first to verify the grouping logic works correctly before running the full 100+ records.

This approach should handle your massive data scenario while maintaining the dynamic header requirement.

Fixed? ✓ Mark it • Share it • Help others!

Best Regards,
Jainesh Poojara | Power BI Developer

Re: Power Bi Report Builder(Paginated Report) Dynamic

v-tejrama — Sat, 09 Aug 2025 08:27:47 GMT

Hi SaulGarcia ,

Thank you jaineshp for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!

Re: Power Bi Report Builder(Paginated Report) Dynamic

jaineshp — Mon, 11 Aug 2025 04:17:56 GMT

Hey v-tejrama,

Thank you for the kind recognition - always happy to contribute to our community's success!

Best Regards,
Jainesh Poojara | Power BI Developer

Re: Power Bi Report Builder(Paginated Report) Dynamic

SaulGarcia — Tue, 12 Aug 2025 22:04:03 GMT

hi , jaineshp good day, please excuse me for not writing sooner, but now , i am able to tell you.

I have followed the step you indicated me, it seem confused.
and could not continus.

at step 2, in the list place header, body and foot, Who can i do it. when drag and drop the list control, just put a list alone.

at step 4 body section , add a table , inside the list control
i do not see the properties columns and column spacing

Could you attach a example file, please?

remember that i am using Windows Application Power BI Report Builder v15.7.1806.11

Best Regards

Re: Power Bi Report Builder(Paginated Report) Dynamic

v-tejrama — Wed, 13 Aug 2025 07:06:48 GMT

Hi SaulGarcia ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you,

Tejaswi.

Re: Power Bi Report Builder(Paginated Report) Dynamic

v-tejrama — Mon, 18 Aug 2025 05:35:58 GMT

Hi SaulGarcia ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.

Re: Power Bi Report Builder(Paginated Report) Dynamic

v-tejrama — Tue, 02 Sep 2025 10:37:39 GMT

Hi SaulGarcia

Thanks for getting back with more details. Let me try to clear the confusion step by step. In Report Builder, when you insert a List control, it will look empty at first that is normal. Think of the List as a container, inside which you can place your header (rectangle with student details), a table for the body, and another rectangle for the footer. The grouping is done on StudentID so that each student gets their own section.

For the 3-column layout, you won’t find that setting inside the table properties. Instead, go to Report → Report Properties → Layout, and there you can set the number of columns (for example, 3) and adjust the spacing. Once this is done, the rows from your table will automatically flow across the page in three columns. For page breaks, just enable “between each instance of a group” on the StudentID group. The footer can either go inside the list (if it’s student-specific) or in the report’s Page Footer section (if it’s the same across pages).

I’d suggest first trying with 2–3 students to check the behaviour before running it on the full dataset. This way, you’ll clearly see how the header, body in three columns, and footer repeat per student.

Thank you,

Tejaswi.