PowerBI.tips

Thanks for the Mailbag – Ep. 270

Thanks for the Mailbag – Ep. 270

Ep. 270 is a Thanksgiving-week mailbag: quick questions from the community, fast answers, and a handful of opinions you can actually operationalize.

Before the Q&A kicks off, the team uses a Yankees/‘Moneyball’ story to make a bigger point: analytics only works when your organization can listen, challenge assumptions, and change course when the numbers (or the people closest to the work) tell you something’s off.

From there, the mailbag hits practical topics like distributing content with Power BI Apps, surfacing reports directly in Teams/SharePoint, building a real external reporting product with Embedded, and how to think about older building blocks like Data Marts, Charticulator, and Access as the stack moves toward Fabric.

News & Announcements

Main Discussion

Mailbag episodes are useful because they surface the messy edge-cases teams hit after the model is built—especially around distribution and adoption.

In Ep. 270, the questions cluster around four themes:

  1. Shipping reports like a product (and making internal consumption feel effortless)
  2. External sharing (and why the default ‘invite an external user’ workflow still creates friction)
  3. Tool transitions (Data Marts lingering in preview, and what Fabric implies for long-term direction)
  4. Differentiation (custom visuals after Charticulator, and where Deneb fits)

Key takeaways:

  • Apps are the default for internal distribution. They bundle content, control navigation, and give you a promote/publish workflow that ‘shared with me’ lists can’t match.
  • Meet users where they already work. Putting reports inside Teams or SharePoint reduces context switching and increases the odds the report actually gets used.
  • Adoption requires a support loop. A ‘seamless’ UI still fails if people don’t know it exists—or don’t know where to go when the next question shows up.
  • External consumption needs a product mindset. If client-facing reporting matters, plan on Power BI Embedded (or a purpose-built portal) so you can intentionally design auth, navigation, and permissions.
  • Long-preview features carry risk. Treat Data Marts as something you may need to migrate away from; Fabric’s lakehouse + SQL endpoint covers most of the same ground with a clearer strategic path.
  • Deneb is the modern replacement for ‘build-anything’ visuals. Vega/Vega-Lite lets you go well beyond the default visuals with a spec-driven workflow you can version and reuse.
  • Access is still around…but mostly as technical debt. If it’s acting like an ‘analytics database,’ semantic models (and Fabric for broader workloads) are usually a better destination.

Looking Forward

If you want your analytics to stick, optimize the consumption experience as much as the model—ship through Apps, surface reports where users already work, and treat legacy tools as migration plans instead of permanent foundations.

Episode Transcript

0:26 hello and good morning welcome back to the explicit measures podcast with Tommy Seth and Mike good morning everyone Happy Thanksgiving I believe yes it is a Happy Thanksgiving so thank you for those of us those of us those of you that are joining us live we are not live but that’s okay for all the other people on podcast and for those matter celebrating Thanksgiving this is I think this is just an American holiday yeah so oh yeah for other across people across the world Happy Thanksgiving go

0:56 across the world Happy Thanksgiving go Google it you’ll figure out what it means if you’re wondering what us Americans are doing right now as you listen to the podcast we’re probably having either pie turkey in the morning wouldn’t you love to have pie at in the morning we just have different names for it don’t we maybe maybe a pumpkin spice latte a flavored that’s everywhere they made that a global thing that could be that could be Global excellent so today’s episode we’re going to go through a bunch of mailbag items we have

1:27 through a bunch of mailbag items we have some more quick answers hot takes through these back items we wanted to get through some questions here so today’s episode will be centered around just asking questions from our community so that’ll be our main focus today but before we do that Tommy has an interesting story around analytics and challenging the analytics status quo I believe Tommy give us a little bit of background and we we can talk about it just briefly here from a news article standpoint and then we’ll jump into our main topic today so I’m thankful for you guys so I can vet vet about thisy

1:59 guys so I can vet vet about thisy session my therapy session so for those again you might not be in the us but you may have heard of the New York Yankees and you may have heard of the movie Moneyball which is all based on this analytically driven way of looking at sports the Yankees are in turmoil right now because they didn’t make the playoffs they’ve been doing progressively worse every year since we brought this manager in the idea is this manager only listens to analytics he listens to the analytics team and he just does anything that the analytics team says but unfortunately that’s not how Sports work and sometimes business

2:31 how Sports work and sometimes business too but we’re going to focus on Sports this year the general manager of the Yankees Brian Cashman came out in a very very defensive interview at the state of the Yankees after the team did not make the playoffs saying our team’s just fine we’re we have the smallest analytical team we’ve been using analytics the right way the captain of the Yankees the fifth Captain all time Aaron judge came out and said I think we’re looking at the wrong numbers the general manager says I had to have a conversation with him about this because we are looking at

3:01 him about this because we are looking at the right the right numbers this just goes to show just because you have analytics and you may be the Yankees with a lot of money the most money in the major leagues in the biggest city does not mean that you’re geared up for Success just because You’ have analytics you can be defensive and Petty if you have no power no culture or if you have the power and you have no culture and no checks you may have be in a vacuum of power where you don’t listen to anyone just because you have the numbers numbers this is the analytics gone wrong so

3:32 this is the analytics gone wrong so Tommy has sent us a couple articles here around the the accusations around the teens not using the analytics around them or they’re using overly complicated analytics yeah there’s some concept here around like shifting to like traditional metrics runs baded in things oh yeah that that was B let’s let’s break this down just just a little bit take a deep breath I can I can understand Tommy’s hyper he need a little paper bag your your frustration before we dive into the

4:03 frustration before we dive into the actual actual like analytics part of it and like what’s going on in the team like Tommy you you are you are a a DI hard fan of the New York Yankees what what are what are some are there some things that you think they’re doing wrong like if they didn’t make the playoffs this year what are what are some significant things that have been a deviation that like may be playing a part in some the decisions like give us some an idea of like some of the decisions that are being so that the

4:34 decisions that are being so that the number one correlation between a successful baseball team is the barrel off the bat speed so how fast the ball goes off the bat they basically this correlation they believe that if everyone hits the ball 95 miles plus off the bat you’re going to be successful yeah the assumption would be is higher speeds farther hits more likely Hood to hit home run hard cat the ball harder hits okay problem is you need to hit the ball first and we have a lot of players where if an if a good batting average is

5:04 where if an if a good batting average is 300 we’re hitting a 190 which usually meant the miners 20 years ago but they’re hitting that because they hit the ball really really hard and that’s one of the stats also this lack of like we need power we need players who can hit the ball hard is a big part we’re not going to focus on trying to move a player over another big idea is any out is a bad out so if I need to move a player over let’s say a man’s on First and I want to get him into scoring

