If you consider yourself a master of the Power BI arts, there is a good chance you have used and know about External Tools in Power BI. If you have not, then stop listening start learning! What is the role of External Tools, and should it be a requirement for a Pro to know and use them in Report Development? How essential are they? The guys cover this and some tools you may not know about.  Important Links from Today's Epsiode on External Tools: Business Ops by PowerBI.Tips - https://powerbi.tips/product/business-ops/ Follow James - https://www.linkedin.com/in/jamesdbartlett3/ Power BI Cleaner - https://www.thebiccountant.com/2021/06/27/power-bi-cleaner-gen2-is-here/ Tabular Editor 3 - https://tabulareditor.com/?aff=powerbitips Power BI Side Tools - https://thebipower.fr/index.php/power-bi-sidetools/ 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‎ 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 guys discuss a contested topic: What are the MOST IMPORTANT DAX functions in Power BI, and can they even rank them? What makes specific functions essential, important, or widely used? What should you know when you hit a wall, and do you have to know and master these important functions? 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/channel/UCPwPrIpZwlfIKcoUpRwl9OQ Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ 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 guys run through what Incremental Refresh is, why use it, and implications for how can impact your process. Mike gives a master class on advanced uses on utilizing XML endpoints for incremental refresh.  Also, Goals in Power BI is a Pro feature now! You do not need Premium! https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview 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/channel/UCPwPrIpZwlfIKcoUpRwl9OQ Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ 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 guys talk through why our reports get complicated, and if we add more elements and objects than needed. What causes this, and how much has to do with the design and the application itself? Or is it a problem of poorly managed objectives? 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/channel/UCPwPrIpZwlfIKcoUpRwl9OQ Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ 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/

No matter if you have never spoken before, presented once, or never have before, the guys share their own stories and tips on how they started speaking on Power BI at user groups and conferences.  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/channel/UCPwPrIpZwlfIKcoUpRwl9OQ Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ 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 guys are focusing on all the ways that we connect to Power BI - Basic (SQL), Advanced (API), Frustrating (Dynamics), and Future (Databricks).  What have they seen that works, what doesn't? What to look out for?  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/channel/UCPwPrIpZwlfIKcoUpRwl9OQ Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ 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/

 If you have not heard of Matthew Roche in the Power BI Space, it is time you get familiar with his blog and especially his series of articles on the Problem Domain & Solution Domain. Too many of us are delivering results but not true solutions for our clients, departments, and teams. But what should the Power BI Pro be? How do we change the culture, the delivery, and the overall product we provide to our stakeholders? Enter the Solution & Problem Domains. Read the articles here:  https://ssbipolar.com/2021/12/24/problem-domain-solution-domain/ https://ssbipolar.com/2021/12/31/between-the-problem-domain-and-the-solution/ 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/channel/UCPwPrIpZwlfIKcoUpRwl9OQ Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ 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/

This is one of our more interesting topics. Based on this article by Toward's Data Science, the current iteration of the Analyst (In our case, the Power BI Analyst) is becoming extinct. Enter the Power BI Analyst 2.0, which requires the ability to communicate, explain, and drive decisions.  The guys dive into their experience, how this article stacks up with the Power BI Pro, and what this means for the future.  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/channel/UCPwPrIpZwlfIKcoUpRwl9OQ Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ 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/

What are the different levels of users when building a report? What are they, and how do you approach each? What are the problems with audience types if you are not aware? The guys tackle this in today's episode.  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/channel/UCPwPrIpZwlfIKcoUpRwl9OQ Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ 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 guys are back focusing on Power BI Licenses - what is the scale, the differences, and what should you look for?  Think this could be a boring topic? Or never thought of it? You should now - The scale between Pro, PPU, and Gen 2 is huge.  Licensing Info: https://powerbi.microsoft.com/en-us/pricing/ 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/channel/UCPwPrIpZwlfIKcoUpRwl9OQ Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ 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/