⚠ 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 ⚠
   • The best way to connect to a SharePoi...  
*******************************************************************************

How to connect to a file on SharePoint and OneDrive
   • How to use Power Query to connect to ...  

My Articles on LinkedIn
  / wynhopkins  

Our Website and Training Services
https://accessanalytic.com.au/