Power BI & Microsoft Fabric

Technical writing for people who build semantic models, not slides.

Deep dives on DAX, TMDL, Row-Level Security, and Direct Lake — written for analytics engineers who want the details, not the marketing.

measures.dax
YoY Sales Growth % =
VAR PriorYear =
    CALCULATE (
        [Total Sales],
        SAMEPERIODLASTYEAR ( 'Date'[Date] )
    )
VAR CurrentYear = [Total Sales]
RETURN
    DIVIDE ( CurrentYear - PriorYear, PriorYear )

Latest articles

View all →
PL-300PL-300 Session 3Data ModelDAXPower QueryPower BIData Days

PL-300 Episode 3: Design the Data Model

PL-300 Episode 3: star, snowflake and galaxy schemas, properties, relationships, role-playing dimensions, date tables, calculated columns and tables, with M and DAX.

potphodepraful ·

DP-700FabricData LoadingDimensional ModelingStreamingLakehouse

DP-700 Episode 5: Loading Patterns & Choosing Tools

DP-700 study guide to loading data in Fabric: full and incremental loads, dimensional models, streaming patterns, and how to choose a data store and transformation tool.

potphodepraful ·

DP-700FabricOrchestrationPipelinesNotebooksData Factory

DP-700 Episode 4: Orchestrate Processes

DP-700 study guide to orchestration in Fabric: Dataflow Gen2 vs pipeline vs notebook, schedules, event triggers, parameters, expressions and notebook patterns.

potphodepraful ·

Featured playlist

Microsoft Fabric User Group Pune

Community meetup recordings from the Microsoft Fabric User Group Pune — Power BI, Microsoft Fabric, and the broader Microsoft data platform, straight from the sessions.

Watch for free