5:34 and I want to get him into scoring position so then we get two chances three out well no no we don’t play that way we’re not gonna play that way we’re gonna try to hit the ball hard so we’re not gonna waste an out so you’re striking out people trying to smash the ball out of the park as opposed to actually trying to get people into scoring positions Pro the lower third worst hitting team in the majors and again every year since Aaron bu and I’ll say his name he’s not listening but since he took over the team has gotten progressively worse oh he’s wor he’s listening and what he’s doing right now

6:05 listening and what he’s doing right now good his his analytics team is is coming this podcast and he’s making sure he knows it’s you Tommy and he’s sending bad vibes towards Chicago so you’re going to be in trouble now you’re Chicago teams are much better so when when you show up at the New York Yankees Stadium and they they try to get sorry Tommy you’re not allowed in you you talked badly about us this is bad for a Yankee fan this is the this is Diet vers of most Yankee fans but no so those are some of the ideas and then the players you bring in so it’s not just

6:36 players you bring in so it’s not just and also this idea of the angle that you hit the ball so you don’t want to hit the ball on the ground you want to swing upwards you want this angle on the ball so these are the few ideas that they’re teaching in the minors so these are all the players coming up who unfortunately when you’re playing major league pitchers who are not going to just throw fast balls all the time and they’re also really good at what they do so they can get you in the top right corner of the the batting box which is really hard to swing at an angle all of a sudden it doesn’t equate to success so worst one

7:07 doesn’t equate to success so worst one of the worst hitting teams in the majors this year but these ideas with these big Power hitters who can’t hit the ball becomes a problem so you feel like they’ve literally purchased the wrong people because of the skills they brought onto the team purchasing theong using metrics that were not accurate for what they should be doing to win a game kind what you’re saying and and the minor league the far the the farm system of curating and growing these players is also trying to teach these things so now all these new guys are coming up from

7:37 all these new guys are coming up from the system well it’s not been equating to success so it’s both the mix of who we’re bringing in so it’s not equating to instant success it’s been getting worse the last six years since this has really took over so so it’s it’s t it this this was like instilled six years ago it’s been the last 20 years but this new man also there are a lot of things like no so and because baseball is all stat right so oh this guy is’s a 40% chance

8:07 right so oh this guy is’s a 40% chance to get on second if he does X Y and Z so they take that binder that’s the situ swiching gears on I’m getting like the the hitting thing the angle the power whatever that how long have they been like teaching and farming folks to oh yeah so the power has definitely been the last 10 years probably the system has been the last like 20 years of like basically how they’ve been curating players but that that ball speed or

8:40 players but that that ball speed or Barrel speed what they call it that’s probably been this big Focus the last six to seven years so so is this just now that players are getting introduced into the majors well like why all of the sudden this year are they not making it well F first off we’ve always had a terrible farm system so we brought in for new players the last two years from the farm system so hey we’ve drafted you we’re going to bring you up but we signed players three of them who were no longer on the team because they

9:10 longer on the team because they performed so poorly but because they we thought they got in base and they hit the ball hard but apparently not hitting the ball is not great for playing baseball so so the players that we brought in again based on this idog this ideology of what a perfect player looks like doesn’t equate if you can’t hit the ball ball wow so but this is analytics gone wrong to me because even though you have oh we’re doing more advanced stats and

9:40 we’re doing more advanced stats and we’re measuring all these new things in a very Innovative way doesn’t mean that that works for people in the trenches a far a minor league player came out and said we are doing it all wrong and he got blasted for but the players are coming out to defend him it’s one of those the people on the TR trenches the people are actually doing it just because we have all these numbers doesn’t mean that we should dictate the numbers or that we’re measuring the right things here here in lies the

10:10 right things here here in lies the conversation around this point so very interesting story Tommy and again I’m not a baseball fan as much as you are so I don’t know all these different metrics it’s very interesting hearing you speak about them because there is I about them because there is that’s why you started mean that’s why you started doing doing Atlantics analytics to begin with yeah is because it’s baseball you started fig not like oh a runs batted in this this is a number I can calculate this this is an RBI I know how to so you started

10:35 an RBI I know how to so you started collecting all the numbers and saying okay this is really interesting this tickles the right part of my brain therefore I’m that’s why I’m going to dive deep into baseball so% we’ve all had I think similar experiences with numbers like somewhere on the light the way like the analytics of things like oh this is this is right this is makes a lot of sense but I want to transition the conversation away from just sure the Yankees and focus on I think what you’re saying a little bit here or what you’re you’re observing is when a company makes the decisions around what metrics are

11:06 the decisions around what metrics are important at the leadership level potentially there’s a difference between what they’re saying is important versus what the boots on the ground are saying or the the people who are doing the work hey we want to increase sales what does that look like for us what should we be doing to increase sales and sometimes if you want to listen to people who are actually doing the work hey we’re losing a lot of bids because we’re too high in price or we’re adding people to projects that shouldn’t be there or

11:37 projects that shouldn’t be there or whatever it is we’re not competitive in this particular Market one thing that I think is and I’m going to draw a potentially another parallel here between this conversation and what I’ve heard said about satian Adela Microsoft he’s a really good listener at the leadership level and so we we we have heard that when when Saia hires new people and think I’ve read a couple articles online about this he asks a number of questions what do you think about this how is development need to be working what’s our what is our

12:08 to be working what’s our what is our main he does a lot of Investigation to figure out what is the heart of his customers what are his what is his team doing and then from there as he’s Gathering all the information he’s then able to make better more educated guesses around where they need to go directionally it sounds like this is part of the same challenge here someone needs to listen a bit more you’re on a SP on the big question or the big conversation is the Yankees are toned deaf but how many times in a business where to your exact point where like you’re in the trenches like oh no these

12:39 you’re in the trenches like oh no these are your metrics these are your kpis like well we need better resources is that really we know what we’re doing we’re the ones curating or creating the product or creating the campaign so allow us to like have that be in that dialogue when it comes from top down what you’re supposed to do or without any of the okay what are the things that make bring help you be successful what are the recipe for success that’s a terrible culture doesn’t matter how much power be analytics you have that’s part of data culture i you’re right is the

13:11 of data culture i you’re right is the listening I think I think there so there’s there’s a couple points I want to make here okay one is I I think yeah yeah 100% like you it could be it could be the wrong decision and it the Yankees are heading in wrong direction but I also think I also think you you have to recognize where you are which is it’s it’s dangerous to oversimplify from the outside right yes which is what we’re doing right we got it we nailed it the the flip side though

