Reply
EH_MW
Regular Visitor

Report Builder Column Headers are Not Repeating on Additional Pages

Hello,

 

I am creating a paginated report using Power BI Report Builder. My report spans numerous pages so I want to display the column headers (name of each column) on every page. When I run the report in Report Builder, it does this automatically, but it does not when I publish it to Power BI. I have gone into "Tablix Properties" and selected both the "Repeat header rows on each page" and "Repeat header columns on each page" (separately and together), but neither of these have any impact after publishing. Is this a bug or am I doing something wrong?

 

Thanks!

Matt

1 ACCEPTED SOLUTION
EH_MW
Regular Visitor

3 REPLIES 3
jostnachs
Helper III
Helper III

This works fine in my report builder. but when the report is exported as excel, the column headers are not frozen while scrolling

EH_MW
Regular Visitor

This video solved my issue:

https://www.youtube.com/watch?v=KTkKxpOu23Q

avatar user
Anonymous
Not applicable

Hi @EH_MW ,

Please refer to the document abhout more details.

Show row and column headers on multiple pages in a paginated report - Microsoft Report Builder & Pow...

  1. Right-click the row, column, or corner handle of a tablix data region, and then click Tablix Properties.

  2. In Column Headers, select Repeat header columns on each page.

  3. Select OK.

I have also found a similar post, please refer to it to see if it helps you.

  • The setting of KeepWithGroup = after and RepeatOnNewPage = true needs to be done on the static members in the ROW GROUPS pane.

Solved: Report Builder does not repeat column headers on s... - Microsoft Fabric Community

 

If it does not help, please provide more details.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)