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

4.5KLikes

278,895Views

2022Mar 26

🧑🏻‍🎓Learning Power BI? Check out my course https://accessanalytic.thinkific.com/ How to consolidate multiple files from a SharePoint folder using Power Query in Excel and Power BI. 🔽 More Info below PLUS warning 🔽 ➡️Updated video ULTIMATE Guide: Combine Files from OneDrive & SharePoint (2025 Update!) • ULTIMATE Guide: Combine Files from OneDriv... &list=PLlHDyf8d156W_I_ycA7kbfLKAej54p9Un&si=j-ub67bPecxrx9HD ⚠️Warning: to use SharePoint.Contents the user must have access to to all levels of the SharePoint site. 👀SharePoint and OneDrive Playlist: • Power Query and SharePoint / OneDrive 🕙Additional technique to speed up refresh using incremental refresh • Faster SharePoint folder consolidation usi... 🤷🏻‍♂️365 BUSINESS Sadly the button is not included in 365 for Business . However you can still use the code in a blank query = SharePoint.Contents("YOURPATH/", [ApiVersion = 15]) 🙋🏻‍♂️Video I mention explaining the consolidation helper queries • Combining Multiple Files from a folder usi... 🧑🏻‍🎓Check out our Power BI Training Course https://accessanalytic.thinkific.com/ 📗And my Power BI Book https://pbi.guide/book/ 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/ Connect with me https://wyn.bio.link/