Explicit Measures Podcast

Mike & Tommy go through a great mailbag question on composite models and reusable models, along with how this changes in Fabric.Whoa! I think I'm triggered after listening to both your composite model episode and your managing multiple dataset episode. Isn't a fair bit of the question similar however much of the discussion seems different between episodes... In one sense- the gold standard seems to be thorough with data modeling/dataset development to build a dataset that can be used in multiple thin reports as needed. But the use of composite models seems to be somewhat discouraged - even though this is another way to re-use key datasets to answer business questions without re-doing the exact same transforms. It was alluded to but not explored that Fabric has better ways of doing this.With the data warehouse or Lakehouse... can you expand on that?Thanks for the podcast. Even though I consider myself skilled at Power BI - I'm constantly learning from you guys! 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 Seth: https://www.linkedin.com/in/seth-bauer/Follow Tommy: https://www.linkedin.com/in/tommypuglia/

Stephanie joins Mike and Tommy to talk about those "magic wand" moments everyone experiences while working with Power BI. After polling social media, Stephanie shares the trends people seemed to wish for, sparking a lively discussion within the group.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 Seth: https://www.linkedin.com/in/seth-bauer/Follow Tommy: https://www.linkedin.com/in/tommypuglia/

Mike & Tommy are joined by Stephanie once again diving into the gotchas of the new Microsoft Fabric Capacity SKUs, how rolling it out differs than Power BI, and putting a gameplan together.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 Seth: https://www.linkedin.com/in/seth-bauer/Follow Tommy: https://www.linkedin.com/in/tommypuglia/

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 Seth: https://www.linkedin.com/in/seth-bauer/Follow Tommy: https://www.linkedin.com/in/tommypuglia/

We are covering ALL of Fabric Con 2026 and highlighting the updates.Context:FabCon and SQLCon 2026 AnnouncementMajor Fabric Updates - ALLOneLake UpdatesPower BI March 2026 Feature SummaryGet 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/

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/

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/

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/

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/

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/

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/

Mike & Tommy dive into what comes after a successful Power BI rollout, exploring whether the next phase is about building more reports or maturing the data platform beneath them. They question if 200 users and 300 KPIs signal maturity or hidden sprawl, discuss the shift from tool deployment to organizational capability, and outline a practical 3-year roadmap focused on governance, scalability, and turning BI into the company's decision engine.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/

Mike & Tommy tackle how to submit Fabric ideas that actually get noticed, exploring what separates impactful feedback from noise, why most suggestions get ignored, and how to read Microsoft's roadmap for emerging opportunities. They discuss new data types, future-proofing data engineering beyond AI hype, and practical strategies for becoming a better feedback citizen in the Fabric ecosystem.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/

Mike & Tommy tackle the challenge of kicking off Fabric with a clean slate, exploring how to prevent model fragmentation and build a culture of shared semantic models from day one. They discuss whether to rebuild from scratch or incrementally consolidate, why teams resist reusability, and how to establish governance that encourages collaboration without becoming a bottleneck. The episode delivers practical strategies for defining core business entities, creating a semantic model catalog, and building the organizational discipline needed to maintain a true single source of truth.Starting out with Power BI, our company's reporting team has been using import mode exclusively and we have not been reusing models very commonly. There is a lot of redundant data storage and I'm sure there are many conflicting DAX definitions and model relationships. I've started learning about Fabric and I'm realizing we will need to rebuild some semantic models from the ground up.Thing is, I'm not sure our team will have the patience to do things right. I suspect they will dive in and start creating more redundancies and our work will continue to be fragmented. How can I kick things off on the right foot and influence the team culture to work together with a single source of truth rather than individual sources?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/

Mike & Tommy tackle AI-assisted TMDL workflows and the hot reload problem, exploring whether direct file editing with AI tools like Copilot is the future of Power BI development or a recipe for broken models. They weigh the tension between "move logic upstream" best practices and the brutal close-reopen cycle when TMDL changes introduce errors, debating whether Tabular Editor 3, MCP servers, or a native Microsoft solution offers the best path forward for safe, validated bulk refactoring.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/

Are we only Direct Lake now? With Microsoft Fabric's ability to use Direct Lake with Semantic Models, where is the need for Import in Power BI, or rather where do we push people?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/

In this mailbag episode, we tackle a common challenge in Power BI report design: filter overload. When 15-20 slicers consume a third of your report page, are you empowering users or overwhelming them? We discuss practical guidelines for slicer design, the difference between "set once" and "frequently changed" filters, strategies for moving your team toward more mature reporting practices, and whether there's ever a justifiable reason to exceed 2-3 slicers per page.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/

In this episode, we tackle a critical gap between Power BI's Field Parameters and Excel's live connection capabilities. Inspired by a mailbag submission from Eivind Haugen, we explore the tension between building semantic models that look great in Power BI reports versus models that serve all consumers—including the often-overlooked Excel power users.We dig into why Field Parameters break the Excel experience, when Calculation Groups might be the better choice, and how to design semantic models that truly serve as a single source of truth across multiple consumption tools. If you're building models that connect to Excel, this conversation will change how you think about feature selection and governance.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/

In this episode, Mike and Tommy explore whether the traditional "Report Developer" role still exists in the age of AI and Microsoft Fabric. They discuss what skills organizations should actually be hiring for, how the role has evolved from pixel-perfect report building to semantic modeling and data architecture, and whether AI tools like Copilot are changing what we expect from BI professionals. The conversation challenges conventional hiring practices and offers practical guidance on future-proofing BI teams.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/

Mike & Tommy weigh in on whether Microsoft Fabric has earned the same trust as Power BI, exploring if it's truly dependable for small businesses and enterprises alike, and examining what trust even means for an all-in-one platform that's still rapidly evolving.https://x.com/gothburz/status/2019539563027247147?s=46&t=A8umCvjDNrtK_1gwT1T7qQhttps://hbr.org/2026/02/ai-doesnt-reduce-work-it-intensifies-ithttps://blog.fabric.microsoft.com/en-us/blog/supercharge-ai-bi-and-data-engineering-with-semantic-link-generally-available/https://powerbi.microsoft.com/en-us/blog/deprecation-of-old-excel-and-csv-import-experience-in-power-bi-service/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/