PinnedKoleti Swathi·Jul 15, 2025How I Cut Power BI Refresh Time from 10 Minutes to 4 Using Temp Tables and IndexesThe Problem Started in Power BI — But It Wasn’t a DAX IssueA response icon3A response icon3
Koleti Swathi·Jul 1, 2025The Day Our Gateway Connection Broke — A Pitfall That Taught Us the Right Way to Connect On-Prem…It started like any other day on the project.A response icon1A response icon1
Koleti Swathi·Apr 18, 2025Power BI + MySQL Database: Connecting with Stored Procedures, Views, and Functions Made SimplePower BI is powerful for building dashboards and reports. But what if your data is in MySQL and you want to use Stored Procedures, Views…
Koleti Swathi·Apr 8, 2025Beware! The Hidden Trap of Using DATESINPERIOD with Historical vs. Present Data in Power BITime intelligence functions like DATESINPERIOD are useful for calculating moving averages, running totals, and comparing data across…
Koleti Swathi·Apr 5, 2025Understanding AVERAGE, AVERAGEX, and AVERAGEA in Power BI: Differences, Use Cases & Real-Time…In this article, I will discuss:A response icon2A response icon2
Koleti Swathi·Mar 5, 2025Everything You Need to Know About Year-over-Year (YoY) Growth Beyond 100%In this article, I will discuss YoY growth, where it applies, and how to analyze scenario when YoY growth exceeds the 100%, then we will…