Power BI with Me

Power BI with Me Blog

  • The Power Query Edition

    Just Because Power Query Can Doesn’t Mean It Should Power Query is incredible. It’s one of the most powerful, flexible, and misunderstood tools in the Power BI ecosystem. It can join data, reshape it, cleanse it, deduplicate it, apply business logic, detect types, generate calendars, and perform transformations that rival full ETL pipelines. And yet… Read more

  • The ‘Why’ of It All Edition

    Why “Why?” is the most important question When people hear the word why, they often brace themselves. It can feel combative.Invasive.Judgmental. As if the person asking is about to clutch their pearls and say, “I’m sorry… you want to do what with the data?” But in data, analytics, and AI—especially when designing solutions in Microsoft… Read more

  • Do You Want to Build a Model? Sing Along Edition

    After a very long day yesterday I was thinking about thigs I wanted to do with my daughter over Thanksgiving break and it reminded me of the year that Frozen came out and I took her to the movies for the very first time the day before Thanksgiving. What does this have to do with… Read more

  • The Star Schema Re-Visited Edition

    By: Audrey Gerred Why I’m a Broken Record About Star Schema in Power BI The Repetition Is Intentional I talk about star schema again and again because it’s foundational. It’s not just a best practice — it’s the difference between scalable, performant, governable models and ones that become brittle, slow, and hard to trust. Power… Read more

  • The Medallion Architecture Edition

    By Audrey Gerred If you’ve ever tried to wrangle data from multiple sources into something clean, reliable, and ready for reporting, you know it can feel like herding cats. That’s where Medallion Architecture comes in—a layered approach to organizing data in a lakehouse that makes the whole process more manageable, scalable, and trustworthy. Let’s break it down.… Read more

  • The Can versus Should Edition

    By: Audrey Gerred After almost a decade of working with Power BI and now Microsoft Fabric —earning certifications, community recognition, and the “Super User” rank in the Fabric Community forums — I’ve seen a pattern emerge (#AuDHD #iykyk): the tools are powerful, flexible, and forgiving, but that flexibility often tempts users into practices that feel… Read more