Sam Fischer on LinkedIn: #PowerQuery #PowerBI | 19 comments

Power Query
Custom Navigation Property Name Generators | Ben Gribaudo
Add Leading Zeros to a Number in Power BI Using Power Query
Replace Values in Power Query - Ultimate Guide - BI Gorilla
Pivot Text Values in Power Query - Explained - BI Gorilla
Relationship Columns and Their Names | Ben Gribaudo
Chris Webb's BI Blog: Three New Power BI/Power Query Books Chris Webb's BI Blog
Batch conversion of headers and column values - Microsoft Power BI Community
Describing a Function’s Record Parameters | Ben Gribaudo
Power Query M Primer (Part 20): Metadata | Ben Gribaudo
How to create a Journal Entry with Power Query - BI Gorilla
Change the Data Source TYPE of the Power BI Dynamically using Power Query Parameters
Power Query Function: Column Value Distribution in Power BI
Chris Webb's BI Blog: Preserving Data Types With SQL Queries In Power Query And Power BI Chris Webb's BI Blog
Creating Column Values Distribution Report in Power BI Using Power Query
Some filter operations based on character function... - Microsoft Power BI Community
Always Identical Outputs? Switch Statement vs. Switch Expression | Ben Gribaudo
M Language Proposal: Cleaning Up Function Chains with the Pipeline Operator | Ben Gribaudo
Power Query M Primer (Part 22): Identifier Scope II – Controlling the Global Environment, Closures | Ben Gribaudo
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