13:42 it we nailed it the the flip side though is the flip side though is on the on as a leader as a CEO as a manager as a person who has to make big things it it like he might be wrong or he like there’s a time limit on how how how much he needs to evolve to get this new thing running Andor a couple years from now could it be that you were all wrong and his vision was right you’re you’re out on a on a on your own when you’re in those decisions

14:14 your own when you’re in those decisions so I I don’t Harbor the guy any will also I’m not a Yankees fan so like whatever so take that as it will on the flip side of that to your point to to the discussion around SAA like I I I could almost argue being someone who’s played baseball or whatever that that isn’t the only strategy by which you could probably win the game right like what if what if you took all of the power out and you just did Place hitting right make contact with the ball just get it over the infielder’s head run run

14:44 get it over the infielder’s head run run people around the B bases right like it doesn’t have to be power hitting right there’s probably a million different ways you can look at the game and like try to get ahead I think what this does point out though is if many people are saying this is wrong like this is is not working we’ve had a lot of time to vet the idea and it’s it’s a noo then part of data and Analysis should be evaluating re-evaluating and proving out different outcomes right and if we keep coming back to the same spot then yeah

15:15 coming back to the same spot then yeah he’s got a hard place to stand on and everybody else is wrong and hopefully you see fruition in the light but at the at the same time I think part of what I like about data is one producing insights right but decisions are going to start being made based on those and at any point in time if you come up with a different scenario a different way to challenge the status quo that’s proven by the same data sets that’s what’s cool about data like listen it’s not a one one oneway

15:46 like listen it’s not a one one oneway ticket sometimes the answers are really easy but with a lot of data like baseball a lot of different varying factors like players like their style like the whatever like you’re trying to teach repetition of the same things but there’s a lot of value in analytics that have gone into sports like football how many more fourth Downs are being played as opposed to third right like there isn’t the the automatic like everybody’s punting the ball on the fourth down I’m switching Sports I realize that

16:16 down I’m switching Sports I realize that sportsball yay but at the same time with with baseball there’s tons of other caveats in there that hey what if you’re removing too much of a strategy in a game and you think that like one or two or three things are the the ways to to like succeed you you better have a lot of proof for that right and if it’s not starting to show itself then I it’d be interesting like at where’s where’s the breaking point right like if we are

16:48 the breaking point right like if we are in the right direction what are the kpis or the thresholds we should be meeting at this point because if this is how you win games and power is everything and shifting things and six years in you’re going this way is that expected and you’re you’re going to rebound or when does that rebound happen and there should absolutely be things along the way that indicate whether not you’re on the right track if you’re that far into having an analytics teams

17:21 into having an analytics teams there’s there’s tons of forecasting and things that you can do to understand like where where your current position is and maybe that’s what gives him well the last thing I’ll say is hopefully they bring Seth as in as as a analytics advisor because one of the things you’ve always talked about is changing them like Midstream like hey are we measuring the right things or is this a accurate forecast and do we need to Pivot the other part too is again I really do believe the listening to your people is so important again if you have

17:51 people is so important again if you have a captain and your other Captain was Derek Jeter which means and you appointed him captain for the next 12 years and he’s saying something something’s not right listen those are your Champions and yeah the last thing is the eye test knowing your people and your process are people happy or not just because your numbers are even doing well it’s G to stay that way I’ve watched way too many games this year I’m gonna end there at least on that so we can keep going well I think it really blows down to like their injuries across the teammates underperformance

18:23 the teammates underperformance in general you batting averages have been dropping across key players and then roll it up they just haven’t been consistent enough they got to be more consistent to win more I love love it I know you love it because I just chat gbt the whole thing so that’s that’s not Mike mik doesn’t know anything about baseball how’s he coming up with this I me it’s pretty accurate at the same time when I make a comment like hey you’re you’re you’re a leader and you’re going to make a big pivot and shift part of that is bringing everybody else along and making them believe in it

18:54 else along and making them believe in it and it certainly doesn’t sound like that’s happening which it both bod’s bod’s problematic I keep I go back to this conversation also sounds like it alludes a little bit to more of the and then again trying to L this back to business things that I know right it’s this concept of we’re we’re in a game yes baseball is a game with the defined rules and in things in the game there there is an infinite game that’s also being played here around who do you hire what people you bringing in what skills are you focusing on so there

19:24 skills are you focusing on so there there is that part of the game is infinite there is there is no one solution there is no winning that portion it’s you’re competing against other teams that are doing different strategies that are different than yours and they’re winning over your strategy so your strategies may not just be aligned this may be a great strategy this may be a good strategy for for the for the team however what I would want to understand or if I if I were in this position I’d want to be looking at what are other teams getting and how are

19:54 what are other teams getting and how are their basic metrics lining up to what my team is doing and where do we have a huge gap in metrics that can we fix those gaps is that something we can go look at so I think that I think this is the challenge of bringing so in general I would say when you look at a lot of data and you’re bring it into a company there is a large issue around just thinking through okay I have all this information what of the information is valuable what do I focus on that’s that is a hard

20:25 do I focus on that’s that is a hard thing to do and especially to your point Seth people in leadership position especially when they make directional calls hiring Talent getting people on board running the same direction trying to win in that in that scenario whatever those wins may be defined as someone’s got to take responsibility and I think also there’s an opportunity to say hey look that didn’t work let’s let’s Corral the minds let’s figure out a new strategy let’s try something a little bit different what what can we do slightly differently that will help us

20:56 slightly differently that will help us adjust to a new situation okay thank you guys I feel feel better Tommy all right we have we have completed Tommy’s therapy session around the Yankees this morning so

21:09 around the Yankees this morning so with that let’s move on to our main topic today so let’s just jump into some main mailbags here Tommy kick us off with our first mailbag items pick our first topic and we’ll go from there we’ll start with this one this is from 108 again no name or no we do have a name Blas if did that oh we did or did he submit multiple no I think you’re right we did do that one so let’s start on on 1017 no name here please leave your name can you talk more about different

21:39 name can you talk more about different powerbi solutions are shared for seamless user experiences particularly I’m interested in knowing how can I use my reporting as a product service for analytical reports that we created for external users oh boy clients I love this question this is is a great question by all means I’ll jump into this one so let’s let’s start off with just so there’s two I think there’s two parts of this question first one is how

