PQM.guide

Downloads content from a URL as binary.

2026-04-07

Pass API keys, Bearer tokens, and query parameters to authenticated REST APIs using the Web.Contents options record — including how to handle token refresh and avoid hardcoding secrets.

2026-04-07

A complete map of every environment where Power Query M can be executed — from desktop tools to cloud dataflows to the new Fabric programmatic API.

2026-04-03

Why M is a functional language, what immutability means in practice, and how this shapes the way you write queries.

2026-03-11

Joins two tables on key columns, returning a flat combined table.

2026-03-08

Use if/then/else inside Table.AddColumn to classify, label, and derive values from row data — the most common M transformation pattern.

Understand how null propagates silently through M expressions and learn the standard patterns for defaulting, filtering, and intentionally preserving null values.

Build queries that accept parameters — from simple Power BI parameters to dynamic function-based filtering — without hardcoding values.

Look up values from one table in another — the M equivalent of VLOOKUP — using Table.NestedJoin or direct list lookup patterns.