Forum Discussion

ccbpce69's avatar
ccbpce69
Regular Visitor
7 months ago
Solved

POWER BI REPORT BUILDER GHOST COLUMN

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 

  • ccbpce69's avatar
    ccbpce69
    7 months ago

    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.

7 Replies

  • 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


     

    • ccbpce69's avatar
      ccbpce69
      Regular Visitor

      Actually, I have all align but when I do export, I see always this ghost column. Best regards

  • v-menakakota's avatar
    v-menakakota
    Icon for Community Support rankCommunity Support

    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

    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support

      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

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support

        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