22:10 parts of this question first one is how do you work out a seamless experience for reports right so if you’re talking internal to your company I would highly recommend you focus on using apps to share and distribute your content I also think there’s a very relevant area here once you start embedding apps internally to your organization why not put them in teams why not put them in SharePoint put put the reports where people need to use them so I think that’s a really great opportunity there for if you’re just talking about a seamless user experience

22:40 talking about a seamless user experience I will say this I think in in that user experience you do need to do some bare minimum or bare level of Education around hey you’re a consumer of a report here’s how you document this here’s what this report means here’s walking them through training on the report and being able to show people very easily how to get back to those reports in a regular fashion we can’t always assume everyone like is 100% power. com Rockstar and knows how to navigate everything on that website so I have I air on the

23:11 website so I have I air on the side of simplify and think through that user experience of what how’s the what’s the easiest way you can get things in front of people where they’re already doing work and I think Microsoft said it themselves by integrating power behind teams together people are already doing you’re already leaving your team open all day long anyways so if you’re already in a tool why not embed parbi right there in front of it where you can have conversations and there’s like communication threads and you can you communication threads and you can comment on a report and know comment on a report and make bookmarks and send them to people

23:41 make bookmarks and send them to people and show them here’s what I’m looking at conversing about the data might have helped the New York Yankees get better at their data if they were actually talking about it I don’t know so those are those are the things I want to comment there I’ll I’ll pause I have another thought on extra internal sharing of data but I’ll just pause right there and get your guys thoughts on what does the seamless user experience look like for you for your teams for external facing customers well

24:11 teams for external facing customers well it sounds like the first that there is a two part to this right first part was just general what does a seamless user experience look like and then the second part is particularly focusing on how would you also make that experience very seamless from an external client standpoint 100% 100% fan man put it put it all in one location and yeah and mainly to your point because Microsoft is extending that into places where people are every single day and when you can do that withing it’s a huge win every time people every time

24:44 a huge win every time people every time I’m showing people that what I’m sharing with them is easily accessible and they can add it right in teams they freak out yeah they’re like oh my gosh it’s already there amazing there’s no side scen you literally click on it you’re boom you’re in it’s awesome yeah and it what it does is outside of just sharing a report with somebody is great it’s in their long list but they need to know that they need to go out to the parbi service right like go go to things that are shared with them and then that’s where they interact with all their reports which is it still viable very

25:15 reports which is it still viable very right but it it centralizes things around the powerbi service whereas with an app you’re consolidating all those reports right there right there on the left hand s nav side you’re controlling what gets pushed out out there there’s that Dev experience where you can validate things before it gets in the app like it there’s just so many good things but from a Shar shared or consumption perspective I find it’s it’s the best I I think you you guys are speaking of both to me more of the need for the

25:45 both to me more of the need for the proactive side I think user experience and training support are are hand inand because you can have the great teams experience you can have the great app experience but if people don’t know those experien either exist or more importantly are not them yes to me that’s that’s where the that’s where maybe the the conflict is or or the lack of adoption I want to be out there I don’t want to say oh we have a link towards a video that you can have obviously have that but what are you

26:16 obviously have that but what are you doing to promote whatever your end point is what are you doing to tell people hey there’s this app or you can add it to teams or we already have this existing solution available for you marketing look at these 10 marketing reports I think having a consistent campaign or promotion around a different departments on what reports or contents available it’s going to help with that because once they get into this solution well now there’s a whole other experience that they have to master that’s the

26:47 that they have to master that’s the report so just because you have this nice frame do they understand the picture in it another another thing I’ll I’ll point out here again if we’re talking about seamless user experiences in general I think we talked on on a prior episode around the idea of there are certain questions that are repeatable against the data every single week every single time period that you’re looking at and there are more ad hoc questions like I don’t really know what’s going on here I’m just trying to dig in and figure things out I think those types those two types of questions really form

27:18 those two types of questions really form do I need a pre-built Report with a set number of visuals that are going to answer the same question all the time I think report definitions and why this exists is incredibly important to communicate to those users because often I feel like when a report is built users understand what’s there and then have additional questions above and beyond the initial scope of the report and it’s those additional questions that require rethinking large tables some

27:48 require rethinking large tables some analysis off off on the side right it you start talking about a bit more of a self-service method of we have this data structure but we need to answer other questions that are out of the scope of the initial build and so that’s going to happen how to plan for some of that how how do you educate and pl around those things real quick to your point because this has been a constant minor theme throughout the last few of our episodes on not just getting someone there but I think there needs to be more of a question on what do we do when people have those questions do we have a good

28:19 have those questions do we have a good Avenue door or in a sense key for them to begin to ask those next questions like if they if they have an additional another angle they want to look at that report or they have those additional questions that they can’t just do from personalized visual have we made it easy for them to get to that point where I want I have this report step two is I want to ask how do we enhance this report or how do we enhance these measurements easier is really something that we don’t have that’s direct but I’m

28:50 that we don’t have that’s direct but I’m I’m more and more as it’s come up on our podcast and our conversations I’m thinking more and more like that has to be a more direct way for users we have to make this more accessible to them make it a project and not a product or the other way around a product more so than a project it’s not a one and done right right but how how do we make that more accessible that that may be parking lot for another day but more and more I’m thinking that has to be an easy like an easy

29:20 to be an easy like an easy button I think if if we’ve done a good job rounding out this portion of the question yeah i’ let they transition over to what an external experience looks like and what I would say is right now from my experience the Microsoft pre-built external experience of I’m going to share this report with an external user I would say is subpar and it makes sense why they have to do it the way they do it because you require that someone’s email address is attached and signed to signed in to that user and

29:51 signed to signed in to that user and brought into your tenant so I feel like some organizations are very hesitant to add a whole bunch of sharing externally from the powerbi service yes is a subpar experience that’s what I’m trying to yeah that’s it’s it’s a there’s a little bit more setup there’s a little bit more licensing required and I’ve been told that if someone else in a different organization has a powerbi pro license and you invite them to your environment you don’t need to give them a powerbi pro pro license I’m not sure if I’ve ever really

30:21 license I’m not sure if I’ve ever really seen that work correctly it may work totally just fine but every time I’ve done something like that it doesn’t seem to drag that license with them into my environment to see the reports that we’re providing into that user so I’ve had a I’ve had a challenge with just in general it seems to be over complicated everyone you have to add users to your active directory tenant ID many companies larger companies particularly don’t want to add a whole bunch of guest users for stuff because they don’t want to manage that inside their tenant they want a different way to manage that so

30:52 want a different way to manage that so all that to say oh go ahead no and I agree with you I want to lean into like the subpar experience right because if especially if I’m a company that already uses uses powerbi right I I know how to use the tool I know where to find my artifacts I can go out to my powerbi service and I can see all the reports that are shared with me I have apps we just talked about those from an internal sharing experience how I interact with a

