Report Builder Column Headers are Not Repeating on Additional Pages

[EH_MW]

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

[jostnachs]

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 · Accepted solution]

This video solved my issue:

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

[Anonymous]

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.