Combining Multiple Files from a folder using Power Query in Excel or Power BI ( ⚠️see description )

Video Description

⚠️ see below for link to updated video on SharePoint connection ⚠️ 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 00:00 Intro 00:19 Connecting to a folder on your C :Drive / Network 02:39 Using the Transform Sample File to clean up your data 06:09 The Helper Queries explained 10:08 Connecting to a folder on SharePoint or OneDrive for Business ******************************************************************************* ⚠️Check out my updated video (March 2022) on using SharePoint.Contents ⚠️ https://youtu.be/-XE7HEZbQiY ******************************************************************************* How to connect to a file on SharePoint and OneDrive https://youtu.be/igcCbKqtwrk My Articles on LinkedIn https://www.linkedin.com/today/author/wynhopkins Our Website and Training Services https://accessanalytic.com.au/