BI Developer Toolkit

Reference

“How does this actually work?” DAX, Power Query and SQL field guides, Fabric architecture, an error decoder, trusted sources and a change radar.

Official documentation

Reference

Power BI and Fabric documentation map

Which official documentation answers which question, so you go straight to the authority instead of a five-year-old blog post.

Data Analyst · BI Developer · Senior BI Developer · BI Engineer · BI Architect / Lead

Languages

Reference

Power Query field guide

The M you actually write at work, organised by job: tables, lists, joins, errors, functions, dates, folders, APIs, folding and performance, plus a troubleshooting matrix.

Data Analyst · BI Developer · Senior BI Developer Reference

DAX field manual

DAX organised by the problem you are solving, not alphabetically: contexts, filters, relationships, time, business patterns and senior patterns, each with working code on the Northwind model.

Data Analyst · BI Developer · Senior BI Developer Reference

SQL you need to survive as a BI developer

Not SQL from scratch: the queries a BI developer reads and writes every week, why each matters for Power BI, and a decision guide for where each transformation should happen.

BI Developer · Senior BI Developer · BI Engineer

Platform

Decisions

Which Fabric architecture should I choose?

Where analytical data should live (Lakehouse, Warehouse, Eventhouse or existing SQL), how it gets there, how the semantic layer reads it, and five reference architectures from a small team to real-time.

Senior BI Developer · BI Engineer · BI Architect / Lead

Help

Error decoder

Power BI error decoder

Common Power BI, Power Query, DAX, gateway, refresh, deployment, Fabric, REST API and capacity errors: what each means, the usual causes, how to diagnose and how to fix.

Data Analyst · BI Developer · Senior BI Developer · BI Engineer

Where to learn more

Library

Trusted external learning

A short, deliberate list of places to learn from, in three tiers: authoritative, specialist and community. Quality over quantity.

Data Analyst · BI Developer · Senior BI Developer · BI Engineer · BI Architect / Lead

Updates

Change radar

Power BI and Fabric change radar

Only the product and certification changes that change what a learner should know, each with the date it was checked and the lesson it affects.

BI Developer · Senior BI Developer · BI Engineer · BI Architect / Lead

Elsewhere on the site

Glossary Cheat sheets

← All of the Toolkit