Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Hello,
I have ghost columns that are created when I export to Excel in Power BI Report Builder, how can I avoid this?
Best regards
Solved! Go to Solution.
Yes, when I remove the text box, I haven't ghost columns but I have all align between the board and the text box, I don't understand this run always not.
Hi @ccbpce69 ,
Thank you for reaching out to the Microsoft Community Forum.
In Report Builder, even when everything looks aligned in the designer, the Excel renderer works off exact coordinates. If any object differs even slightly in Left position or Width, Excel will introduce an extra ghost column.
In your case, the issue is likely coming from a small mismatch between the tablix and other elements, commonly a standalone textbox like the execution date or from the overall body width exceeding the page width when margins are included. Hidden or overlapping items can also cause this.
Make sure all report items line up exactly at the property level (same Left and Width values, not just visually), ensure the tablix columns sum precisely to the tablix width and verify that Body Width + Left/Right Margins ≤ Page Width. Also, align any standalone textboxes perfectly with the tablix or place them inside it.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support Team
Hi @ccbpce69 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .
Best Regards,
Community Support Team
Hi @ccbpce69 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .
Best Regards,
Community Support Team
Hi @ccbpce69 ,
Please adjust the width of the Body, Header, Tablix so it all align.
Before Adjusting
Excel OP :
After Adjusting :
Excel op :
Sample File: ghost_columns_ISSUE_visible.rdl
Thanks
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster
Actually, I have all align but when I do export, I see always this ghost column. Best regards
Yes, when I remove the text box, I haven't ghost columns but I have all align between the board and the text box, I don't understand this run always not.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 48 | |
| 43 | |
| 39 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 67 | |
| 63 | |
| 30 | |
| 30 | |
| 23 |