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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
sudarshan15
Regular Visitor

Extra Header Row Appearing in Exported Power BI Report

Hi,
I’m facing an issue while exporting data from a Power BI report. After downloading the data as Excel, the exported file contains an additional header row (see attached screenshot). It appears as a data row in my report, which I don’t want.
How to hide ?

sudarshan15_0-1750849104131.png


sudarshan15_1-1750849399843.png

 

 

2 REPLIES 2
v-venuppu
Community Support
Community Support

Hi @sudarshan15 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @collinq for the prompt response.

In addition to collinq’s point,to avoid extra header row:

Use "Underlying data" export (if available).

Or reshape the visual (use a flat table instead of a matrix).

Or rename the measure to something clearer (or even blank using DAX: " ").

Limitations of each export method depending on model settings and visual type.

 

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

Thank you.

 

collinq
Super User
Super User

Hi @sudarshan15 ,

I am wondering if you chose the "Summarized data" and that is adding it?  Do you get the same if you select export "Underlying data"?  The summarized data option will put summary labels as another header row.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.