⚠️ 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 ⚠️
[ Ссылка ]
*******************************************************************************

How to connect to a file on SharePoint and OneDrive
[ Ссылка ]

My Articles on LinkedIn
[ Ссылка ]

Our Website and Training Services
[ Ссылка ]

свернуть