Forum Discussion
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 ?
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.
5 Replies
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.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 wanted to check if you had the opportunity to review the information provided and resolve the issue..? If the response has addressed your query, please accept it as a solution, so other members can easily find it.
Thank you.
Hi sudarshan15 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi sudarshan15 ,
I hope this information is helpful.Were you able to resolve the issue with the help of solutions provided..?Let us know if you have any further issues, we are happy to help.
Thank you.
