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


Exploring the Power BI Modeling MCP Server: My Journey From Curiosity to a New Modeling Workflow
I didn’t expect the Power BI Modeling MCP Server to reshape my modeling habits. My plan was simple: read the November 2025 Feature Summary, test the feature for a few minutes, and move on. Instead, those “few minutes” turned into a fully immersive exploration where Copilot started behaving less like a text generator and more like a modeling agent. This post is a narrative of that journey — a story told through every screenshot I captured along the way — and how those moments
Jihwan Kim
Nov 224 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


Understanding Composite Semantic Models with Direct Lake and Import Tables
In this writing, I’d like to share how I started learning about Composite Semantic Models in Power BI and Fabric — especially now that Direct Lake mode can coexist with Import tables . When this feature first appeared in preview, I was curious how it could help simplify data architecture and improve performance for mixed workloads. After some testing, I’ve learned both the power and the limitations of this hybrid approach. Why This Feature Matters For years, I had to choose
Jihwan Kim
Nov 13 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


Stop Repeating DAX: Reusable Time Intelligence Calculation Group with TMDL
In this writing, I’d like to share how I've learned to dramatically accelerate one of the most common and repetitive tasks in Power BI...
Jihwan Kim
Aug 35 min read


Why Sunsetting Default Semantic Models is Fabric's Best Decision Yet
In this writing, I’d like to share what I have learned from a recent Microsoft Fabric announcement that, in my opinion, is one of the...
Jihwan Kim
Jul 263 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


.gitignore for Power BI Projects: A Simple Guide for the Modern BI Developer
In this writing, I’d like to share how I learned and understood one of the most important—and often overlooked—files I encountered as I...
Jihwan Kim
Jul 54 min read


Start Coding: A Modern Power BI Workflow with TMDL and VS Code
In this writing, I’d like to share how I am evolving my Power BI development process. For years, building semantic models has been a...
Jihwan Kim
Jun 295 min read


Leveraging OFFSET for Dynamic Ranking and Related Analytical Patterns Power BI: A Deep Dive Beyond Time Intelligence
In this writing, I like to share how I learned understanding and writing OFFSET DAX function in Power BI. OFFSET function (DAX) - DAX |...
Jihwan Kim
Jun 223 min read


Unlocking Next-Level Productivity with Power BI's TMDL View and AI
Introduction: A New Chapter in My Power BI Development Journey In this writing, I'd like to share my journey with a feature that has...
Jihwan Kim
Jun 148 min read


Cohort Analysis in Power BI: Mastering WINDOW and PARTITIONBY
By Jihwan Kim In this writing, I like to share how I learned to tackle one of the more insightful business analyses – cohort analysis,...
Jihwan Kim
Jun 56 min read


INFO.DAX + Fabric Notebooks Find Unused Columns
Measure Bloat You Can’t See—But Still Pay For Introduction In this writing, I like to share how I learned to uncover hidden VertiPaq...
Jihwan Kim
May 314 min read
bottom of page