Power BI report builder report lost header and footer when export word

[mshao]

Hi Team,

I builder a report via Power BI report builder and find some issues about header and footer:

1、I don't want the footer and header show on first page which I can set the content not show but I can now remove the space it's occupied, Is there any suggestions since my cover is a whole page picture.

2、When I run or published the report, all headers and footer show well when export to PDF but all the content lost when export to Word. Since we need to export to word and it's so import for us, Is there any suggest how can we handle this problem?

Thanks so much for your kindly suggest in advance.

[Anonymous · Accepted solution]

Hi @mshao 

Thank you for reaching out to the Microsoft Fabric Community Forum.

1. In Power Bi report Builder go to view option.Click on properties pane .click on table which consists data .on right side of the screen scroll down to bottom to see visibility option.In visibility you can navigate hidden option.in that hidden option you can write expressions

2.To create rectangles or container to paginated report please refer below link
Add a rectangle or container to a paginated report - Microsoft Report Builder & Power BI Report Buil...

If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.

Thank you.

[Anonymous]

Hi @mshao 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[Anonymous]

Hi @mshao 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[Anonymous]

Hi @mshao 
We haven’t heard back since our last response and wanted to check if your query has been resolved. If not, please feel free to reach out for further assistance. If it has been resolved, kindly mark the helpful reply as the solution to make it easier for others to find. A kudos would also be greatly appreciated!
Thank you

[Anonymous · Accepted solution]

Hi @mshao 

In Power BI Report Builder, it's not possible to completely eliminate the space reserved for the header on the first page, because the header section is always set to take up a certain amount of space. However, you can minimize its impact by either hiding the content or adjusting the layout.

Like other reporting tools, Power BI Report Builder has a fixed structure for headers and footers. The Page Header section always takes up a bit of space at the top of each page, even if it's empty or hidden. This helps maintain a consistent layout and prevents content from shifting around unexpectedly across pages.

If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.

Thank you.

[Anonymous]

Hi @mshao 
Thank you for your patience.please let us know if anything was helpful to you, so that we can convert it into a formal answer. If so, we would appreciate it if you could Accept it as a solution and drop a 'Kudos' so other members can find it more easily.
Thank you.

[Anonymous · Accepted solution]

Hi @mshao 

Thank you for reaching out to the Microsoft Fabric Community Forum.

1. In Power Bi report Builder go to view option.Click on properties pane .click on table which consists data .on right side of the screen scroll down to bottom to see visibility option.In visibility you can navigate hidden option.in that hidden option you can write expressions

2.To create rectangles or container to paginated report please refer below link
Add a rectangle or container to a paginated report - Microsoft Report Builder & Power BI Report Buil...

If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.

Thank you.

[mshao]

Hi @Anonymous 

I would like to the all header for the first page. Now I can hide the content in the header but the header height still here and occipied my cover space. So I want the height to be zero for first page. Do you have any ideas?

[Anonymous]

Hi @mshao 

Thank you for reaching out to the Microsoft Fabric Community Forum.

1. Removing Header/Footer Space on the First Page:
To prevent the header/footer from displaying on the first page but retain the space they occupy, set the Visible property of the header and footer to False for the first page. Adjust their height to 0 for the first page using an expression like =IIf(Globals!PageNumber = 1, 0, 1).

2. Missing Header/Footer when Exporting to Word:
The issue of missing headers and footers when exporting to Word can often be resolved by using custom report items (e.g., text boxes or rectangles) for headers and footers rather than the built-in page header/footer. Ensure that headers/footers are placed in the report body or set the RepeatOnNewPage property for repeated headers. Additionally, check export settings and avoid complex formatting that may interfere with the Word export.

If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.

Thank you.

[mshao]

Hi Team,

Thanks for your reply.

About question 1：I have successfully prvent the footer and header display on the first page but I want to remove the space the occupy. About the height, I haven't find a way to set it via expression, could you please show me where I can set it?

About question 2：There are so many pages among my report, about there are some pages not very sure when will them be paginated. In this situation, Do you have any ideas how can i set the boxes or rectangles? Or do you have any examples for me to take as refrence?