Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
Im trying to combine data from a folder with several files and several sheets. Can you help?
Each file has a different name
Each file has the same 10 different sheets (with different names)
Each sheet has same headers
Whats is the most efficient and clean way to get and sort the data? I want to be able to add files to the folder and automatically get an update when refreshing the report.
Thanks.
@Ritaf1983 @heaher_iTalent @ChrisMendoza @MFelix @RichFlorida @vdata @parry2k @amitchandak @Idrissshatila
let
Source=Folder.Files(YourFolderPath),
Custom1=Table.Combine(List.TransformMany(Source[Content],each Excel.Workbook(_)[Data],(x,y)=>Table.PromoteHeaders(y)))
in
Custom1