Power Query
-
A Faster Way to Get Data from SharePoint Lists in Power Query
The default method Power Query uses to retrieve SharePoint Lists records is unbearably slow. Here’s a better way to retrieve many records from a SharePoint list in a flash for faster data loads.
-
Opening Multiple Instances of Excel, and Why (Power Query multitasking)
Although it seems like every Excel workbook that you open is a standalone instance, Excel is basically still the MDU application it’s always been. The Office team deploys some clever tricks to hide it, but in some situations it becomes apparent. Let’s explore.