Tag
5 posts
September 12, 2025
Mike and Tommy tackle one of the most common Fabric questions: how do you plan and size your capacity? They walk through Microsoft's capacity planning tools, estimator, and optimization strategies to help teams right-size their Fabric investment.
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.
August 18, 2023
In Ep. 242, Mike, Tommy, and Seth break down a sneaky performance lesson: you can cut render time dramatically without rewriting DAX by rethinking the visual and using constant lines from the Analytics pane.
July 26, 2023
Ep. 235 is a practical episode for anyone stuck in ‘fix the dashboard’ mode: it shows how to trace undesirable effects back to real root causes using a systems mindset. You’ll also learn what Chris Webb’s Fabric tests reveal about Direct Lake ‘data hotness’, capacity limits, and why some queries can quietly fall back to DirectQuery.
July 19, 2023
In Ep. 233, the crew answers a mailbag question on how much detail belongs in a Power BI report—covering model grain, drillthrough patterns, and ways to keep users in flow without turning VertiPaq into a row-level warehouse.