Power Query - Avoid "Helper Queries" (+10 Cool Tricks)

Video Description

Learn how to avoid creating "Helper Queries" when extracting data from binary files. Plus, see 10 incredibly useful Power Query & "M" code tricks to save valuable time and perform unthinkable data transformation acts. "M" code examples (File download link:) https://www.bcti.com//wp-content/YT_Downloads/BCTI_PQ_M_Code.zip 00:27 When & why Helper Queries are created 01:29 Video Objectives 02:11 Avoiding Helper Queries when Working with CSV files 04:18 Filtering by File Extension (i.e., file type) 05:03 Filtering by Path (i.e., file location) 05:44 Removing unnecessary Meta Data 05:54 Utilizing "Helper Queries" 07:03 Removing unwanted rows using "good" errors 07:36 Avoiding "Helper Queries" when working with text files 07:50 Extract Binary content using a function 09:06 Filling in the missing steps 10:26 Avoiding "Helper Queries" when working with Binary files 12:57 Filtering nested tables before data extraction 15:07 Sorting columns during column extraction 15:54 Renaming columns during column extraction 16:37 Removing total rows using "good" errors 17:33 Find / Replace values