by Wyn Hopkins

Combining Multiple Files from a Folder

How to use Power Query for Excel and Power BI to consolidate multiple files into a single table of data, whether you’re using OneDrive , SharePoint or a traditional network folder.

As well as showing the basic steps, this video explains the inner workings of the Power Query helper functions so you fully understand how it works

 

And here’s how you connect to a file on Sharepoint and OneDrive