May 14, 2025
Mike and Tommy dive into the rich ecosystem of third-party and first-party tools that help Power BI developers build, test, deploy, and optimize their models and reports. From SQLBI's comprehensive overview to hands-on favorites, this episode is a toolbox tour for every Power BI practitioner.
May 9, 2025
Mike, Tommy, and special guest Alex Powers deep-dive into squeezing maximum performance out of Power Query—from Excel origins to Dataflows Gen 2 in Fabric. They cover staging defaults, V-Order optimization, query folding, the ELT mindset shift, and why copy-pasting Gen 1 code into Gen 2 will burn your CU budget.
May 7, 2025
Mike and Tommy dive into the Power Query skills every Power BI user should master. From essential daily transforms to advanced M language techniques, they break down what to learn first and what to tackle as you level up.
May 2, 2025
Mike and Tommy serve up their half baked ideas for the Power BI and Fabric ecosystem. From wish-list features to wild predictions, this episode is all about thinking out loud.
Apr 30, 2025
Mike and Tommy explore whether recent Fabric updates change how we should design a lakehouse architecture. With Direct Lake now available in Power BI Desktop and new workspace item limits, the design conversation is shifting fast.
Apr 25, 2025
Mike, Tommy, and guest Ginger Grant explore what education for a data scientist should look like in the age of Microsoft Fabric. They discuss whether traditional college degrees still hold up, the value of internships, and how the evolving data platform landscape is reshaping what skills matter most.
Apr 23, 2025
Mike, Tommy, and guest Ginger Grant explore whether now is the right time for data scientists to make the switch to Microsoft Fabric. They dive into the evolving data platform landscape and what a Director of Data should consider when adopting Fabric.
Apr 18, 2025
Mike and Tommy tackle whether data scientists should pay attention to Power BI, featuring a lively discussion on the intersection of data science and business intelligence. Plus, news on Fabric User Data Functions and VS Code custom instructions for Copilot.
Apr 16, 2025
Mike and Tommy tackle a community question about whether data science platforms are poised to replace traditional BI tools. They explore where analytics is heading and what it means for Power BI practitioners.
Apr 11, 2025
Mike and Tommy break down the biggest DAX and semantic model announcements from FabCon 2025. From Direct Lake improvements to DAX calendars and user-defined functions, this episode covers what matters most for Power BI practitioners.
Apr 9, 2025
Mike and Tommy break down the biggest announcements from FabCon 2025, covering agentic AI capabilities, new warehouse functions, and metadata-driven lakehouse patterns. They also spotlight the Power Designer Workload and Entelexos for Power BI Embedded.
Apr 4, 2025
Mike and Tommy tackle the common request of getting report data delivered straight to users' inboxes via subscriptions. They explore the options, limitations, and best practices for giving people their data in Power BI.
Apr 2, 2025
Mike and Tommy dive into data contracts and how they apply to Power BI and Microsoft Fabric environments. They explore why formalizing expectations between data producers and consumers is key to building trustworthy, scalable data platforms.
Mar 28, 2025
Mike and Tommy explore how Agile methodology applies to Power BI report development. They discuss iterative design, stakeholder feedback loops, and why treating reports like software projects leads to better outcomes.
Mar 26, 2025
Mike and Tommy tackle how to sell Power BI into an organization already invested in the Google data stack. They break down the practical challenges and strategies for fitting Power BI into a BigQuery-centric environment.
Mar 21, 2025
Mike and Tommy dive into the new DAX Performance Testing notebook from Microsoft's Fabric Toolbox, a powerful open-source tool for automating query benchmarks across cold, warm, and hot cache states. They also cover the latest Tabular Editor releases and code actions features.
Mar 19, 2025
Mike and Tommy dive into the controversial world of pie charts, inspired by a SQLBI article arguing they're not always bad. They also cover using OBSTORE to load arbitrary files into OneLake.
Mar 14, 2025
Mike and Tommy explore what you can accomplish with just $100 invested in Microsoft Fabric and Power BI. They also check out PowerTable's new private preview for building data apps on modern data platforms.
Mar 12, 2025
Mike and Tommy dive into naming conventions for Microsoft Fabric items and why a consistent structure matters as your workspace grows. Plus, news on AI functions in Fabric and the February 2025 feature summary.
Mar 7, 2025
Mike and Tommy tackle a mailbag question from Mehmet about best practices for managing multiple datasets in Power BI. They dive into whether composite models are the right approach for joining data across models.
Mar 5, 2025
Mike and Tommy dive deep into composite models in Power BI, reviewing how they work and when to use them. They also cover the new Spark connector for Fabric Data Warehouse now in public preview.
Feb 28, 2025
Mike and Tommy reflect on the journey of a citizen developer growing with Power BI. They share practical advice on leveling up from self-taught report builder to trusted data professional.
Feb 26, 2025
Mike and Tommy dive deep into SQL databases in Microsoft Fabric — what they are, why they matter, and how to get started. They also cover the new Fabric Quotas feature and debate which social media platform they'd keep if they could only have one.
Feb 21, 2025
Mike and Tommy celebrate episode 400 and dive into the Microsoft Fabric decision guide for choosing the right data store. They break down when to use a lakehouse, warehouse, eventhouse, SQL database, and more — helping you pick the right tool for the job.