Power Query: Appending Tables

Hi,

In the attached workbook I have created 6 sheets with sample data arranged as a named Excel Tables.

I have used Power Query to consolidate the 6 tables, using a query called AllData, into a sheet called "Report".

When I refresh the query, without adding new data to the source tables, the table in the "Report" sheet expands to contain more fields.

I thought that this might be because the AllData table has been included in the query when refreshed but that doesn't seem to be the case when I look at the "Source" line in the Applied Steps.

Can someone please suggest what I've done wrong?

Thanks!

At the Source step, deselect AllData in the table list.

Please Login or Register  to view this content.

AliGW on MS365 Insider (Windows) 32 bit

	A	B	C	D	E
1	PRODUCT	NAME.1	SALES	DATE	Name
2	AAA	Apples	100	31/01/2021	Data_Jan
3	BBB	Bananas	200	31/01/2021	Data_Jan
4	CCC	Carrots	300	31/01/2021	Data_Jan
5	AAA	Apples	105	28/02/2021	Data_Feb
6	BBB	Bananas	205	28/02/2021	Data_Feb
7	CCC	Carrots	305	28/02/2021	Data_Feb
8	DDD	Dates	100	28/02/2021	Data_Feb
9	AAA	Apples	110	31/03/2021	Data_Mar
10	BBB	Bananas	210	31/03/2021	Data_Mar
11	DDD	Dates	105	31/03/2021	Data_Mar
12	AAA	Apples	120	30/04/2021	Data_Apr
13	BBB	Bananas	220	30/04/2021	Data_Apr
14	CCC	Carrots	320	30/04/2021	Data_Apr
15	DDD	Dates	110	30/04/2021	Data_Apr
16	AAA	Apples	125	31/05/2021	Data_May
17	BBB	Bananas	225	31/05/2021	Data_May
18	CCC	Carrots	325	31/05/2021	Data_May
19	EEE	Eggs	100	31/05/2021	Data_May
20	AAA	Apples	130	30/06/2021	Data_Jun
21	CCC	Carrots	330	30/06/2021	Data_Jun
22	CCC	Carrots	300	30/06/2021	Data_Jun
23	EEE	Eggs	105	30/06/2021	Data_Jun
24	DDD	Dates	115	30/06/2021	Data_Jun

Sheet: Report

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

You can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.