- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This video solved my issue:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This works fine in my report builder. but when the report is exported as excel, the column headers are not frozen while scrolling
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @EH_MW ,
Please refer to the document abhout more details.
-
Right-click the row, column, or corner handle of a tablix data region, and then click Tablix Properties.
-
In Column Headers, select Repeat header columns on each page.
-
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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
12-20-2022 04:28 AM | |||
05-04-2023 11:28 PM | |||
08-01-2024 12:49 AM | |||
02-01-2024 05:45 AM | |||
03-21-2024 12:51 AM |
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
6 | |
4 | |
2 | |
2 | |
2 |