Listing all Functions in the Power Query Editor

Video by: Reid Havens

One of the hurdles with writing M code in Power Query is knowing which functions to use, or which are available. Learn about an easy way to access the entire current list of available functions in the query editor with this simple technique. Plus have access to a Power BI file I created which contains all functions and their related metadata, organized into a report.

Related Article: The Great Function Project: Part 3 - by Mat Herring

Extracting Multiple Tables From A Power Query Combine Folder Source

Video by: Reid Havens

One of the amazing data connectors in Power Query is the ability to combine files from a folder. However, what happens when those files each contain multiple tables you'd want to combine? This video covers a simple technique to extract multiple tables from each file, using the folder combine data connector.

Using the Power Query Reference Feature to Reduce Query Dependencies

Video by: Reid Havens

Learn about an important feature in the Power BI query editor, referencing other queries. Using this feature will help reduce query dependencies and allow for easier updates if the data source changes for the report.

P3: Power Query (M)agic Part 3: Divide & Conquer

Article by: Reid Havens

Welcome back P3 Nation! By now we’re in full swing with this Power Query (M)agic series, three posts and counting! You’re now knowledgeable enough about Power Query (if you read Part One and Part Two, anyway) that I want to throw some cool techniques at you involving M code. The time has come to take off the metaphorical training wheels, dive into the deep end, leave the nest, take a leap of faith (boy does this guy love idioms…), because frankly you are READY FOR IT. “I know it, you know it, everyone knows it.”