Blog

Deep dives, not overviews

Articles on Power BI, DAX, TMDL, Row-Level Security, and Microsoft Fabric — written for people who already know what a semantic model is.

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 ·

Data DaysPower BIPL-300PL-300 Session 1DAXFabricDirect Lake

From Connection to Confidence: Getting, Connecting & Profiling Data in Power BI

Microsoft Data Days 2026 | PL-300 Certification Series — Part 01

Hardik Srivastav ·

DAXTMDLpower bi

Why Your Fabric Data Agent Gives Wrong Answers (And How Data Enrichment Fixes It)

A practical look at descriptions and synonyms in Power BI semantic models — and what's actually happening under the hood

potphodepraful ·

DAXFabricData AgentAILLm

Building a Better Microsoft Fabric Data Agent: Instructions, Visual Policy, and Cost-Aware Design

Connecting a semantic model to a Fabric Data Agent is the easy part. The real work starts when the agent needs to understand what your business actually means.

Hardik Srivastav ·

FabricFrameworkUDF FrameworkDAX

From Demo to Reusable Framework: Translytical Write-Back in Power BI

How I combined Power BI task flows, Fabric User Data Functions and versioned SQL storage to build commentary that works at any business grain.

Hardik Srivastav ·

DAXFabricSecurityData Agent

Microsoft Fabric Data Agent Security: What Actually Protects Your Data?

RLS, CLS, OLS, identity, permissions, and why prompt instructions should never become your security boundary.

Hardik Srivastav ·

DAXFabricSecurityGovernanceData Agent

Microsoft Fabric Data Agent Governance: From POC to Production

Securing the data is only the beginning. Production Data Agents also need controlled identities, lifecycle management, evaluation, privacy, networking, and change governance.

Hardik Srivastav ·

DAX

DAX Filter Modifier Functions

ALL, ALLEXCEPT, ALLSELECTED, KEEPFILTERS, and REMOVEFILTERS: what each one actually changes about the filter context, and the mistake that trips people up.

potphodepraful ·