Power Query: merging 3 workbooks (get data from folder)

[lezawang]

Hi
I want to merge (append) 3 workbooks using Power Query. PowerQ would load only the first file a_2019.xlsx and give me error message. I shared the folder below which has 3 files. What could cause that. I tried manything but still giving me error message. I basically created the first file and then made a copy of it 2 times and changed the name and sheets names etc. Could that cause the issue? Thanks a lot.

a_2019.xlsx
	A	B	C	D	E
1	Year	Sales Rep	Item	Amount	File Name
2	2019	Sam	TV	100	a.xlsx
3	2019	Jim	TV	100	a.xlsx
4	2019	Adam	Cell Phone	100	a.xlsx
5	2019	Sue	Computer	100	a.xlsx
6	2019	Hellen	Washer	100	a.xlsx
7	2019	Sean	Dryer	100	a.xlsx
8	2019	Mike	Dryer	100	a.xlsx
9	2019	Liz	TV	100	a.xlsx
10	2019	Jack	Microwave	100	a.xlsx
A_2019

b_2020.xlsx
	A	B	C	D	E
1	Year	Sales Rep	Item	Amount	File Name
2	2020	Sam	TV	200	b.xlsx
3	2020	Jim	TV	200	b.xlsx
4	2020	Adam	Cell Phone	200	b.xlsx
5	2020	Sue	Computer	200	b.xlsx
6	2020	Hellen	Washer	200	b.xlsx
7	2020	Sean	Dryer	200	b.xlsx
8	2020	Mike	Dryer	200	b.xlsx
9	2020	Liz	TV	200	b.xlsx
10	2020	Jack	Microwave	200	b.xlsx
B_2020

c_2021.xlsx
	A	B	C	D	E
1	Year	Sales Rep	Item	Amount	File Name
2	2021	Sam	TV	300	c.xlsx
3	2021	Jim	TV	300	c.xlsx
4	2021	Adam	Cell Phone	300	c.xlsx
5	2021	Sue	Computer	300	c.xlsx
6	2021	Hellen	Washer	300	c.xlsx
7	2021	Sean	Dryer	300	c.xlsx
8	2021	Mike	Dryer	300	c.xlsx
9	2021	Liz	TV	300	c.xlsx
10	2021	Jack	Microwave	300	c.xlsx
C_2021

PQ - Google Drive

drive.google.com

 

[lezawang]

Found the answer. I just watched a video. I need to make them tables. Thank you.