Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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 ?
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.
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.
Proud to be a Datanaut!
Private message me for consulting or training needs.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
30 | |
26 | |
21 | |
20 |
User | Count |
---|---|
63 | |
49 | |
28 | |
24 | |
19 |