Explicit Measures Podcast

If you missed the December 2022 Power BI update, you missed a potentially altering way we think about DAX measures!  Three new functions were released that focus solely on the window, not the model (called Window functions), such as comparing the data next to the currently evaluated item in the visual, not from a evaluation context.  Regardless, should we start becoming experts in Window functions and update all our existing reports? How important are they, and how much should you focus on them now and in the future? https://pbidax.wordpress.com/2022/12/15/introducing-dax-window-functions-part-1/ https://powerbi.microsoft.com/en-us/blog/power-bi-december-2022-feature-summary/#post-21693-_Toc121395731 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/powerbitips Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ Check Out Community Jam: https://jam.powerbi.tips Follow Mike: https://www.linkedin.com/in/michaelcarlo/ Follow Seth: https://www.linkedin.com/in/seth-bauer/ Follow Tommy: https://www.linkedin.com/in/tommypuglia/

You have seen Microsoft update the subscription feature recently, and the guys review this potentially underutilized feature and how could it be brought to the forefront for solutions for users. Inspiration also comes from Dan English, who created a solution to use Power Automate to deliver subscriptions close to what Paginated Reports used to do.  https://denglishbi.wordpress.com/2022/08/22/power-bi-data-driven-subscriptions-with-power-automate-report-bursting/ https://denglishbi.wordpress.com/2022/08/30/power-bi-data-driven-subscriptions-with-power-automate-follow-up-using-dataset/ New Scanner API v2! https://github.com/pugliathomas/powerbiscannermetadata 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/powerbitips Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ Check Out Community Jam: https://jam.powerbi.tips Follow 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, Seth, & Tommy discuss a question asked on Twitter revolving on ensuring the highest quality of reports, content, and data from a team of developers. Outside of just Data Quality, what checks, processes, and reviews should be part of reports and features? 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/powerbitips Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ Check Out Community Jam: https://jam.powerbi.tips Follow 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 got a mailbag! Here is the question: How strict should one be to always push new data sources through our framework before we build tabular models. When and where to draw the line of when it's ok to connect Power BI directly to a source system (or a replica of the same), to speed up deliveries undermining the long term support by not using our BI framework (bronze, silver and gold layers in synapse) 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/powerbitips Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ Check Out Community Jam: https://jam.powerbi.tips Follow 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, Seth, & Tommy write letters to Satya Nadella, the CEO of Microsoft on their wishes for Power BI, and where the biggest needs are. 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/powerbitips Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ Check Out Community Jam: https://jam.powerbi.tips Follow 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, Seth, & Tommy dive into a common but hard-to-find feature in Power BI - Display Folders or Measure Tables for our DAX Measures? What is the cost and benefit for each, and should we adhere to one or the other? 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/powerbitips Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ Check Out Community Jam: https://jam.powerbi.tips Follow Mike: https://www.linkedin.com/in/michaelcarlo/ Follow Seth: https://www.linkedin.com/in/seth-bauer/ Follow Tommy: https://www.linkedin.com/in/tommypuglia/

The discussion pivots around whether Business Intelligence truly needs a Figma design system. Insights into Microsoft's confusing unified core model shed light on backend vs. frontend complexities. The speakers argue for better design practices in Power BI, emphasizing collaboration between designers and developers. They explore how tools like Figma can enhance report quality and user interface design, while also addressing the balance between aesthetics and functionality. Prototyping emerges as crucial for creating user-friendly BI experiences.

The guys go back to the Mythical Man Month and speaking on an important topic: Plan to Throw One Away.  The idea back in the day and still true now is why do not focus enough on a prototype, both in design and in modeling. https://course.ccs.neu.edu/cs5500f14/Notes/Prototyping1/planToThrowOneAway.html 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/powerbitips Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ Check Out Community Jam: https://jam.powerbi.tips Follow Mike: https://www.linkedin.com/in/michaelcarlo/ Follow Seth: https://www.linkedin.com/in/seth-bauer/ Follow Tommy: https://www.linkedin.com/in/tommypuglia/

The podcast explores the relationship between business intelligence and change management. They discuss the importance of change management skills in data-driven success. They also cover topics such as refreshing feeds, canceling Power BI data set refresh, simplifying data analysis with extended properties, and integrating change management with Power BI implementation.

Microsoft has fully become a player in the data industry. From Power BI (obviously) to Azure, Machine learning, Purview, Synapse, Power Apps.... Just in Power BI alone we have dataflows, datamarts, datasets! Sprinkle in your organizations own custom systems, how do we know what tools are the most appropriate for a given project? What makes a certain combination of tools better than others?  Inspiration for discussion here: https://azure.microsoft.com/en-us/blog/gain-deeper-insights-with-microsoft-intelligent-data-platform/ 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/powerbitips Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ Check Out Community Jam: https://jam.powerbi.tips Follow Mike: https://www.linkedin.com/in/michaelcarlo/ Follow Seth: https://www.linkedin.com/in/seth-bauer/ Follow Tommy: https://www.linkedin.com/in/tommypuglia/