{Awesome Works in Progress}
Microsoft’s Data Connectivity and Data Preparation technology that lets you seamlessly access data stored in hundreds of sources and reshape it to fit your needs—all with an easy to use, engaging, no-code experience. learn more
Where the 'M'agic happens!
- Curbal - Power Query
- Pragmatic Works
- Power Query Jumpstarter - Brian Grant
- Chris Webb's BI Blog - Chris Webb
- Power Query - powerquery.io
-
IF Statements - myonlinetraininghub.com
- Power Query Formatter - Beautify your Power Query (M-Language) Code with Power Query Formatter
- Power Query SDK - A Power Query language service for Visual Studio
- Power Query Source (SSIS)
- Value from previous row, using List.Range - exceltown.com
- Power Query Skills Apply to Excel, Power BI and SSAS Tabular
- Comparing ‘null’ values in Power Query
- Power Query tips for every Power BI Developer - Nikola Ilic
- Folders
- Comments
- Rename
- Append queries - The append operation creates a single table by adding the contents of one or more tables to another.
- Delimeters with more than one character e.g., ;;
- Grouping
- Aggregating
- Merging
- Extract data from file name
- Column from examples
- Using M to dynamically change column names in PowerQuery - Krešimir Ledinski (October 2020)
- Ghost columns e.g., Empty columns in excel
- 4 Ways to Fix Date Errors in Power Query + Locale & Regional Settings - Jon Acampora (April 2020)
- Awesome Way To Log in Power Query M Using Diagnostics.Trace - Dan Buskirk (June 2016)
- Viewing Error Messages For All Rows In Power Query - Chris Webb (December 2014)
- Deal with differnt date regions
- Keep The Most Recent Entry - Ken Puls (May 2016)
- Remove Duplicate Doesn’t Work in Power Query for Power BI
- Split by line breaks in Power Query
- Ref. Line feed: #(lf), Carriage return: #(cr), Tab: #(tab)
- When is a space not a space? When Power Query Clean Fails 📺; When Is a Space Not a Space?
- Embedding Images in Power BI using Base64 - sqljason.com
- Rename (F2)
- Add Description => // in the M Code
- Parametrization