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
   • Faster SharePoint folder consolidatio...  


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
   • Combining Multiple Files from a folde...  




The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/

Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
https://wyn.bio.link/