31:22 sharing experience how I interact with a different tenant is I have to retain the URL link yeah I have to know that report URL link every single time and that’s how I access a system and like if I’m going to have an external customer right that’s a bad exper like hey I’m going to share these five reports with you they’re five individualized URLs and the

31:43 they’re five individualized URLs and the only way you can access them is by hitting this direct URL like that’s just not a good experience well what’s interesting is they they’ve made it it’s it’s a better experience when you’re an external customer collaborating with data sets than it is consuming so Mike you like we we worked on a lot of things and from the consultant side I have access to someone’s tenant that’s great to great to build Tommy’s been yeah so Tommy’s email address is in my harbi tips tenant and I’ve given you access to the things you

32:13 I’ve given you access to the things you need to have access and I’ve provided you a license for your email address in my tenant the service the other service experience is fantastic yeah like 90% there there’s obviously some hiccups with there’s a couple hiccups yeah but it’s been great you’re right like between the two of us we’ve been able to build pretty much anything and now with the addition of the notebook experience yeah Tommy and I can create very seamlessly we can be in the same notebook he can run stuff I can run stuff it’s it’s a nice experience this again this all ends at the app and the report sharing

32:44 ends at the app and the report sharing perspective and that’s where it gets I think a bit more friction involved right so with that I would say okay there are other Solutions out there that that provide a really good embedding experience I think if you’re trying to make a seamless experience for external users you’re using powerb embedded You’re Building you’re crafting your own experience around how do you log in what reports do I show you how easy to click on those reports and bring those up in front of you and can those users download or not download data from those

33:15 download or not download data from those reports my opinion here is you’ve already you’re now pushing yourself into the realm of you need either an off-the-shelf solution or you need to go build your something where you’re doing parb embedded and Microsoft does provide some good examples around that it’s easy to embed it’s difficult to get all the things around embedding figured out because there’s a lot more than just what what you’re essentially doing is yeah you’re creating a UI a portal a portal to to embed report so there’s an experience that you’re instantly put into like you need a developer or you

33:46 into like you need a developer or you need a framework in which like that is accessible and easy to do because that is the answer right how do you create a sh a seamless experience for external users yes you put them in this environment where like you can control whether or not you’re you’re doing the user access and permissioning right and or do you need to know everybody’s user and you’re going to pass that back to your reporting you can customize that experience exponentially in that applica like you’re not just stuck reports you can do anything you want but

34:18 reports you can do anything you want but from a from a interaction standpoint 100% with you like yeah Power embedded in an application but you ramp up and you need to like set up that platform to start interacting with your your service and embedding and embedding has gotten better over the last couple years they don’t have all the features that I think you would all need but I think because the flexibility of the app build yourself you can do a lot of different things and you can solve for a lot of challenges by fixing things and just you just get much more control of that other

34:50 just get much more control of that other user experience by using the embedding apps so that’s what I would focus on go find that embedding experience really think through how you want your users to experience your reports and know dig around go find Solutions I’ve got a solution out there other companies have some solutions out there as well about how I make that fast and easy for you to start embedding so I’d recommend that if I was going to say an external user the last point I’ll do there and maybe we move on is you’ve already spent time making models making reports you need to reuse

35:21 models making reports you need to reuse that investment of time back to your customers if you’re not thinking like many companies start with internal reporting first like hey look we find some value if you’re at that stage you seriously need to think about where in your company are you giving data externally and start focusing on how can I make that experience more seamless where you externally share data because you’re already doing the hard work you’ve already got models made figure out how to make that an experience a paid experience make your customer sticky with you so they keep coming back

35:51 sticky with you so they keep coming back for more data that is a big hesitation I know where I’ve talked to a lot of clients like well like well you can create Ro level security we you have Mike you from a small business point of view you have a great solution if you want to talk about Enterprise talk to Seth Perfect People for external here but they’re like well we created a report for every customer it’s like but it’s the same data put in one and you can scale this out which again I think it’s there’s there’s a lack of you I don’t say lack of use but it’s it’s 95% of what we do is internal for the most

36:21 of what we do is internal for the most people so now all of a sudden you have to get the experience around the 5% so but I I’m very excited about the next mail bag I’ll end there I want you to say this one is this next question for me okay I think it’s next question is teed up for me as well so let’s do the next question here so next question is first and foremost there’s no no name on this one so this is from a no name but this is a great question nonetheless data Mart not begin I think your last episode on detailing what a dataart is was at episode 140 and

36:53 what a dataart is was at episode 140 and 135 it’s time for an update I guess it’s dumb to use data Mars in production since they are still in preview and they’ve been in preview for quite a long time but come on preview for over a year question mark question mark question mark exclamation mark I’m sure that we’re I’m not the only one heavily using them will Microsoft discontinue them in Fabric or will they roll into the new data Factory synapse experience of course the data Factory syap experience that they’re now

37:23 Factory syap experience that they’re now rolling into fabric require it to get group Buy in rather than just the business bi developers your thoughts can o worm on this one so is this still a preview it’s I I think check it Google it right now is it data Mart still in preview I think it is actually I wonder if that’s not a good sign it’s not a good sign if it’s still in preview after this long time I I wonder we did the data Mars who did

37:54 I I wonder we did the data Mars who did we interview our our one of two interviews Charles Webb Charles Webb yep and he was the he was the PM owning the the yeah data Mars experience and I think at that time because that was was 2022 right the summer of 2022 or at least potentially the fall I don’t I’m sure fabric was in the works but I wonder if they’re like oh well this is great but we can mix this with a

38:24 this is great but we can mix this with a lot of things it was like the evolution of what fa was going to be I don’t think we’re going to see any updates with data Marts anymore I can’t imagine we do that’s that’s literally the default data set in a lake house only a lot better experience that’s what it is I can’t quite figure out what data Marts are honestly in my in my opinion I feel like a data Mart was this concept of it’s a SQL Server that has stood up where you can go read data from powerbi. com things make views

38:57 data from powerbi. com things make views like you normally could but I I have a suspicion again I don’t I have nothing to confirm this this is totally suspicion I feel like the data Mars experience is a dedicated SQL environment therefore it had to get stuck on premium so it was like Hey I’m going to turn on a SQL Server that’s what I’ll use on the flip side fabric just came in and said look we already have this thing called SQL server list which is in synapse we’re going to bring that experience to the users and now from a Microsoft St point they’re able

