Power Query M Primer (Part 22): Identifier Scope II – Controlling the Global Environment, Closures | Ben Gribaudo
Power Query
Power Query: Insert Sum Rows for Dynamic Periods - Microsoft Power BI Community
Chris Webb's BI Blog: Connecting To REST APIs With OAuth2 Authentication In Power Query/Power BI Chris Webb's BI Blog
Handling Excel Formula Errors in Power Query
Chris Webb's BI Blog: How Query Folding And The New Power BI Dataflows Connector Can Help Dataset Refresh Performance
Rename Many Columns at Once in Power BI
M Mysteries: The Mysterious Type Action—An M-Internal Means to Write Data Modifications to External Systems
Rename Many Columns at Once in Power BI - Excelerator BI
Magic tables in Power BI - Data Mozart
Consolidate Multiple Excel Sheets From Multiple Excel Files - Excel Unplugged
Power BI - Solution to 'This dataset includes a dynamic data source ... this dataset won't be refreshed.'
Dynamic, Lazy Records | Ben Gribaudo
Power Query forum now available in Power BI and Power Apps communities
Equals Is Not Always Equivalent: When Query Folding Does Not Produce Identical Results | Ben Gribaudo
Chris Webb's BI Blog: Query Pending Event In Power BI Performance Analyzer Chris Webb's BI Blog
Correcting Source Data in Power BI - Excelerator BI
Master Your Data is Now Available! - The Excelguru BlogThe Excelguru Blog
Label Duplicates with Power Query - The Excelguru BlogThe Excelguru Blog
Know Your Data Better by Column Profiling In Power BI using Power Query
Fuzzy Clustering in Power BI using Power Query: Finding similar values
Custom functions and complex return types in Power Query | Gerhard Brueckl on BI & Data
Excel Compare: Audit your workbooks
Convert “Column1” to “A”
Dynamic Rounding in Power Query: Easy Method
Fuzzy Grouping in Power BI using Power Query
Automatically remove empty columns and rows from a table in Power BI
Age Banding in Power BI using Power Query – Merge Queries Based on Between
Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code
Bitly API Reference
M Mysteries: SQL -> M (SqlExpression.ToExpression) | Ben Gribaudo