Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

power query, load to Excel as table... without Column headers!! ??

im trying to automate a report, i made subtables in PQ but I do not want to load the headers, 

 

is there a way i can do a "load to" without bringing in column headers?

Need Help

2 Replies

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    Not sure what your data looks like but one way would be to not promote headers but just remove the first row of data.

     

    Pat

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi Anonymous 

     

    I don't think so. Based on my test, if demoting column headers to the first row and removing the first row in Power Query Editor, after loading to Excel, it still has a column header row having column names like "Column1", "Column2", "Column3"... The column headers cannot be excluded when loading. 

     

    In addition, based on my test, the column headers cannot be deleted or cleared the contents after loading to Excel. It only supports to hide the whole row. 

    Hope this helps. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.