Explicit Measures Podcast

516: Subscriptions as a Silent Hero

Mike & Tommy dive into Power BI subscriptions as proactive workflow tools, exploring whether automated data nudges can outperform interactive dashboards for busy professionals. Using a real-world data quality monitoring example, they question when the best BI solution is the one users never open, examining the balance between "push" alerts and "pull" exploration, and how subscription-driven reports can save hours while maintaining data hygiene.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/

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/