The best way to connect to a SharePoint Folder to speed up your Excel and Power BI data refresh

How to consolidate multiple files from a SharePoint folder using Power Query in Excel and Power BI.
🔽 More Info below PLUS warning 🔽

Warning: to use SharePoint.Contents the user must hace access to to all levels of the SharePoint site.

Additional technique to speed up refresh using incremental refresh

Sadly the button is not included in 365 for Business . However you can still use the code

= SharePoint.Contents("YOURPATH/", [ApiVersion = 15])

Video I mention explaining the consolidation helper queries

Did you know I've written a book "Power BI for the Excel Analyst"?

Connect with me

[Fonzyrr]

This video is a genuine service to humanity

[jamieashton]

To be honest this video has just paid for my year's Youtube subscription. Can you imagine what the world would be like if every video was this informative. I had practically given up on trying to get files out of Shitepoint until now.

[juanramon]

Even in 2024 this Video still makes me say : you are the Master !!!

[marcoslopez]

How can I like this video many more times? Thank you for it!

[joaovaltergirardi]

You are the only person who came with a decent solution that really works. Thanks!

[KonstantinAushev]

Finally! It was so hard to find such elegant solution to the problem of slow working with SPO folders...

[bjrnkrogh]

Holy c... - the speed on this solution is Amazing !!!! Instead of 5 minutes - I'm getting data in 30 seconds - Thank you very much

[agnieszkabartoszewicz]

Thank you! That was exactly what I was looking for! Finally I managed to connect with my subfolder on the Sharepoint.

[markporiss]

Omg, finally found this! Agree, this is a genuine service to humanity

[Matheus-trjf]

Really, thanks for sharing your knowledge. You saved my day here. Was trying for 2 hours how to link it. The Power BI/EXCEL in app information is horrible for this. This video/tutorial deserves an OSCAR.

[gdbdgho]

Thank you for posting a better/quicker way to connect to sharepoint folder! It worked very well for me!

[chinedumjoseph]

You have saved my life! I wish I could give you a million likes. Thanks a lot for your clear and detailed explanation. Well done!

[neilthackeray]

MY GOD!!! Amazing! spent ages getting errors using other methods, love the simple exceptionally clear step by step presentation - Thank you!

[paser]

Absolutely brilliant! Thank you so much. Finding subfolders in SP has been a killer for me until now. Much appreciated.

[seanwood]

This is EXTREMELY helpful. Thanks very much for making this video.

[wayneedmondson]

Thanks Wyn! Always useful and interesting tips. Thumbs up!!

[nickvanmaele]

Great video, and nifty workarounds. Thanks for sharing!

[AmritaOSullivan]

This is brilliant. And explained so logically!!!

[jimbeverley]

What an awesome hack! I can't believe Microsoft hasn't already baked the SharePoint.Contents functionality into their PQ menus. Thank you!!!

[bradfry]

Excellent Wyn, I’ll be using this for sure 👍