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 "powerbi works" page & "blog" pages for inspiration and generate your own unique insights. Let's embark on this data-driven journey together!
Search

Commit three times, and revert the second commit. Power BI Version Control in Azure DevOps.
In this writing, I like to share what I have tested when version controlling in Power BI with Azure DevOps. Recently, I could experience...
Jihwan Kim
Jul 23, 20233 min read
433 views
0 comments

PBI Version Control with Git Integration + PBIP + Deployment Pipeline | What setup is good to go?
In this writing, I want to share how I like to set up the Power BI Version Control process with Git Integration configured in workspaces...
Jihwan Kim
Jul 15, 20234 min read
2,487 views
0 comments

Power BI version control and main branch vs. sub branch in Azure DevOps.
In this writing, I like to share how I create a simple "Pipeline" and create a "Release" in Azure DevOps to publish Power BI Dataset and...
Jihwan Kim
Jul 13, 20234 min read
966 views
0 comments

Power BI Development Version Control with Azure DevOps - Start to practice using pbip file.
In this writing, I like to share how I learn to create a project in Azure DevOps in order to version control Power BI files, and in order...
Jihwan Kim
Jul 8, 20233 min read
2,258 views
0 comments

Performance comparison between Import vs. Direct Query vs. Direct Lake, in Fabric and Power BI
In this writing, I like to share how I compare the performance between Import, Direct Query, and Direct Lake modes, in Fabric (and in...
Jihwan Kim
Jun 24, 20232 min read
948 views
0 comments

Creating a Direct Lake connection in Power BI Desktop, and how to verify it?
In this writing, I want to share how I create Direct Lake Dataset in Fabric to connect to Power BI Desktop, and how to check and verify...
Jihwan Kim
Jun 18, 20232 min read
347 views
0 comments

When do I use the MATCHBY DAX function in Power BI
In this writing, I want to share how I started to learn and practice the MATCHBY DAX function that came out in May 2023. Link to...
Jihwan Kim
May 28, 20231 min read
355 views
0 comments

Restore a connection in Deployment Pipeline, in Power BI
In this writing, I like to share what I struggled with when working with datasets and reports in the Deployment Pipeline in Power BI, and...
Jihwan Kim
May 13, 20233 min read
241 views
0 comments

Dynamic format string in Power BI - How I start to use it in my report.
In this writing, I like to share how I started using the Dynamic Format String feature in Power BI, which was recently added as a preview...
Jihwan Kim
Apr 30, 20233 min read
284 views
0 comments

The Surprising Benefits of Choosing RANK DAX Over RANKX for Power BI: My Personal Experience
In this writing, I like to share my recent discoveries regarding one of the two new DAX functions. Recently, I saw two new DAX functions...
Jihwan Kim
Apr 15, 20234 min read
3,420 views
0 comments

My Top 3 Right-Clicks in Power BI Desktop
In this writing, I'll be sharing my top three favorite right clicks in Power BI Desktop, as well as a bonus suggestion for additional...
Jihwan Kim
Apr 2, 20233 min read
341 views
0 comments

Analyzing 50,000 customers in Power BI: Performance problem
In this writing, I want to present how to create DAX measures for producing an insight when a list of 50,000 customers is given and asked...
Jihwan Kim
Mar 19, 20233 min read
504 views
0 comments
![파워비아이 period분석: [Start_Date] column & [End_Date] column in the Project table, in Power BI](https://static.wixstatic.com/media/64d1a1_16713b1f59644b3e8eeecea504b77ca4~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/64d1a1_16713b1f59644b3e8eeecea504b77ca4~mv2.webp)
파워비아이 period분석: [Start_Date] column & [End_Date] column in the Project table, in Power BI
이 블로그에서는, [Start_Date] column 과 [End_Date] column 이 존재하는 table을 분석할 때, 나는 어떤 생각을 가지고 Power BI analysis를 시작하는지에 대해서 공유하고자 한다. DAX...
Jihwan Kim
Mar 12, 20233 min read
32 views
0 comments

Utilizing the LINESTX DAX function with a virtual table in Power BI
After I posted the short blog post, LINESTX DAX in Power BI - How I start to play with it (jihwankimcscp.wixsite.com, Alexis Olson...
Jihwan Kim
Feb 26, 20233 min read
1,218 views
0 comments

LINESTX DAX in Power BI - How I start to play with it
In this writing, I want to share how I started playing with the new DAX function, released a few days ago, LINESTX in Power BI. The...
Jihwan Kim
Feb 19, 20233 min read
675 views
0 comments

Where can I check incremental refresh is correctly done? Power BI Premium
In my previous blog post, Incremental refresh configuration in Power BI (jihwankimcscp.wixsite.com), I shared what I usually check when...
Jihwan Kim
Feb 11, 20232 min read
196 views
0 comments

WINDOW DAX 함수 사용하여 10,000개 카테고리 분석 - performance issue?
일주일전에 "상위 몇개의 reseller가 전체매울 80%에 기여하는가?" 대한 분석을, 나는 WINDOW DAX 함수를 어떻게 사용하여 분석하는가에 대한 짧은 블로그를 작성했다. 블로그링크: WINDOW DAX Function in Pareto...
Jihwan Kim
Feb 4, 20233 min read
24 views
0 comments

WINDOW DAX Function in Pareto Analysis
In this writing, I want to share how I author a calculated measure using the WINDOW DAX function when describing "How much percentage of...
Jihwan Kim
Jan 29, 20233 min read
233 views
0 comments

나는 어떻게 POWER BI의 WINDOW DAX function을 이해하는가?
이번 블로그는 한글로 작성해볼까 한다. 내가 POWER BI를 한글버전으로 사용하지 않기 때문에 불필요한 영어단어가 한글문장에 많이 포함됨을 이해해 주시길... 이번 블로그에서는 나는 어떤 식으로 WINDOW DAX Function을 이해하고...
Jihwan Kim
Jan 22, 20233 min read
168 views
0 comments

What are your use cases of the SUMMARIZECOLUMNS DAX function in Power BI?
In this writing, I want to ask and learn from readers about your use cases of the SUMMARIZECOLUMNS DAX function in Power BI. But before I...
Jihwan Kim
Jan 15, 20233 min read
1,334 views
0 comments
bottom of page