Forum Discussion
Append Table Not Appearing
Dear Community
Could you please help me with the following. I have appended 6 tables that have the same underlying excel format but the new appended table is not appearing. I am not getting an error, I do not know why this would not work. Please help!
See attached screenshot of how I completed the Append.
Kind Regards
Mick
- Aha, ok. I get your problem now.
You have done 'Append Queries' this time, so all the data should be loaded into the Alpine - Progress table.
If you want a new table of all Appended, you need to select 'Append Queries As New' from the drop down arrow on the Append Queries button.
7 Replies
- How many rows do you have? Have you loaded this to the data model and checked using a table or in the data view (NOT Power Query) that it truly has not appended?
Power Query only loads a preview of the data (first 1000 rows) so it can sometimes look as though it hasn't worked even when it has.
Otherwise we will need more information to help you troubleshoot if you're not getting an error.Hi Alison
In total there is 621 rows across all 6 files. I loaded each excel file in as individual tables. The steps I took was to "Transform Data" and then clicked Append Queries - choose 3 of more tables option - and selected the tables as per the screenshot on my post above. I hope this is what you were asking me for?
Thanks for your support.
Mick
- Anonymous
Thanks for the added info - which table is not appearing? Is there ANYTHING about it that may be different from the others?
One thing you can try that may make life easier is to use Get Data > From Folder instead of Excel.
Using the Folder option, Power Query will automatically append the files for you, and gives you the ability to transform each sample file first. It also lets you change the Sample file so you can see what's happening in each source file.