something that's going to separate a good report from a great report is the performance and what
we're going to look at in this video is how to use the performance analyzer to assess
your report's performance and identify areas for improvement behind the scenes in any power
bi report that's using dax formulas and dax logic to generate and display your results
and the way that we can look at this is you go to view performance analyzer that's how you get it
to show up here on the side let's just get right into it let's not play around and what we'll do is
start recording so this is something you'll do locally let's try to adjust the filter here
let's say we want just eastern conference right away we can see you pick this up there's a dax
query there's visual display other what this is saying is here's how long the underlying query
processing took here's how long it took to render i've seen some examples where the query is really
fast but sometimes it takes for whatever reason a really long time for power bi to render it and
i've also seen the complete opposite probably more common is that your query performance behind the
scenes is overly complicated it's taking forever once it finishes it displays quickly but that's
a sign that okay something about your underlying query needs to be improved let's play around with
this some more maybe we want to add these in we're seeing change filter what else what else can we do
maybe we want to exclude this again it's just offering it as a change filter i guess i don't
have too much going on in this page but that's okay you get the point another thing we could do
is refresh visuals i'm going to do it again i can see the full time for that maybe over time it gets
a little bit better basically the same but these are the things you can play around with let's say
we want to add a map and in the map we add some more fields we'll do city state hopefully it can
pick it up i think it will okay so we got a couple dots on here and so if we refresh all visuals now
it breaks both of them down this home city is representing that map let's say you want
to see those queries that it's running as you see here it says copy query so let's click this
it's going to copy it to your clipboard and i opened up a visual studio code editor here
and let's drop this in here and here we see a very well formatted i should say dax query
and it shows you exactly what behind the scenes power bi is doing to process whatever it is in
this case it's the nba players table now imagine if you had probably more realistically some custom
things in here or maybe you're pulling something from tabular model that behind that is running
some custom dax this is where you can start to pick apart where things are happening and
maybe you can grab this part out and and try to run this on its own and analyze it that way i'm
going to go ahead and stop this and while it keeps it here what you can do is actually export this
vlog here let's click export we have our reporting themes from a previous video but we'll save this
as performance.json it's going to be this big json file that we can open up here let's open this up
and i mean this is hard to look at let's see if i can at least give us something okay you can
see it is doing some monitoring i'm not going to go through step by step what each of these things
are i'm sure there's a ton of documentation on this you can see some information on the queries
here these big blocks and in my mind the way you would use this type of information maybe you have
some automated script that's going to pull some things out to maybe analyze performance hits or
regularly check if something's hitting a threshold or maybe you just manually want to go through and
read this you know what you want to look for personally i haven't used this output much but
i have to believe there are some uses for it once you get the hang of it and you can do maybe some
automation on it and that is available for you there the next thing i want to show you is this
github page which is actually pretty interesting i was able to find this as a github page for the
power bi performance analyzer the first file we have here is the sample json file
and this is giving you the schema of what's going to return to you here's the events
captured from the performance analyzer and all that stuff that we just looked at a minute ago
you know all this stuff in here name component start end here it gives you a description of what
each of these mean and how you could use it so this next one here is actually a power bi report
that you can use to analyze i actually didn't even realize this when i was first going through this
but this file here is something that you can take the output that we just looked at and it's going
to basically show it to you in a way that's easily readable information about what's happening maybe
over time let's see how we can use this select the performance analyzer export file which we
just exported a second ago by specifying the path in the m parameter so we'll go home edit queries
and then edit parameters and here's transform data edit parameters that's not where we kept hours but
change this and see if this works okay apply changes this is actually real time testing
for me i haven't tried this myself so i'm really interested to see how this worked it looks like it
captured it metadata okay so visual nba players the map city all this stuff is being captured
from that json output and given to you this again for me is very simple you can filter it however
you want see what this timeline is i'm not quite sure what all this is but i'm sure we could play
around and learn a little bit more about this but what this looks to be doing is taking this
really long output that i mentioned that you could do something with it and it turns out there is a
solution and you can just plug and play that's that second option here and the last one let's
take a look is a word document and if we open this up this is going to give you an overview of the
performance analyzer how it's working how power bi reads it the different components of it so you can
have a full understanding of what every layer is how it gets to it and like i said this is going to
take you from an average power bi developer to an expert level you know if you understand how
this works and can not only understand but apply these things to improve performance you'll be
highly valued on any team use these resources they're there for you i'll leave these links
in the description below i hope you found this helpful please leave a comment if you have any
questions i'll do my best to answer and i'll see you in the next video thanks for watching