Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching The best way to connect to a SharePoint Folder to speed up your Excel and Power BI data refresh. and this video is uploaded by Access Analytic at 2022-03-26T22:46:19-07:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [-XE7HEZbQiY]
| Name | The best way to connect to a SharePoint Folder to speed up your Excel and Power BI data refresh |
| Video Uploader | Video From Access Analytic |
| Upload Date | This Video Uploaded At 27-03-2022 05:46:19 |
| Video Discription | 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/ [-XE7HEZbQiY] |
| Category | Howto & Style |
| Tags | Howto & Style Download MP4 | Howto & Style Download MP3 | Howto & Style Download MP4 360p | Howto & Style Download MP4 480p | Howto & Style Download MP4 720p | Howto & Style Download MP4 1080p |
