Toptube Video Search Engine



Title:The best way to connect to a SharePoint Folder to speed up your Excel and Power BI data refresh
Duration:08:44
Viewed:190,236
Published:26-03-2022
Source:Youtube

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 https://youtu.be/6Uy59RsqgrM 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 https://youtu.be/nPlrQUbEn4o 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/



SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :