Learning resources

Collection of links that should help you learn and master the wonderful MS Power BI tools. There’s much more very useful information out there, but you should be able to find it through references from theses resources.

1) M as a language

Chris Webb’s M-Webinar This is the best intro to M as a language at the moment. Recommending it as the first hour to invest in your Power Query & M-skills.
Introduction to Power Query (informally known as “M”) Formula Language Quick intro, but watch out: Strangely hidden. You can reach the content via the left navigation pane only! Get your head around the syntax sugar of each. Read repeatedly.
Video about M language concept Lean back and enjoy the M(agic)
Formula Language Specification Techie-hardcore: Describes the structure of the language. Quickly flip through for the first time to get an orientation. Read again after you’ve practiced for some time, with any luck it will start to speak to you 🙂
Formula Reference Bookmark this: All functions with their specs.
And actively use this!: Read the specs, copy the example codes, paste it into the formula bar or advanced editor and study the results.
M-Code Editor How to create WordPad ++ editor for M, also includes a very useful function on how to extract additional metadata for #shared-function-list.

2) Books

Power Query, Get Data, Get and Transform & M: M is for Data Monkey, Power Query for Power BI and Excel

Power Pivot & DAX: Learn to write Dax, Power Pivot and Power BI, The Definite Guide to DAX

3) Online

From Microsoft: PowerBI, Power Query

Mark V SQL: Power Query Decathlon

Twitter: #PowerBI, #PowerQuery, #PowerPivot

4) Forums

 Power BI  Official Power BI Forum
 TechNet Power Query  Official Power Query Forum
 TechNet Power Pivot  Official Power Pivot Forum
 MrExcel PowerBI  Power Pivot and Power Query
 Stackoverflow  Not much traffic, but some very high quality M-code solutions
 XLGuru (Ken Puls)  New forum dedicated to Power Query

5) Blogs

M-Focus DAX-Focus
 Chris Webb Matt Allington
 Ken Puls Rob Collie
 Matt Mason Marco Russo & Alberto Ferrari
 Ivan Bond Scott Senkeresty
 Maxim Zelensky
 Ken Russell