Fix your slow Power Query refresh from SharePoint (700% faster) скачать в хорошем качестве

Fix your slow Power Query refresh from SharePoint (700% faster)

★ JOIN THE FREE COURSE ★ Want to get the free Modern Excel Formulas course? Click here: https://exceloffthegrid.com/modern-ex... ★ Want to become an Excel ninja? Check out our training academy ★ https://exceloffthegrid.com/ ★ About this video ★ When you use the SharePoint.Files connector in Power Query, the refresh times can become painfully slow because it scans every file across the entire SharePoint site. In this video, you’ll see how switching to the SharePoint.Contents connector limits the query to the folder structure you actually need, which makes refreshes significantly faster. We will compare refresh times, so you can understand the impact and decide if it’s worth switching connector for your scenario. 00:00 Introduction 00:20 Scenario 01:21 Using SharePoint.Files 05:09 Average refresh times 06:16 Using SharePoint.Contents 08:42 Average refresh times 09:05 Why does this occur? 10:06 Converting from .Files to .Contents 13:15 Wrap-up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter:   / exceloffthegrid   #MsExcel