Forum Discussion
Solved
How to Load data to existing worksheet (=table) without headers using Power Query (updating table)??
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 imp...
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:- Load your existing table into Power Query.
- Append it with your new data that you previously wanted to append to the worksheet.
- Load this new appended table with all of the data to a new table.
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