Patterns & Playbooks
“What's the professional way to solve this?” Troubleshooting trees, the performance clinic, a production runbook, modeling patterns, decisions, security, governance and checklists.
Troubleshooting
What's broken?
Twelve decision trees for the problems BI developers search for most: wrong numbers and totals, failed refresh, slow reports, relationships, RLS, gateways, DirectQuery, deployments, Fabric connections, folding and memory.
Data Analyst · BI Developer · Senior BI Developer · BI EngineerTroubleshootingMy DAX is wrong. What do I do?
A decision tree for wrong numbers: wrong everywhere, wrong only at the total, wrong after a slicer, wrong last year, a relationship that doesn't filter, or right but slow.
Data Analyst · BI Developer · Senior BI DeveloperTroubleshootingPower BI Performance Clinic
Find what is slow first (rendering, DAX, model, Power Query, source SQL, gateway or capacity), then the fixes for each layer, with the tools that prove it.
BI Developer · Senior BI Developer · BI EngineerOperations
Design
Semantic modeling pattern library
Fact and dimension patterns with when to use each: transaction, snapshot, accumulating and factless facts, mixed grains, conformed, role-playing, SCD 1 and 2, junk, degenerate, parent-child and bridge dimensions, plus bad vs good model diagrams.
BI Developer · Senior BI Developer · BI Engineer · BI Architect / LeadDecisionsArchitecture decision library
Quick, honest comparisons for the questions developers keep searching: Import vs DirectQuery vs Direct Lake, measure vs column, Power Query vs SQL, Lakehouse vs Warehouse, one model vs many, RLS vs separate models, PBIX vs PBIP and more.
BI Developer · Senior BI Developer · BI Engineer · BI Architect / LeadPatternsReport design library
How to design executive, operational, analytical, detail, mobile, KPI scorecard, finance and sales reports, and the principles behind them: hierarchy, spacing, alignment, contrast, density, chart choice, accessibility, colour, titles, navigation and tooltips.
Data Analyst · BI Developer · Senior BI DeveloperStandards
Security and governance
BI security field guide
Workspace roles, Build and app permissions, sharing, static and dynamic RLS, OLS, sensitivity labels, tenant settings, export controls, service principals, guest users and least privilege, with an RLS testing checklist and a 'why can this user see this row?' guide.
BI Developer · Senior BI Developer · BI Engineer · BI Architect / LeadGuideGovernance and the BI lead
Workspace strategy, naming, ownership, certification, stewardship, content lifecycle, retirement, self-service vs managed vs enterprise BI, the Center of Excellence and governance maturity, built on Microsoft's Fabric adoption roadmap.
Senior BI Developer · BI Architect / Lead