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


Direct Lake vs. Import vs. Direct Lake + Import: Learn Building Three Storage Patterns That Scale
Introduction In this writing, I like to share how I learned to create three distinct storage patterns for Power BI semantic models—...
Jihwan Kim
May 253 min read
Â
Â
Â


From Zero → Lakehouse: Loading AdventureWorks Sample into Microsoft Fabric (Notebook-Only)
In this writing, I like to share how I learn to populate a clean Fabric Lakehouse —AdventureWorks— using nothing but Spark notebooks. 1...
Jihwan Kim
May 171 min read
Â
Â
Â


The Power of VAR in DAX: Enhancing Performance and Readability
In this writing, I like to share how I learned to leverage the VAR in DAX to improve both the performance and readability of my Power BI...
Jihwan Kim
May 103 min read
Â
Â
Â


The Hidden Cost of Auto Date/Time in Large Power BI Models
Why performance and data model bloat may be silently hurting Power BI developments. In this writing, I like to share how I learn to...
Jihwan Kim
May 54 min read
Â
Â
Â


Power BI Style Presets: Visual Consistency and Efficiency
In this writing, I'd like to share how I started learning to configure stylePresets  in Power BI and why it’s an exciting breakthrough...
Jihwan Kim
Apr 275 min read
Â
Â
Â


Understanding the EARLIER and EARLIEST DAX Functions in Power BI – Beyond Their English Meaning
In this writing, I like to share how I started to learn about the EARLIER and EARLIEST DAX functions, which I felt quite confusing at...
Jihwan Kim
Mar 313 min read
Â
Â
Â


Finding Table.RemoveColumns function in M Code in Power Query Editor Using TMDL View
In this blog post, I’d like to share how I learned to find where Table.RemoveColumns function in M code is used in Power Query Editor and...
Jihwan Kim
Mar 94 min read
Â
Â
Â


Leveraging the TMDL View Feature in VSCode with GitHub Copilot: my experience
In this writing, I want to share how I start to use TMDL View feature with GitHub Copilot in VSCode. As a Power BI developer, staying...
Jihwan Kim
Feb 94 min read
Â
Â
Â


Getting Started with TMDL View in Power BI: My Experience
In this writing, I want to share how I start to use the TMDL (Tabular Model Definition Language) view in Power BI. This isn’t a deep dive...
Jihwan Kim
Feb 23 min read
Â
Â
Â


How I learn WINDOW DAX function in Power BI
In this writing I like to share how I learned WINDOW DAX function in Power BI. Over the past few months, I’ve had the opportunity to work...
Jihwan Kim
Jan 114 min read
Â
Â
Â


Unlocking Insights of users activity: Using "sempy_labs.admin.list_activity_events( )" in Fabric Notebooks
In this writing, I like to share how I start to learn, write, and use the "sempy_labs.admin.list_activity_events"Â function in Fabric...
Jihwan Kim
Dec 26, 20243 min read
Â
Â
Â


Tracking a Power BI Project (Improve Semantic Model Size) Using Semantic Link in Fabric
Recently, I started exploring the basics of Semantic Link, and it opened up new possibilities for me to track the progress of one of my...
Jihwan Kim
Dec 16, 20243 min read
Â
Â
Â


Making Dynamic Format String More Dynamic for End Users, in Power BI
In this writing, I want to share how I learned to make dynamic format strings more dynamic and flexible for Power BI end users. This...
Jihwan Kim
Dec 1, 20243 min read
Â
Â
Â


DAX Queries in Fabric Notebook - A Journey of Efficiency and Insight
In this writing, I like to share how I learn and try using Fabric Notebooks to write DAX queries, enabling me to extract the most...
Jihwan Kim
Nov 17, 20244 min read
Â
Â
Â


How I learned to use the DETAILROWS DAX Function in Power BI
In this writing, I like to share my journey of learning and adopting the DETAILROWS DAX function in Power BI. What started as a curiosity...
Jihwan Kim
Oct 13, 20243 min read
Â
Â
Â


Standardizing Number Formats in Power BI Reports by Implementing a Dynamic Format String Table
In this writing, I like to share how I learned to use dynamic format string by implementing format_string table to Power BI semantic...
Jihwan Kim
Sep 30, 20244 min read
Â
Â
Â


How I start using DAX Query View in Power BI.
In this writing, I’ll share how I began using the DAX Query View  feature in Power BI Desktop, with the hope that by the end, readers...
Jihwan Kim
Sep 19, 20243 min read
Â
Â
Â


Fundamental skills for transforming data in Fabric.
In this writing, I’d like to share my journey of learning how to transform data into the desired structure in Fabric, using tools like...
Jihwan Kim
Aug 17, 20246 min read
Â
Â
Â


Developing a Direct Lake Mode Semantic Model & Power BI Report with GitHub Integration
In this writing, I aim to share my journey and experiences in learning and experimenting with the development of a Direct Lake Mode...
Jihwan Kim
Aug 6, 20244 min read
Â
Â
Â


Enhancing Power BI Custom Themes with New Icons
In this blog post, I'd like to share how I learned to add new icons to Power BI Custom Themes. Previously, I often used DAX measures with...
Jihwan Kim
Jul 28, 20243 min read
Â
Â
Â
bottom of page