top of page
flow analysis
designed by Jihwan
Unlock the Power of Data with Dynamic Insights: Dive deep into comprehensive data flow analysis with Microsoft Power BI and Fabric. Experience the magic firsthand by requesting a personalized demonstration of my analysis reports, or explore the "blog" page for inspiration and generate your own unique insights. Let's embark on this data-driven journey together!
Search


How I Used Power BI Modeling MCP + PBIP to Build a Contoso Star Schema, Generate Measures, Clean Metadata, and Auto-Hide Visual Filters
In this writing, I want to share how I started to learn using the Power BI Modeling MCP server together with Power BI Projects (.pbip) and VSCode , and how that experiment turned into a full workflow: building a Contoso star schema with an AI agent, generating a measure table , cleaning up metadata (Sort by column), and automatically hiding visual-level filters in the filter pane by editing the report JSON. This is all from an actual hands-on session; the screenshots I’ll
Jihwan Kim
Nov 296 min read


Using Microsoft Fabric Notebooks to Render an SVG Measure From a Semantic Model
In this writing, I’d like to share the small experiment I did recently: querying an SVG measure from a semantic model using a Fabric Notebook , scaling it with Python, and displaying it directly in the notebook output. The idea started from a question from my manager: “If the semantic model produces SVG via DAX, can we render it outside Power BI and reuse it somewhere else?” Once I tried it, new use cases started to appear. The Data Model I Used Below is the sample semantic m
Jihwan Kim
Nov 166 min read


Power BI Semantic Models as Accelerators for AI-Driven Insights
In this writing, I’d like to share how I started learning and experimenting with Copilot and AI-driven features in Power BI and Fabric — and what I discovered about the role of semantic models in making them work effectively. Prerequisites Before jumping into it, here’s the setup I used for experimenting with Copilot and AI-driven insights in Power BI and Fabric. Power BI Service (Fabric workspace) — The experiments were all performed in a Fabric-enabled workspace, since C
Jihwan Kim
Nov 85 min read


Exploring DAX UDFs — Challenges, Learnings, and What Comes Next
In this writing, I’d like to share how I started to learn and create my own DAX UDF (User Defined Function) library , the pain points I’ve faced while trying to make the functions as general as possible, and how I plan to take the next steps forward. You can explore the project here: jihwankimdata/dax_udf_library How It Started Like many Power BI developers, I’ve written the same logic dozens of times — percentage growth, variance analysis, ranking, or window calculations — s
Jihwan Kim
Oct 254 min read


Reusable DAX logic with User Defined Functions (UDFs) – a new paradigm for semantic modeling
Introduction DAX User Defined Functions (UDFs) – introduced in the Power BI September 2025 release – let you encapsulate complex logic into named, parameterized functions that can be reused across measures and models. Power BI September 2025 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI Unlike calculation groups, UDFs accept parameters and nest other functions, paving the way for cleaner, more maintainable semantic models. Enterprise scenario: Let's assume,
Jihwan Kim
Oct 186 min read


What TMDL View Means for Model Versioning & Enterprise Workflows
In this writing, I’d like to share how I’ve been exploring TMDL (Tabular Model Definition Language) since it was in preview — and why...
Jihwan Kim
Oct 115 min read


Editing Semantic Models in the Service + TMDL View & Best Practices
In this writing, I’d like to share how I started learning to edit semantic models directly in the Power BI service and how TMDL (Tabular...
Jihwan Kim
Oct 44 min read


Using Semantic Model Refresh Templates & Fabric Data Pipelines for Scalable Model Maintenance
Why I Started Looking at Refresh Templates For years, I’ve learned and worked with refresh schedules in Power BI. At a small scale,...
Jihwan Kim
Sep 213 min read


DAX: Visual Calculations and Measures
In this writing, I’d like to share how I learn to navigate the evolving world of DAX. In an era dominated by AI and low-code solutions,...
Jihwan Kim
Jul 205 min read


Taming the Beast: From 4-Hour Refreshes to Fast Insights with Power BI and Microsoft Fabric
I. Introduction: The All-Too-Common Incremental Refresh Headache In this writing, I’d like to share how I approach a frustratingly common...
Jihwan Kim
Jul 1313 min read
bottom of page