39:27 from a Microsoft St point they’re able to run more efficient code on the back end with the fabric equivalent data Mars I I don’t think there’s anything in a data Mart that’s not being done inside fabric it’s lakeh house Alpha I I think you’re right I think it was the early version and I think what happened was I think there was a direction shift where data Mars were going to be the thing they probably rolled it out and thought this is a good idea but no one really bought into it and I think initially when when the data Mars rolled out I had a lot of trouble figuring out what is

39:58 a lot of trouble figuring out what is the data Mark like what is really going on there it was a blend of like squl SQL stuff views and tables and then it was also a blend of analysis Services because you could make relationships and you could also make measures in it that would be used in part so it was like this really H really weird hybrid of it’s all SQL and it’s all analysis Services all mushed into one product and I think there was a little bit of push back initially but now that they’ve changed the core of what they do now by moving to this Delta format it

40:30 now by moving to this Delta format it just rocked the entire project and I think data Mars is no longer going to be supported long term I don’t think it’s ever going to get out of preview I think you’re just going to roll over to fabric which is which is interesting right because radad did did an article on this of of like the three different ways right in June and one of one of the things that stuck out to me is it’s it’s a licensing thing right like data Marts are only available in PPU correct oh

41:02 are only available in PPU correct oh because they had to spin up think a we’re talking about solution right so it’s like it’s almost like okay premium capacity if you want to stick yourself in thisr as a PPU like you’re not on like you’re not on a fabric because you don’t want to pay you don’t want you’re not in premium spaces so is that a solution for companies that don’t want to do that but at the same time like if it’s not supported in other capacities how would I how would I move into a premium space right so I think there’s some complexity there but like to your

41:34 some complexity there but like to your points and to the question what’s what’s striking to me is that as we get stuck into the where and how to do things and or the teams that have to get involved like that’s the whole point of fabric right like if you were using dats you don’t and you get fabric you don’t need them involved like you can figure this stuff out it’s not an additional Li it’s not an additional service it’s not an additional group it’s a workspace that

42:05 additional group it’s a workspace that everybody has access to the artifacts that allowed you to create a data Mart in the first place and and I think too like I don’t think data March are going to fall by the wayside because a lack of execution I I think I all the confidence

42:17 execution I I think I all the confidence in Charles web I always go back to the Steve Jobs mentality of whenever a product’s released what does it do better than what’s previously out there is it better than is it better than the iPod at listening to music is it better than something for browsing the web in the same way we know scorecards like it’s better for looking at your kpis than just a dashboard or a report but a report’s better obviously from the interactive side we have the lake house now which has a clear identity and I think data March we all struggled with from the onset okay if

42:49 struggled with from the onset okay if this was to be in production where does this go in the workflow and more importantly what does this take place of what is what are we substituting out if this is going to go in to our workflow and I think that was always unclear whereas like I said if you look at the components is a SQL Server Like the data is like the Warehouse has spun up the SQL endpoint for a Lakehouse except it has all the other components where I can support this this be can become the beginning of my workflow in the lakeh

43:20 beginning of my workflow in the lakeh house but it has all the same components data flow connection to get the data in modeling the relationship but a much better way and not nearly as buggy and it can be that that starting point I I just think data data March from the onset just didn’t have a clear identity on what it was going to take the place of that being said all the components are there that what’s in a lake house now I would I like your your point there Tommy I think that was a very solid Point what does data data Marts do

43:51 Point what does data data Marts do better than Fabric and I’d argue if nothing there’s nothing better that it’s doing than fabric if anything Fabric’s got more features more capability more ability to do data engineering and I think as I look across like the the and I don’t know how I don’t know how you roll this up but I there’s a feeling a general feeling here that if you’re doing analytical things analytical things are reported on slower and there’s this trend at the operational system side of things is more rowby row

44:21 system side of things is more rowby row based it’s a it’s it’s row level information that you access one row a time or modify or add things in a operational system the reporting side is all column stuff that’s why we have column or stores that’s why we access data in like tables and we need to aggregate things so the Coler formatting of how data is accessed the reading efficient read of that information has entirely changed how we like look at large amounts of information yeah so I think that me that mentality we have to remember that SQL Server is really good

44:52 remember that SQL Server is really good for row by row level access of things and it’s good at aggregating things too not not going to discredit it but you need to be a bit more familiar with its technology to put like keys and indexes and and make sure that it’s doing things in a efficient way whereas when you move over to this new Lakehouse environment everything’s being stored in a way as you’re creating the data engineering it’s already being stored in a hyper efficient read way and and you’re you’re not trying to access

45:22 you’re you’re not trying to access individual rows in real time you’re now saying for recording we really don’t care about what happened today we really care about what happened yesterday and older and there’s only very specific use cases where I need access to data right now within the last five minutes to make a decision so I think the mindset shift is different between SQL which I feel like is more operational databasing in nature that’s more of an operational system thing and up until this point we’ve only kind we only had these SQL servers servicing all of our

45:52 of our reporting me as a report developer I don’t want to turn on a SQL server and let it sit there and eat money yeah for an entire day just to get a one-time refresh of a cash of data that’s sitting in a powerb data set like so to me makes no sense I there’s no reason why I want to keep that SQL server on all day just to load data for two hours in the morning so there’s got to be a better more efficient way and I think that’s what Microsoft’s pointing at look when they look at reporting 90% of what’s maybe even higher 95% is batch loading

46:24 maybe even higher 95% is batch loading once a day lots of data and it needs to be pulled into queries inside your your query engine so I would say this fabric has got more capability than data Marts fabric I would guess is closer to getting out of preview than data Marts is at this point so I would start looking seriously at your data Marts and focusing on is there any workloads you can move out of there and move over to a fabric equivalent I think you’ll get and

46:55 fabric equivalent I think you’ll get and licing wise you may have to yeah and Licensing wise you may have to but if you’re already on a P1 anyways yeah maybe you change your P1 to Something in Fabric and again we don’t know the prices you could you could be doing PPU plus P1 I guess PPU plus maybe yeah you join the two together regardless I I would say like I think it’s I don’t think it’s a long-term investment if you have stuff on production right now I would seriously take that with like some backlog items and focus on are there

47:26 backlog items and focus on are there other ways to solve the same challenges we’re solving with data Mars and is there something else we can do now with fabric can we start replacing portions of it like if if there’s Mission critical stuff happening on it I would probably I would probably move I would probably focus on let’s plan some work here we’re going to migrated out of there at some point so that would be my comment on that one I I think I think Mike’s gonna talk a lot about this next one too but you read this one Seth oh yeah I do yeah I do 927 from 927 no no name so thank

