How to Load data to existing worksheet (=table) without headers using Power Query (updating table)??

[ooptennoort]

I so much would like to append refreshable data (Power Query) to an (existing) table. I can of course load to cell in existing worksheet, but how:

a) can I do this omitting the headers (from the import data) and,

b) with the table recognising the import data as an inserted data (resizing table accordingly+applying table formatting) and,

c) retaining the refresh capability in the appended section of the (resized) table?

[V-pazhen-msft]

@ooptennoort 
Your expected output is not supported in Power Bi. As @edhans said, you can load the new table then append it to your existing table, both table data is also refreshable. 

Paul Zheng _ Community Support Team

[edhans · Accepted solution]

You cannot do this @ooptennoort - any PQ query loaded to an Excel table is a full table on its own, with headers.

The way I would to it is:

1. Load your existing table into Power Query.
2. Append it with your new data that you previously wanted to append to the worksheet.
3. Load this new appended table with all of the data to a new table.