live_tv
Livestream Starting Soon
00
Hours
:
00
Minutes
:
00
Seconds
Up next in 10
Power Apps (Canvas) - Monitoring with Azure Insights || Power Platform Virtual Conference
Nov 6, 2023
In this session, I will speak about how to monitor the Power App usage, which navigation path of your app is most used by end users? How to trouble shoot the performance issues with your app?
About Speaker:
Krishna Rachakonda Has 18+ yrs of IT experience in Microsoft Technologies.
Mostly worked with SharePoint 2007 to 2019 and SharePoint Online application development, migrations,.
Developed many business applications using Power Apps and Power Automate.
Conference Website: https://www.2020twenty.net/power-platform-virtual-conference/
C# Corner - Community of Software and Data Developers
https://www.c-sharpcorner.com
#powerplatform #virtualconference #csharpcorner
Show More Show Less View Video Transcript
0:00
So yeah, let me just thank you for the all the intro
0:08
I would I would like to reiterate, I'm Microsoft Business Applications MVP
0:15
I became in January 2021. That's the only positive thing happened in during this COVID period of time
0:23
Apart from that, I'm a super user in Microsoft Power Apps and Power Automate community super
0:29
user where I contributed with a lot of solutions. And also occasionally I do a lot of videos in the YouTube on the Power Platform use cases
0:42
And I've been working in Microsoft domain technologies in almost 20 years starting with actually I
0:49
I started with C Sharp first version dotnet first version when it was in beta
0:55
Then I started and still working in Microsoft technologies. So coming into the actual session today
1:04
my session is on the power apps, especially the canvas applications, how we can use Azure application insights with power apps
1:17
especially with the canvas application. So the very first question for everything
1:24
generally we ask, what is it? Why do we need it and how we can use it
1:29
Those are the three simple questions generally we ask. So we'll talk about those three questions little later
1:39
because initially I'll explain a few things and with the limitations and drawbacks
1:48
or more based on the requirement, we'll start using the Azure application insights
1:56
So just to start with, you can see my screen. It's my personal tenant
2:03
In this, there is one simple Canvas application which I created out of a template
2:10
So if you don't know like how to create out of the template, you can just go to the, go to Microsoft Power Apps
2:17
and in the app section, click on new app and click on Canvas
2:23
Once we click on that, and here you see on the screen
2:27
app templates, either you can select either of these layouts and click on any of them
2:34
and you see a lot of these templates. These templates are mostly pre-built applications
2:41
with all the data source and all the content you have, you can have with it
2:46
And mostly the content it can reside in the Excel files and which are stored in the OneDrive
2:53
So I built something, I just use the service desk template. Based on that, I created the canvas application here
3:03
So just to play and see what is inside the service application
3:08
service desk canvas application, It is just a regular supporting ticket system
3:15
where we can see all the tickets on the left side, different filters are there, like a new tickets
3:22
tickets in progress, on hold, closed, all of that. On the middle of the screen and on the right side
3:27
you see each ticket and its metadata of the ticket. And the top of the screen, you can see different
3:34
the total statistics about the tickets, like how many total tickets, new tickets in progress and this
3:41
So, and also like if I click on any of the ticket
3:46
I can go and see the details of each ticket and all the metadata related to the ticket
3:54
Some of the metadata I can change it as well. So there is not a lot of security around this application
4:01
This is just like a application, some data driven application and we can just enter some sample data there
4:09
and I can change these metadata by clicking on these right and graded and symbol and you can change the status
4:17
All of that, the reason I'm going into this application is what I would like to explain here is
4:25
when we create a canos application, some of the application, your user number of users who uses these applications
4:36
can be less than like a 10 or 100 or 1,000 or more than 5,000 users
4:42
It all depends on application to application. For example, if we see in the last one year
4:47
a lot of applications were created to track all the, due to COVID situation, due to handle all the COVID-related situations
5:01
I mean, a lot of applications were created. and some of these applications were used at enterprise level
5:08
So enterprise level means maybe some of the companies, they had got like 10,000 plus users or even more
5:15
So when so many users are hitting the same application, we need to know a lot of things
5:23
Okay, how is this application is loading for each of these users
5:27
I mean, every user is having the same experience or is the application loading faster for some users
5:35
and not loading faster for some users? And what are the other application-related issues
5:42
So we go through all those issues whenever we create any application
5:46
whether it is a Power App application or any website as well. So to troubleshoot any of these performance
5:55
or usage-based or any application support-related, application related issues we really rely on so many so many things like
6:07
generally the developer who creates the application he knows when he see an
6:11
issue what might have gone wrong but most of the time some other person
6:18
creates the application as in the support team I may be supporting all the
6:22
user base so in that case how should I troubleshoot all this all the support
6:29
how I should be basically checking the usage of this application, how should I see the actual performance of this application
6:39
Without knowing those details, supporting is not going to be easy. So for that, we will see what are the out-of-the-box tools available
6:49
and how we can use the application insights to help in addition to the available tools
6:58
So if we go back to the application PowerApps page here, when I select an app on the top of the screen in the menu, I can see a couple of them
7:09
One is Monitor and the other one is ytics. Let's go into the ytics first
7:15
So ytics we know if you ever been to this page ytics is basically a bunch of reports about your application So again in the ytics we can see three different types of reports here usage reports performance reports location based reports so if my application is being used by wide variety of
7:39
users throughout the globe i i can use these reports to summarize up to some extent
7:46
okay what are the different platforms or what are the different operating systems
7:52
uh the users are using to access these applications and also what is the different power app versions
7:59
and also device platform which is the windows web players or the power app mobile application
8:06
or others and also we can see the country region all of that so we can see wide variety of reports
8:13
here um and also performance wise how fast my application is getting loaded for the first time
8:21
users and also each how long is each session is we can see a lot of reports like this and all these
8:30
reports we can slice or the filter the data on the reports by using these slicers like the device
8:38
platform or app version or app open scenario or country or region and also if you see all these
8:47
reports are showing the data from last 30 days only we do not have flexibility to get the data
8:57
let's say you make my app was launched six months ago i don't have privilege or option to see all the
9:03
six months data here because this is out of the box provided reports for different categories i
9:09
cannot see i cannot change this filter the last 38 days filter so in that case how should i do
9:16
it so that's what the application azure application insights will help us and we will go there uh so
9:25
this is one of the reason uh the second thing is uh this data gets refreshed uh if you see there is
9:32
a refresh time and it we can see at any point of time only last 30 days the next one is what i would
9:39
like to emphasize is the monitor so the monitor we know that uh generally this option monitor option
9:48
we use uh to troubleshoot any canvas applications means whenever i'm developing any canvas application
9:56
when i'm testing all business cases or use cases i can use this monitor tool to validate all my
10:04
scenarios and also this we can use this tool to see how what's the performance of my each queries
10:12
or each formula that i have written inside my canvas application for example we i mean there
10:18
are so many formulas that we use in the canvas application like you we will use filter we will
10:25
use lookup we will use a lot of other tables other other formulas as well when we are developing the
10:33
applications the application will run very smooth very fast but as the days progress we see a lot of
10:41
that our data set will grow um someday like initially the data may be like 100 records
10:47
after six months it may be 50 000 or 100 000 or maybe 20 200 000 um is my application is really
10:57
capable enough to handle all those scenarios. Did I really handle all the delegation warnings
11:04
If you don't handle the delegation warnings, you will not see the data. For example, out of the box
11:11
you may see if you don't handle the delegation warnings, then you will see the data like 500
11:18
items. Even if you expand that to 2000 items, still beyond 2000 items, you will not see the data
11:26
especially when you're filtering the data or searching the data so some of the functions
11:31
are not supported so how do i catch all of that you can use that by using i mean
11:38
one way is to wait till the user reports it other one the second thing is create large
11:43
chunk of data and the third thing is uh make your delegate i mean the app settings to the
11:51
very very minimal number of records and try to validate that the otherwise like you can also use
11:59
this monitor tool whenever you run into some issue you to validate that so in this monitor tool uh
12:07
how do i use this monitor tool so for any application uh once you select the app and from the
12:15
menu if you click on monitor just click on that then this additional tab will
12:20
open in the same browser and on that you can click on play published app so what
12:26
will happen is this option will run the last published option not any saved
12:35
features but we have to publish the all the changes as well so last published
12:41
app will run and all the operations which we perform in the app will be captured in this window
12:49
So if I click on this the app will load here and it will also notify us that you are connecting to
12:58
a monitor debug session. Those in this session will see the events generated by the app including
13:05
any data so this is just a notification that will appear for a few seconds and as you as soon as you
13:12
open here and if you go back to your monitor tab you already you can see a lot of these operations
13:18
are already captured for each of these all these operations are related to on app start when the
13:26
app is started what am i doing i'm actually loading the data from the data sources i'm refreshing all
13:33
the data sources and reading all the data into the app so that is i i have different uh data sources
13:41
in my app if i have like five five different data sources connected from my app all the five data
13:48
sources i'm loading when i when i start the app so that's what it is doing right now all the get
13:54
rows uh all of that is happening so when i perform any additional operations on the app like clicking
14:03
on clicking around on different options or going into the details if we go back to the monitor
14:10
it will keep keep gathering all that information so one very good information i would say for
14:18
troubleshooting with respect to performance oriented issues is you can see if you have any
14:25
lookups or filters or any um any similar kind of formulas we may need to monitor two columns here
14:33
one is the duration how much time it is taking and the other one is responsive size so we need to see
14:41
how many bytes of data we are loading it into the canvas app so if we also need to decide when you
14:49
you're creating app, whether you're creating it for a mobile phone or a tablet or for a PC Right if we do not restrict you if we do not provide proper formulas like a filter we need to understand the difference between lookup and filter if you need just one record
15:09
just use a lookup if you need multiple records when you are showing it in a gallery just we
15:16
need to use the filter so based on the if we try to load a lot of data using those formulas that
15:25
will consume a lot of loading time and that will delay the screen display time so that's how the
15:34
performance of the application will go down so so we can using this monitor tool we can actually
15:41
tracked on all those majority of the performance related issues by checking this duration and
15:47
responsive size as well and also any application issues also right now i don't have any issues
15:54
otherwise it will show you in a red mark as well if there are any application issues
16:00
means if some data source is unable to load or if some certain condition is not matching and
16:06
if you are performing some additional operations on that then it will still throw you some errors
16:11
here and on clicking on it you can really see the data for example here if I let's say load screen
16:19
and on the right side you see the load there is a properties pane on the right side if you expand
16:28
it you can see the entire JSON format and also the formula as well some reason it's not displaying
16:35
but you can see the entire JSON, what exactly it is doing and also the get
16:41
what is the data source and what control it is loading, all of that information as well
16:48
So keeping these two tools, one is the ytics, the other one is monitoring. These will give you
16:56
these two will help you really understand how this Canvas application is being used by all my users
17:05
means on all the users within the company especially if the application is like enterprise
17:11
level which uh enterprise level in the senses thousands of users are using it then in that case
17:20
um i'm i would like to see some additional details as well i would like to see some additional
17:28
details apart from that i want to build my own reports i don't want to just rely on what was
17:35
provided out of the box but i want to build my own reports so that i can get more data
17:42
the more data i visualize and yze it i can take more actions based on that next thing is
17:51
how i can basically how do i know if my power app some business logic was not written properly
17:58
but while I'm used while the user is using there was an error thrown so when
18:05
when an error is displayed generally the user may get some error message on their
18:10
client browser screen but how do I know which user experience which error unless
18:19
they take the screenshot and share it with us we may not know or unless we
18:25
write some logic to write the those custom error messages into some your own logs like maintaining
18:34
some shit point list or some excel file to log all the data you may not capture it but without
18:40
doing all of that custom work by simply enabling a yours application inside we can get all of that
18:49
that so but I tried to set up little ground to before we go into the Azure Application
18:56
Insights so let's get into the Application Insights now so going back to my slide deck
19:03
I got only one slide deck here so if if we take Azure Azure is a beast based in the sense
19:11
it has 600 plus cloud services are there. So many services. So many services
19:19
So how do we track each of those services are working absolutely fine
19:25
It's very hard to track unless someone experienced some issues, we cannot go and do not go into that particular service
19:35
and check it, right? So apart from one of the cloud services is Azure Monitoring Service
19:44
So this Azure Monitoring Service, it's basically monitors all applications, operating systems, resources, subscriptions, tenant, lot, many other items
19:57
It monitors. It's a common Azure monitor. A monitor service is a common service which actually monitors everything
20:04
and based on the operations or different calls happening through these different artifacts
20:13
it basically logs all that interactions into two databases. One is a metrics database and the other one is logs database
20:23
Metrics database contains the data which is really good to generate the reports
20:29
logs data, the data in the logs database, it contains in the form of rows and columns
20:38
If you see the right side screenshots, the metrics is more, the data is more ready
20:43
for building the reports right away. And logs, it is like more of rows and columns
20:50
And based on these two databases, there are a lot of other things can be done
20:57
in the monitoring service. One of them is application insights. Rest of them we are not exploring right now
21:08
but one of them is application insights. So let's go into my personal tenant
21:15
and I will create one application insights into it. And then we will try to use that insights in the Power Apps
21:24
and then how we can capture the information from the power app
21:29
So let's get into it. So I have, this is my personal tenant here
21:37
Port, let's go. I mean, we are in portal.aue.com. And here first thing in every Azure portal
21:45
we have some subscriptions. You can have multiple subscriptions. Generally this subscriptions and application insights
21:54
this needs to be done by a global administrator. So you as a canvas application owner
22:00
I need to work with my global administrator. If you are in global admin, you can directly
22:06
you can do it as well. So the very first thing is I need to make sure
22:10
I have a subscription. If we do not have a subscription, now we can't create application as your insights
22:18
So first thing is Azure subscription. Again if you are using your personal tenant can create an a your subscription again here I don want to create one but you can create an a your subscription uh again here i i i don want to create one but you can create a trial version subscription which is good for 30 days or you can also create a
22:39
subscription pay as you go means based on your consumption you can pay uh you can pay so there
22:47
are multiple types of subscriptions i used one of them so let's go back once we create a subscription
22:54
here now we need to create Azure application insights so search for application insights
23:02
so then you will find under services we can find application insights here just click on that
23:09
I already created one but we will explore how we do how to create one so let's create
23:16
so let's click on create as soon as when we click on create we will see this screen and here we need
23:28
to select the subscription that's why we need to have a subscription first and also a resource
23:33
resource group if we don't if you don't have a resource group just click on new and create one
23:39
resource group and also name you can give any name of one other important
23:47
thing is we are creating an application inside here and if you see here I can
23:52
create any number of application insights here like by clicking on create
23:56
you can create one of any number of application insights so in my company if
24:05
if I'm using 10 different enterprise level canvas applications or different kinds of applications
24:12
So application insights is not just for our apps or Power Apps
24:19
You can use this for so many other things, like you can use, if you're creating a website or web application
24:27
you can still use that application to track all the activities in that particular web application
24:35
So we are today we are using it for the power apps. So if I have 10 different canvas applications running in
24:42
they're all enterprise level canvas applications. I want to monitor all of them
24:49
So instead of creating one single application inside for 10 all applications
24:55
it is best to create 10 different application insight items here and track one one application
25:04
with one of them. So instead of creating everything and putting together in one application insights
25:12
when we put all the 10 applications in one single application insight
25:17
what will happen is all the data, all the monitoring information will be stored
25:21
in a single application insights repository. Rather, if I need to see the application specific data
25:30
I need to go into this application insight and filter the data and see it
25:34
rather than that create individual application insights and Associate your application with one each one of them
25:44
Okay, let's create one and I'll show you how to associate your canvas application with application insights
25:52
So here I will say like let's say service our inside that's my
26:00
application insight I'm creating and the region is I will select a central US and I already created
26:09
log ytics as workspace as well and now I will click on review then it will review all the
26:19
provided information and validation is passed I can click on create so as soon as I click on create
26:27
what will happen is it will try it will deploy the application inside it will create that
26:35
application inside so so the deployment is complete if you if we just refresh it we should
26:44
see more data so next steps go to resource so this is a service desk powerapps insights
26:58
so you can see a lot of other options so as soon as the application insight is created the very
27:06
the very important property that we need to identify is the instrumentation key this is the
27:14
only important property that we need to connect your application insights with your canvas
27:21
application so we need to connect now we created an application insight item and we have our canvas
27:29
application we need to connect these two so the only way to connect them is by using the
27:36
instrumentation key so just copy the instrumentation key and now you go to your power apps application
27:44
click on your apps and click on edit the application edit the application the canvas application
27:53
when we edit the canvas application only one small change that we need to do here
27:59
we will see that as soon as it comes up so we are not going into any of this part uh any of these screens we don't need to explore any of
28:14
this logic written in these screens but all we need to do is just click under the tree view you
28:20
see the root element which is the app uh element uh so here just select that on the right side here
28:28
and under the app object properties we'll see instrumentation key so i already plugged in one
28:36
instrumentation key here which is related to another application site so um all we need to
28:41
do is just copy paste the instrumentation key here and then save your application and then publish it
28:50
that's it all we need to do is just to select the app um item and for the app object we just need to
28:58
paste the instrumentation key from your um application uh azure applications insight
29:06
property instrumentation key property value that's all so once that is done now our both
29:14
application insights as well as the power app both are connected together now it generally takes 30
29:21
minutes to log any operations that we perform in the canvas app into the application insights so now
29:31
my i already have an application insights application i already created another one
29:39
previously. Let me delete this one so that we let's leave it now. This is the one I created previously and connected with the canvas application
29:50
So as I said, it will take 30 minutes to start logging all the operations into the application insights. But then I explained
29:59
any time, like five to ten minutes, it started doing it, but probably it's not doing everything
30:06
But I started seeing various operations logging into the application insights. So let's explore what is inside this application insights
30:15
How do I see all the usage data or performance data and a lot of other things
30:21
which I don't have privilege to see in other screens, like in the monitor screen or in the app or
30:28
are in the other screens as well. So I'm in the custom application insights screen
30:40
where on the left side, you can see a lot of features or options are there
30:46
My, there are a few things, I mean, it's hard to explain everything in this session
30:53
because a lot of things needs to be covered. So we'll go with some of the options
30:58
you can start learning on your own and i'll also point some uh resources as well so let the very
31:05
first thing under the monitoring alerts so alerts are uh right now i don't have any alerts but this
31:12
is the place where i can come and cert uh some alerts uh rules like whenever any failures happens
31:20
in the power app application i can cert and alert i can set create some alert rules here
31:27
Based on the other tools, I can send notifications or I can do I can set some actions as well
31:34
So this is very important. So instead of we wait till the user communicate back to us, some issue happened
31:43
If we really set up some alerts in the application inside, as soon as the alert happens, you can get a notification
31:50
You can set up that. Also, you can set up some actions as well
31:54
The other one is workbooks. Workbooks are like reports. Microsoft already built so many workbooks here
32:06
related to my specific application or this particular application insights. Means the data which is captured by
32:14
this monitoring service related to my Canvas application. I can use all these workbooks
32:22
For example, I would like to know what's the downtime and outages of my Canvas application
32:28
When I click on it, I can see that. And also, I can see performance ysis, new failure ysis
32:39
All these are predefined workbooks. So we don't need to build anything from scratch
32:47
we can see active users for example and also ysis of page views as well so if we click
32:55
on active users we can see all the you how many active users are there if I see I just use my
33:03
service personal account here but I launched 15 different sessions and 78 different views and also
33:11
we can see all the different screens um different screens in my canvas applications and also we can
33:20
see last 30 days of data but as i said in the ytics reports we can see up only up to 30
33:29
days but as i said we can go up to 90 days in in the report and also even some of the places i can
33:37
actually go beyond 90 days also. I will show you that as well. Going back to workbooks, we can see
33:45
other uses of calendar, uses calendar, uses by hours of the day, all these different reports
33:53
which are pre-built and it will display your data, means the usage data of your canvas application
34:01
And the next one is users How do I use it will show us all the list of users who have access to my canvas application and again there are a lot of filters here we can filter we can change the filters this is the one i was talking
34:18
about in the previous workbooks i can get up to 90 days but in the custom i can go beyond 90 days
34:25
so we can go even the calendar is given but we need to see how much data is really worth
34:34
to load into these reports based on that you can just basically start time and end time
34:39
we can filter and load that so and also different charts are there line chart bar chart and area
34:47
chart and also if we scroll down we can see more insights of the users um there are two sessions
34:56
11 events the performance is unacceptable because i try to load this app from my iphone
35:03
that's when it took a really long time that's why it is throwing as unacceptable and also
35:10
we see different three different tiny reports here per country or region how many users
35:18
per operating system as well as per browser as well um the next one is i can also see most
35:26
active users as well so the next one is I will the other very fascinating or this this feature
35:36
I really like it in the application insight is which is not available in other places is okay
35:42
now I got my app here and if I open it here every user is a different based on their need they will
35:51
access different screens in a different way like i can go to tickets hold i can create one
35:58
every user uses i mean follows their own path right uh i have not um so i would like to know
36:07
uh how many user sessions were launched and how each user session uh accessed multiple i mean
36:15
different screens what is the flow of their access of these screens I can see all of that in the
36:22
application insights under usage you can see user flows how do I see that is just click on select
36:30
event and here just select anything like the dashboard page which is the starting page and
36:38
and the time range i will change it to last 14 days because so that i can capture all my sessions
36:45
and here in the include included events i can change it to not just the events but all the page
36:53
views each screen is a page view so you can see all of that and then click on create graph it will
37:01
create the graph for you so here you can see here I got only there are 15 sessions each of them all
37:11
these started with the dashboard page and some of them nine sessions they from the dashboard page
37:18
they went to ticket details space and three of the sessions they ended right there only and three
37:26
sessions they went from dashboard page to create a new ticket page so this will really give me a
37:34
complete idea how the users are really navigating between various screens and also if you notice
37:41
the red line indicates the session ended i mean as the as a last step the red line uh the red
37:49
line represents that and also you see the blue lines uh in some places it is very thin some
37:55
places it is thick. The thickness all depends on the number of sessions. If you
38:00
see here, this is just one session and if you take the other one, this is five
38:05
sessions. If you take this one, this is nine sessions. So graphically they are
38:10
representing the more the thick the more usage is happening between those screens and also now I can see here there are few things here previous steps and the next steps so I can change the number of steps as well previous
38:26
steps as well as next steps as well what does that mean is I can navigate back and forth
38:34
the between the screens so I can see all the nine different steps so if you see this is
38:41
Step one, step two, step three. I mean, you can see the steps also
38:46
how the user navigated you can see up to nine steps. You can see how the user navigated between
38:53
even though there are only five or a few screens are there
38:56
how the user navigated between those screens. So we can clearly see like up to nine steps
39:04
Okay, I can see all of this. This is really cool. And I want to share only application insights
39:11
The global admin can come and log in into this screen and see all the data, but I would like to see this information. How I can see that one thing is you can save these reports on this user flows. You can save it and we can save these reports in either in your own reports or a shared reports
39:33
You can share in both any of any of those two places means once we share there
39:41
Let's say user flow one application inside favorite. I think it's already there. That's why let me
39:50
Let's click on creating it. Okay save as maybe two okay now the report is saved this particular report is saved now I want to share this with
40:04
some user in my team I can clear and click on ship that will send you can copy the link and
40:12
share it or click on share link via email as soon as you click your outlook or your email
40:19
client will open up and it will copy the entire link and you can just call and
40:25
send the email to whoever you want and with this link they can access they
40:31
should be able to see the report and if I just took the link and paste it in
40:37
another tab and I will see the entire report okay this is how you can see the
40:48
entire report so whatever report i saved i can just see the same thing okay this this will help
40:57
me how my users navigation path is and i can concentrate um to improve that particular path
41:06
if users are doing it uh if if users are running into it okay let's go back quickly with one other
41:14
very important thing is logs in the in the screen in the PowerPoint slide deck I explained logs is a
41:24
database where we can see the data in a rows and columns wise this is the place we can see all the
41:30
data as your like a table twice and also when I click on logs actually we let me come back and I
41:40
I will open, it will already, it will provide you some queries as well
41:45
already build some queries. So you want to see the response, the time trend
41:50
or request count trend, lot of other queries which are already pre-built
41:54
And the other thing is, if you want to know, and we can also build our own queries in this screen
42:05
because everything is stored in a database and you want to query it. So Microsoft already gave you some predefined queries
42:13
but you can also build your own queries. So to learn how to query in this place is
42:19
if you see on the screen, this is the area to where we can type our own queries
42:23
And this is all the history of the queries And if I want to learn the queries there are two ways Either take an existing query and update it or learn from typing from the scratch
42:36
So I will show you briefly how the queries looks like. So here, if I double click on it
42:43
you will see this is the trace. Traces is one of the table, I would say
42:49
and you can query the table and you can limit the entries you can see in the history i already
42:56
queried last time you can limit the number of entries in that and click run it will give you
43:05
all the tracing information that was logged from the application into the application insights
43:14
So all that information I can see here and also how to and the language that is used to write the
43:23
queries it is crystal. Let's see you can learn it from the help here on the right side you can click
43:32
on that and the language reference if you click on that you can see the languages Kusto query
43:40
language um and you can see the entire reference for the language here and the help uh it should be
43:48
pretty straightforward maybe with a little learning is required and also you can this query uh again
43:54
depends on the time range we can again change the time range up to whatever we want and also
44:00
additional uh custom that is like a no bond we can actually go back in the back in the past to
44:07
get the data as well. So this is very, very useful to query the data. Okay. Krishna, I'm sorry
44:16
will you just like to wrap maybe a little soon? Maybe a couple of minutes maybe? Yeah, sure. Okay
44:23
Thanks for that. That's okay. So we can also write our custom messages into the application insights
44:32
the one thing is if you can go to your um service uh canvas application and then
44:41
in the service application you can actually sorry it's taking a little time there i should have kept it open
44:52
yep in the service application actually i already placed you can write a few there is a formula or
45:00
function called trace using that trace function you can write the data so that
45:06
will directly go into your application insights so you if you see here this is
45:12
the trace entered by Krishna here so that's how we can write the other whether
45:16
it's information or errors are all of that and the other the final important
45:21
thing is previously I mentioned we can build our own custom reports you can
45:25
build it by using export here and export to power bi query just click on the power bi query and it
45:34
will give you the a m query entire m query here we don't need to change anything all you need to do
45:42
is open your power bi desktop and go to get data and blank query it's already mentioned in the
45:52
uh here it's already mentioned uh here right here the instruction how to get that
45:59
so all you need is just copy the entire thing and uh get to blank query i think i already opened
46:07
and go to the advanced editor and then copy your entire code and just done and your query will be
46:16
ready I think it's the credentials but my query is all done so that's how like we can get the
46:23
whole data into your Power BI and you can build your own custom reports as well
#Computers & Electronics