47:57 927 from 927 no no name so thank you thank you no name I recently found the podcast because I stumbled on the chartic tutorials Mike Carlo posted on YouTube right away I’m getting great recognition within my company for building more complex customized visuals beyond the standard visuals within powerbi are there other tools resources out there for people like myself who want to differentiate themselves with more complex visual Inside powerbi Yes and bad news

48:29 let’s start let’s start with the bad news bad news Microsoft has officially killed chartic yes so so there is no more investment in supporting that from Microsoft side from Microsoft side I’m hoping that they push it towards more of a hey let’s open source the whole thing because they’re not going to support it but maybe the community can there there could be a path there however I think one that is much more exciting that Mike is much more engaged in and probably could create a lot more content

49:00 probably could create a lot more content around even though there’s already a lot of great content coming and out there are the den visuals right Mike yeah so I’m GNA definitely jump so I think chartic was a great jump into for many users to start learning how to build custom development stuff as you think about when you’re building visuals in desktop versus going to use custom visuals from the store versus building things with articulator articulator was a very drag and drop type experience I can drag these data fields to this these

49:32 can drag these data fields to this these data fields got properties and then we were able to light up the chart with with articular so you really have to take your me your mind and say what data do I have and how can I represent that data onto the graph there’s a mapping activity of saying I I’m going from a table view how does that table get interpreted as visual elements on the on the report and I think chartic did a great job of very click and Dragon trop area I will say this it had a number of really buggy things in it that were just very difficult for you to get over your

50:03 very difficult for you to get over your you had to like really learn it it was had a a pretty steep learning curve one tool that has come out since then which is a tool called denb denb is not owned by Microsoft it’s owned by Daniel Marsh Patrick who’s done an incredible job on it go ahead Tom me he denb is actually a whole visualization platform outside of Just powerbi 2 well the language of theb yes denb itself is not so the denb custom visual is from the Microsoft store they just released version 1. 6 which is amazing right and

50:35 version 1. 6 which is amazing right and denb builds on top of two open source they call it I want to say the the visual grammar is it a Vega no no I’m actually looking for like the the methodology of methodology of what it’s it’s hold on let me just go to the website real quick here I’ll I’ll tell you real quick here it’s like literally on the declared visualization that’s what they’re calling it a declarative visual is I will tell you a specification here’s how I want you to handle this table of data I’m going to give you so it’s it is a grammar

51:08 give you so it’s it is a grammar language that describes the visual in Json form Denette Builds on top of this thing called Vega and Vega light right these are two open- Source projects developed by universities maintained their Community projects and people invest in them so all this visual is doing is it’s using these other open- source languages interpreting their code and you write out a spec and then the visual gets built this my opinion this is what Microsoft should have done to build their standard visuals this is where

51:38 their standard visuals this is where they they should have picked up this open Vega and vegga light spec they should have made this part of all of their visuals because you can build any chart that’s in desktop and then some and then you have full ability to customize that visual to a high degree so now now so let me let me step back to your question right are there any other tools or resources stay tuned there’s more things coming from our YouTube channel on parbi tips we’re going to do more things around theb we have a two video series around theb

52:08 have a two video series around theb currently there’s going to be more coming I’m I’m very much learning it myself and think there’s a lot of opportunity for people to get into it chigul is out of the is on its way out it’s sunsetting move over to denb learn Vega light it’s easier then as you get comfortable with Vega light you can move into Vega which is more verbose it has more syntax you need to to write but it is way easier to build in that application than it is to build inside chartic at this point and

52:39 build inside chartic at this point and again chartic is currently not supported by Microsoft anymore so I have a question and it just goes to show I think our 48th episode we we talked about articulator like focused on it

52:51 about articulator like focused on it Microsoft’s as much as we’ like it to they’re not going to focus on I think a advanced visual in the middle it’s either custom visuals SDK or it’s going to be the core visuals that’s where Microsoft’s going to focus their money do we ever see a point or maybe why do we think we’re not going to see Microsoft focus on that middle area of a denb or chartic like feature there’s a reason why I don’t want to say they gave up on chartic but they deprecated it and why denb is not going to be something

53:22 why denb is not going to be something that Microsoft’s going to invest their own dollars in they’re going to continue to let the community do why is it the two two extremes well like like I think it was on a performance honestly I don’t think so because Microsoft’s a framework Builder they they build the Frameworks by which we run our businesses and there’s this wide gap of other Industries and other companies that have built Solutions on top of those as

53:53 built Solutions on top of those as third party solutions that enhance the user experience right Microsoft is like and that’s this is this is fundamentally like one of the things I had to like digust too is like why doesn’t Microsoft solve these problems when everybody tells them that they’re we need these problems solved because there’s this wide Gap that they’re creating for somebody to step in like Daniel Mark prash right taking Vega building denb and now we have a solution for it so why does Microsoft need to need to solution and build everything they don’t as long

54:25 and build everything they don’t as long as the platforms are open enough and that’s what like I think there’s been a fantastic progression of opening up all of these things so that other people can enhance the solutions because we’re boots on the ground power tips does this as well right we can make better Solutions the more Microsoft has built a platform that sustains more things so they’re they’re a framework Builder and I think ultimately like looking at them to solve every every one of these one

54:56 to solve every every one of these one like not oneoff but like solution type things are where they’ve just created the space and as long like they’re much more apt to saying oh if you me you mean if we if we did this and allowed you access to that that would open up this whole industry of like people to build stuff on the plat sweet okay we’d much rather do that than go build our specific version of something that’s why well and I think I think you maybe misinterpreted a little bit of what Tommy’s question was and I’m

55:26 bit of what Tommy’s question was and I’m maybe rephrase what I heard Tommy question I think you’re everything you said was 100 right 100% right nothing nothing no disagreements there the platform is open enough that allows anyone else to build custom visuals to whatever they want to do awesome like perfect the the thing I think Tommy was asking was why doesn’t Microsoft make every visual a denb type visual like every visual has code under the hood that you could adjust and manipulate was that your question Tommy or were you talking more about what Seth Direction was was going oh you’re on mute you’re on mute you just sneezed if they’re create yeah

55:56 you just sneezed if they’re create yeah if they’re creating a framework for the be the beginner stage with core visuals and they’re creating a framework for the advanced developer there’s no framework in the in the middle okay so so maybe that is what your question is so one of the things one of the reasons why I think Microsoft is not going to go pure like why doesn’t Microsoft just say look every visual is now built like a denb visual here’s the list of properties this denb visual can do will let you integrate with those things right the reason I think why Microsoft’s not doing that is they’ve already got so much Tech de in their existing visuals that they’ve built it’s

