Append Table Not Appearing

[Anonymous]

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

 

[AllisonKennedy]

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.

[Anonymous]

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

[AllisonKennedy]

@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.

[Anonymous]

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

[AllisonKennedy]

@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.

[Anonymous]

Hi Alison

Thank you very much for all your help on this, your advisory solved my issue!

Best

Mick

[AllisonKennedy · Accepted solution]

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.