Power Query
Top 5 Reusable M Code Functions for Power BI/Excel (Power Query)
Power BI’s Power Query (M language) allows creating custom functions and reusable query steps to simplify common tasks. Below are five versatile M-…
Read articlePOWER QUERY INSIGHTS
Practical Power Query explanations.
Focused guides and examples designed to make your next reporting or analytics task clearer.
Topic
Language
Power Query
Power Query Performance Playbook (Power BI & Excel)
Want faster refreshes and snappier previews? Here’s a practical, no-nonsense guide to making Power Query load much quicker using only generic patte…
Read articlePower Query
Automatically Import Data from Email Links Using Power Query in Excel or Power BI
Have you ever received an email with a link to download a CSV or Excel file, and wished it could just go straight into your Excel sheet or Power BI…
Read articlePower Query
Power Query: Custom Function for Error Detection in Tables
When you're transforming data in Power BI or Excel using Power Query, you're bound to run into errors —mismatched data types, division by text, nul…
Read articlePower Query
Power Query in Excel & Power BI: The Ultimate Data Transformer
Power Query is Microsoft’s powerhouse tool for data transformation and automation, built into Excel and Power BI. If you’ve ever spent hours copy-p…
Read articlePower Query
Power Query: Clean All Text Columns in the Same Query
Function: Would you like to clean multiple columns in a single operation? This custom step allows you to clean as many columns as...
Read articlePower Query
Power Query: Rename Columns from a Mapping Table (Inline step)
Check out some of our FREE templates and materials. PRACTICE MATERIAL BELOW!👇 Function: Would you like to rename multiple columns in a single oper…
Read articlePower Query
Power Query: How to Filter Out Empty Rows and Columns with Custom M Functions
Remove Empty Rows and Columns from tables by using Power Query custom functions. No need to load empty columns anymore.
Read articlePower Query
Power Query: Convert Date Format (Universal Format)
Check out some of our FREE templates and materials. PRACTICE MATERIAL BELOW!👇 Function: Converts different date formats into YYYY-MM-DD or any oth…
Read articlePower Query
Power Query: Extract Numbers from a Text String
Check out some of our FREE templates and materials. PRACTICE MATERIAL BELOW!👇 Function: Extracts only the numeric values from a given text. Simply…
Read articlePower Query
Power Query: Remove Special Characters from Text
Check out some of our FREE templates and materials. PRACTICE MATERIAL BELOW!👇 Function: This function, RemoveSpecialChars, cleans a text string by…
Read articlePower Query · Power BI
Power Query: Reusable Calendar function
This Power Query function dynamically generates a calendar table based on a given start date, end date, and fiscal year start month . It is designe…
Read article