56:27 existing visuals that they’ve built it’s going to be very hard for them to move everything towards a denb like or a Vega and vegalite specification for all those elements so I think that’s one I think that one I think that’s an an element there that will happen also with this is I think there is a performance Improvement like when you control the code and you write the C the visual in desktop the way it needs to be written they do each visual has a little bit

56:57 they do each visual has a little bit different challenges like you can’t use a table the same way you could use a bar chart like there’s going to be differences there so I think Microsoft wants to reserve the right to be able to custom build those visuals the best way they know how to make them for desktop to make sure that they are the most performant so I think there’s always there’s always going to be a gap between what the standard visuals Microsoft built and everything else that is custom visual built because there needs to be a performance G there’s a performance like tuning that needs to occur between what

57:28 tuning that needs to occur between what a Vega a Vega light can do into the desktop so I think that’s why they they’ve separated the two I’m very happy that they’ve opened it up for custom visuals I think it’s the right choice that way we can get tools like chartic and denb in the world and I think that definitely rounds out our experience regardless I would say study this stuff there every day I’m seeing more and more denb visuals appearing on the internet everyone’s building them everyone’s sharing their templates and their specs and their designs as you become a let’s call it a 300 or

57:59 as you become a let’s call it a 300 or 400 level powerbi report Builder this is a tool that must be in Your Arsenal if you tell me you’re an expert at building power be you’re a very good expert I would expect you to know theb exists I would expect you to have some samples of theb visuals built if you’re on that upper echelon of I’m an expert report Builder shout out to Kelly Kosco because her I love her templates and car K Kos car she’s also a great educator in that space she’s playing with it she’s figuring stuff out her visuals are

58:29 figuring stuff out her visuals are second to none they’re just beautiful yeah awesome burn one last one end one this will be simple so I don’t think it’s I don’t think it’s as simple as you think it is go ahead go ahead in the age of powerbi this from no no no name is still is there still a use case for Microsoft Access what’s your answer Tommy no no move companies move companies leave leave

59:03 companies move companies leave leave quickly you can’t have a different opinion I think I think you should just use data Marts honestly wait hold on hold on is your company using access Seth no okay but for you to presume that no company is using access no I didn’t say no company is I said if you’re at their company but you’re saying no company should or should be planning to migrate out of into powerbi is what you’re kind out of into powerbi is what you’re saying I’ve been part of an access of saying I’ve been part of an access company and that was like 10 years ago and it was horrendous yeah it’s a mess

59:33 and it was horrendous yeah it’s a mess yeah it’s it’s many databases it’s like having a thousand data Marts all over your Shar drive it’s it’s almost like implementing a CRM without anybody who understands databases or architecture yeah it’s it’s the business running wild without any understanding of how databases or anything work that was that’s what Ms access was but are they but are they choosing it because someone never gave them the right tools like I feel like this absolutely they found their own solutions they found their own solution here’s what we’re

60:03 their own solution here’s what we’re going to do correct but and I feel like that’s it’s like stop always hit a point where business goes what is going on oh it’s going to take us how long to unwind this yeah oh yeah thanks because we need to move in this direction and that’s that’s where the it part of things come into play we we try to chain us we we had powerbi and axis but we had to use both they’re like okay we’re going to train you on axis an hour into it I’m no no this

60:33 it I’m no no this is yeah so I think access was good in the day when it was able to have hund millions of rows of data in Access that you couldn’t do an Excel right so you had Excel and that’s it solution for the time it was a solution for the time I would agree that’s a great way of saying much better much better Solutions yes and bigger so we now have more data we have more data so I would say access was good in its time it was a great workaround for when Excel couldn’t do it but you need a little bit more horsepower and you wanted to write some lightweight sequel against these

61:03 some lightweight sequel against these larger data sets cool but I think now we’ve made it to a point where okay we don’t really need that anymore the powerbi analysis Services engine is could be that access database for you now and now you can share it and now you can build like there’s a whole bunch of new like it’s literally access databases but like times 10 like you get all these extra bonus features around easy to share Discovery all this extra stuff so I would say if you are an organization that still has Microsoft Access you should seriously look at Fabric or you

61:33 should seriously look at Fabric or you should seriously look at doing migrating your workloads into just powerbi Pro as as data sets or the semantic model as we should Now call it thank you yeah yeah argue a data Mart is probably better than an access I would prob that well time just like Ms do was a tool in his time to play video games it’s true yeah well that’s that’s a great question I think to end on here so thank you all very much for your time I appreciate everyone listening to this podcast I hope this were some questions here that hit your your ear and I hope

62:04 hit your your ear and I hope you learn some things about the New York Yankees as as Tommy has educated us earlier in the episode but thank you all very much if you like this episode if you like the the answers you heard for these questions or if you have other thoughts around what we talked about please put some comments below what we want we read those we we respond to them if we can so please put some comments about your thoughts around these topics as well we’d love to hear from you as well with that Tommy where else can you find the podcast you can find us on Apple Spotify or wherever at your podcast make sure to subscribe and leave a rating it helps us out a ton do you have a question idea or a topic that you

62:35 have a question idea or a topic that you want us to talk about in a future episode maybe be on one of the mailbags like we did today head over to powerbi tips podcast leave your name and a great question so we can mention you join us live every Tuesday and Thursday AM Central and join the conversation live on all powerbi tips social media channels awesome thank you so much for listening and we’ll see you next

63:25 time oh

Thank You

Thanks for listening to the Explicit Measures Podcast. If you have a topic you’d like us to cover, drop it in the suggestion link above, and we’ll add it to the queue.

Previous

Data Products – NOT Projects – Ep. 269

More Posts

Mar 4, 2026

AI-Assisted TMDL Workflow & Hot Reload – Ep. 507

Mike and Tommy explore AI-assisted TMDL workflows and the hot reload experience for faster Power BI development. They also cover the new programmatic Power Query API and the GA release of the input slicer.

Feb 27, 2026

Filter Overload – Ep. 506

Mike and Tommy dive into the February 2026 feature updates for Power BI and Fabric, with a deep focus on the new input slicer going GA and what it means for report filtering. The conversation gets into filter overload — when too many slicers and options hurt more than they help.

Feb 25, 2026

Excel vs. Field Parameters – Ep. 505

Mike and Tommy debate the implications of AI on app development and data platforms, then tackle a mailbag question on whether field parameters hinder Excel compatibility in semantic models. They explore building AI-ready models and the future of report design beyond Power BI-specific features.