Forum Discussion
Append Table Not Appearing
- 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.
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.The missing table is the newly created table, the output from the Append Queries. When I tested this Append Queries feature with 2 tables an additional table appeared called APPEND1 appeared in the left panel. Is this where I should be looking to find the newly created Append table?
I used the Get Data feature, but in PowerBI. I changed some columns data type to Text or in some cases Decimal Number (Percentage) where it was more suitable than the suggested data type. I did this on all the 6 tables, and then completed the Append Queries process.
Thanks Alison