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..

**Update Feb 2022***
I would recommend using the SharePoint.Contents approach I mention at 03:30 as the refresh WILL be quicker.

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

Follow me on LinkedIn

Twitter

Access Analytic Training

[Earth-]

Absolutely legend! Lot of top you tubers got wrong here. You saving us. Bless you my friend. 🙏

[april_bug]

Absolute legend! Worked perfectly!
Brilliant videos, very well spoken, easy and clear to follow and a good length! Not too long, really appreciate your videos. You're my go to for power query and power bi
Thank you very much for this!

[paladinhobbies]

Woohooo!!! It worked!!! Been stressing out how to make it work when I came upon this video. Thanks brother and God bless you! Liked and subscribed. :)

[AmanGupta-inzb]

Thanks Sir, It is really usefull and I was searching it for 5 days

[esetiawan]

This was very helpful thank you so much! Appreciate the time you take to explain this step by step!

[bjorns]

Awesome! How a 6 minute video can save hours! Thanks!!

[pgaeh]

Great job on this Wyn....Thanks for sharing.

[EdSongoku]

Thank you! Our network was moved to Sharepoint last week and I've been having nightmares about this, all my files of course stopped working and the thought of having to redo everything had me wanting to jump out the window. I'm giving this a go tomorrow, thank you!

[krislagocki]

Thank you so much. Saved me a lot of time!!

[wayneedmondson]

Hi Wyn. Interesting procedure. In my work, I don't have to use SharePoint, but nice to know the options, if the need arises. Thanks for sharing :)) Thumbs up!!

[sergejamie]

Great video, can i ask if this method clears the mapped folder connection from the data source options?

[davidfamilydoctor]

Unexpected solution. Felt like a plot twist.

[mowgli]

Hello - I actually need to do the exact opposite. Move a connection from SharePoint to a Network Folder. Can I assume I just follow and do the opposite?

[suheilsamara]

Indeed, very helpful tips from you Wyn as usual.
I have used your SharePoint.Contents method to change the consolidation from local drive to ShP for 15+ queries and they all work perfectly. Also, having the new file path in a separate referenced query is a great method since we are going to change the SharePoint site again in the near future.
One thing I am struggling with though, moving the consolidation of multiple excel files that are located in subfolder under a parent folder and how to refernce the Sample query (First file).
Any suggestions!
Appreciated.

[JacksonDad]

What if I am not consolidating multiple files and I want to point to just one file within a SharePoint folder? Is there a syntax in the Source location that references the new SharePoint query and the particular file I want? Thanks!

[mvlastean]

Hi! I really appreciate your tutorials and find them easy to follow and useful.
Do you have any advice about a workaround to use PowerQuery (Excel) to load files from Sharepoint Folder using Office 365 for Business where this connector is not available but strangely for Office 365 Enterprice or Office 2019 only?
If I use OneDrive for loading files from folder then this takes the path where OneDrive is sync on my computer and not working of course for someone else which try to refresh the query …

[MilhousekCZ]

Hi Wyn, thanks for sharing your knowledge, really helpful :) I have one challenge - have you ever tried to create SP folder path dynamically based on a file location? Imagine I have a controlling file, harvesting data from a SP subfolder.. so far so good.. But I have 45 folders/files like that and would like to create a SP path, so it automatically changes based on actual file location.. so when copied to next folder, automatically gets the current folder name+data ... any chance you've seen this somewhere? :D Thanks, man

[lesea]

Hi, I’m trying to follow this but struggling to compare what exactly to paste as you’ve got it blurred there. Are you pasting the I need other people to be able to access and edit this query not just me. What link to I change to please? To mention, we’re moving from local drive to OneDrive and now messing about with source changing to queries I previously created. Individual sheets work fine no issues but I’m struggling with source for combined query from folder with multiple sheets. Thanks