Change Power Query Folder Connector when Moving to a SharePoint Folder

Описание

If you have been using "From Folder" in Power Query for Power BI or Excel to consolidate files from your network drive and you are now moving your folders to SharePoint this quick guide will show you how to make the change

Here's the link to my video discussing how to set up the consolidation process in the first place..
https://youtu.be/nPlrQUbEn4o

**Update Feb 2022***
I would recommend using the SharePoint.Contents approach I mention at 03:30 as the refresh WILL be quicker.
CHECK OUT THIS VIDEO https://youtu.be/-XE7HEZbQiY

****************

Follow me on LinkedIn
https://www.linkedin.com/in/wynhopkins/

Twitter
https://twitter.com/wynhopkins

Access Analytic Training
https://accessanalytic.com.au/training