Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to Solution.
This video will help you explaining the same
Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)
Thank You.
This video will help you explaining the same
Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)
Thank you for this link, I've spent two days searching for that instruction!