Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

2 REPLIES 2
EH_MW
Regular Visitor

This video solved my issue:

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

v-rongtiep-msft
Community Support
Community Support

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.

 

 

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.