⚠ 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/