Skip to content

Resources

Ready-to-use, downloadable versions of the templates from my posts. All free; adapt them to your own model.

CopilotPDF · 1 page

Before you open a model to Copilot

Ten items to tick before you open a semantic model to Copilot, data agents or Fabric IQ. Print it and use it with your team.

Authoring MCPPDF · 2 pages

A prompt library for semantic models

Six prompt patterns for the Power BI Authoring MCP Server, eight ready-to-use prompts and six rules to keep your model safe.

DAX UDFDAX · .zip

DAX UDF starter library

Functions for VAT, gross margin, margin bands, change vs last year, moving averages and competitor price gaps. With tests, ready to paste into DAX query view.

Power BIDAX · .zip

Date table template

A ready-made date table with year, quarter, month, week and sort columns, plus core time-intelligence measures like YTD, prior year and YoY change.

SQL ServerT-SQL · .zip

Index maintenance script

Lists fragmentation and builds REORGANIZE or REBUILD commands by threshold. It only prints by default, so you review before you run.

New templates arrive by email

When I add a new template or update an existing one, newsletter subscribers hear about it first.

STAY IN THE LOOP

New guides, sorted by topic in a single email.

Every Monday, the week's new posts arrive grouped by topic. No new posts, no email.

Nothing is sent until you click the link in the confirmation email. Unsubscribe anytime with one click.