Explicit Measures Podcast

515: DAX Complexity & Power Query ETL Tips

Mike & Tommy dive into DAX complexity and Power Query ETL tips, tackling how to structure complex measures that balance readability and performance across nested time intelligence, dynamic filters, and multi-grain data. They explore advanced Power Query techniques for reducing refresh times in Fabric Dataflows Gen2 and SharePoint integrations, with practical advice on optimizing step folding and reusing logic across queries.Get in touch:Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.tips Podcast Page.Visit PowerBI.tips: https://powerbi.tips/Watch the episodes live every Tuesday and Thursday morning at 730am CST on YouTube: https://www.youtube.com/powerbitipsSubscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVvSubscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎Check Out Community Jam: https://jam.powerbi.tipsFollow Mike: https://www.linkedin.com/in/michaelcarlo/Follow Tommy: https://www.linkedin.com/in/tommypuglia/

514: Help! How Do We CI/CD with TMDL + PBIR in Azure DevOps

Mike & Tommy tackle the messy reality of CI/CD for Power BI in the age of TMDL and PBIR, weighing whether Fabric Deployment Pipelines or Azure DevOps—or both—offer the right path forward. They explore why selective file commits feel impossible despite text-based artifacts, when each approach makes sense, and whether mixing deployment methods creates more problems than it solves. The conversation cuts through DevOps hype to reveal what actually works for BI teams navigating source control, pull requests, and environment promotion.Get in touch:Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.tips Podcast Page.Visit PowerBI.tips: https://powerbi.tips/Watch the episodes live every Tuesday and Thursday morning at 730am CST on YouTube: https://www.youtube.com/powerbitipsSubscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVvSubscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎Check Out Community Jam: https://jam.powerbi.tipsFollow Mike: https://www.linkedin.com/in/michaelcarlo/Follow Tommy: https://www.linkedin.com/in/tommypuglia/

513: Git Best Practices: Diff Noise & Naming

Mike & Tommy tackle Git best practices for Power BI teams, exploring how to reduce diff noise from slicer selections and matrix expansions, whether renaming visual folders is brilliant or risky, and how small teams can maintain clean, readable source control without losing their minds. They weigh practical tactics like commit checklists, folder naming conventions, and the trade-offs between tracking every click versus only intentional changes.Get in touch:Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.tips Podcast Page.Visit PowerBI.tips: https://powerbi.tips/Watch the episodes live every Tuesday and Thursday morning at 730am CST on YouTube: https://www.youtube.com/powerbitipsSubscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVvSubscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎Check Out Community Jam: https://jam.powerbi.tipsFollow Mike: https://www.linkedin.com/in/michaelcarlo/Follow Tommy: https://www.linkedin.com/in/tommypuglia/

512: Publish to Web vs. Embedded – Security & Public-Facing Reports

Mike & Tommy tackle the critical security distinctions between Publish to Web and Power BI Embedded when exposing reports publicly, questioning whether Embedded actually provides meaningful protection over Publish to Web when authentication isn't required. They explore how Row-Level Security behaves differently in each approach, whether URL filters can be locked down, and what organizations should actually do when building public-facing dashboards—including when to aggregate data upstream, disable granular access entirely, or reconsider whether the data should be public at all.Get in touch:Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.tips Podcast Page.Visit PowerBI.tips: https://powerbi.tips/Watch the episodes live every Tuesday and Thursday morning at 730am CST on YouTube: https://www.youtube.com/powerbitipsSubscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVvSubscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎Check Out Community Jam: https://jam.powerbi.tipsFollow Mike: https://www.linkedin.com/in/michaelcarlo/Follow Tommy: https://www.linkedin.com/in/tommypuglia/

511: Mailbag! Scaling a Power BI Side Hustle – Marketing & Growth as a Family Man

Description:In this mailbag episode, we tackle a question from Jacob, a BI Manager and father of three who's been building his Power BI consulting side hustle since late 2023. With a full-time role, a stay-at-home spouse, and limited time to market his services, Jacob asks: How do you scale a consulting business while balancing family responsibilities? We discuss marketing strategies for time-strapped consultants, targeting small to mid-sized businesses, pricing and positioning, and the tension between growth and sustainability. Whether you're considering a side hustle or already running one, this episode offers practical advice on building a consulting practice that fits your life.Get in touch:Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.tips Podcast Page.Visit PowerBI.tips: https://powerbi.tips/Watch the episodes live every Tuesday and Thursday morning at 730am CST on YouTube: https://www.youtube.com/powerbitipsSubscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVvSubscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎Check Out Community Jam: https://jam.powerbi.tipsFollow Mike: https://www.linkedin.com/in/michaelcarlo/Follow Tommy: https://www.linkedin.com/in/tommypuglia/