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 er...
- 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.
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.
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
- 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. - Anonymous
Also please see this article for what I was talking about with Get Data > From Folder.
https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder
The article focuses on Excel, but Power BI is mentioned and behaves the same. You will just need to select 'Transform' instead of 'Edit' in the Navigator screen.
This will mean you only have to set the data type once, rather than 6 times and Power BI will apply the changes automatically to each file in the folder.
You might not need it in this case if you're already done with the report, but a handy trick to keep up your sleeve.Hi Alison
Thank you very much for all your help on this, your advisory solved my issue!
Best
Mick