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

[Anonymous]

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?

[v-jingzhang]

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.

[ppm1]

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