Combine multiple Excel files

[Anonymous]

I want to combine multiple Excel files from one folder with below header.

What is the best way to combine in Power BI

Thanks,

Store #

Address

City

St

Service Date

Billing

Service Date

Billing

Service Date

Billing

Service Date

Billing

Service Date

Billing

19

ABC

AAA

MI

5/4/2021

$18.50

5/11/2021

$18.50

5/18/2021

$18.50

5/25/2021

$18.50

6/1/2021

$18.50

[Anonymous]

Thank You.

[Vijay_A_Verma · Accepted solution]

This video will help you explaining the same

Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)

[WilliamAzevedo]

Thank you for this link, I've spent two days searching for that instruction!