Categories
Power BI Power Query References And Cheat Sheets

Resources to learn Power Query

High quality Tutorials, tools, and blog posts for Power Query

Tutorials

Contents hide
1 Tutorials
2 Documentation
3 Tools
3.1 VS Code extension: Power Query
3.2 Query Diagnostics
4 Tips
Power Query M Primer (part 1):Introduction, Simple Expressions & let
Ben Gribaudo dives into Power Query topic by topic

Part 1: Introduction to let expressions
Part 3: Using and writing Functions
Part 8: Time: date, time, datetime, datetimezone and duration
Part 11-13: Tables
Part 15: Error handling
Part 16: Power Query primative types
Part 17: Facets
Part 18: Custom types


Chris Webb’s blog: Crossjoin.co.uk
Another high quality resource.
Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code
How to use Web API’s through Web.Content‘s Query and RelativePath parameters
Web.Contents(), M Functions And Dataset Refresh Errors In Power BI
He knew how to fix Web.Contents() refresh errors all the way back in 2016!

Documentation

Tools

VS Code extension: Power Query

If you use the advanced editor check this out.
It supports autocomplete Tool tips display optional parameters.

VS Code extension: Power Query uses PowerQuery-Parser and PowerQuery-Formatter

Query Diagnostics

Query Diagnostics in Power BI

Tips

You can copy -> paste multiple queries into a new Power BI Report (notice it included a required referenced query ListAsText even though I didn’t select it.
You can copy -> paste multiple queries into at text editor

Leave a Reply