Get data from multiple Excel Workbooks/Sheets in Power Query
In today’s video I will show you how to reuse Power Query steps to clean multiple workbooks. In a previous video, I showed you how to reuse power query steps to clean multiple workbooks and some of you asked me if it was possible to reuse the power query steps to clean multiple workbooks stored on a folder.
Watch the tutorial:
Links to the mentioned resources
Both videos are an extract from another video: Power BI for beginners and advance users, so if you want to see both videos at the same time, check this video out.