Скачать или смотреть List.Buffer: This One Power Query Function Can Speed Up Your Refresh

Sign up for our free Insiders program and get the example file:
Click here: https://exceloffthegrid.com/insiders/
File Reference for this video: 0275 List.Buffer

★ Want to become an Excel ninja? Check out our training academy ★
https://exceloffthegrid.com/

★ About this video ★
Have you ever had a very slow Power Query refresh time? This can happen if we reference the same list multiple times. Maybe adding a List.Buffer step is the answer you're looking for.

In this video, we demonstrate the impact of using the List.Buffer function on Power Query refresh times. Even in the simple demonstration, the refresh time goes from 20 seconds down to 0.8 seconds. That's a significant time saving!

00:00 Introduction
00:22 Scenario - 100 Rows
02:20 Scenario - 100,000 Rows
03:04 Adding List.Buffer
05:26 Speed test
06:17 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