Dashboard performance issues and Creating a dashboard with dynamic target source dropdown list

%3CLINGO-SUB%20id%3D%22lingo-sub-214939%22%20slang%3D%22en-US%22%3EDashboard%20performance%20issues%20and%20Creating%20a%20dashboard%20with%20dynamic%20target%20source%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-214939%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3ETwo%20issues%20that%20I%20am%20dealing%20with%20application%20insights%3A%3C%2FP%3E%3CP%3E1.%20%3CU%3EDashboard%20performance%3C%2FU%3E%20-%20It%20takes%20a%20long%20time%20to%20load%20all%20the%26nbsp%3Bcharts%20even%20when%20the%20queries%20are%20very%20simple.%20for%20example%20a%20simple%20query%20like%3A%3C%2FP%3E%3CPRE%3Elet%26nbsp%3Bids%20%3D%20customMetrics%20%7C%20where%20name%20%3D%3D%20'my_metric_name'%20%7C%20project%20customDimensions.id%3B%3CBR%20%2F%3E%3CBR%20%2F%3EcustomMetrics%20%7C%20where%20name%20%3D%3D%20'another_metric_name'%20and%20customDimensions.id%20in%20(ids)%3C%2FPRE%3E%3CP%3Ewithout%20much%20data%20loaded%2C%20can%20take%20about%2030%20seconds.%3C%2FP%3E%3CP%3EMaybe%20I%20am%20doing%20something%26nbsp%3Bwrong%3F%20is%20there%20maybe%20a%20way%20to%20index%20my%20customDimensions%20properties%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20%3CU%3EDynamic%20target%20resource%3C%2FU%3E%20-%20I%20have%20many%20target%20resources%20with%20the%20same%20metrics%20data%20structures%2C%20and%20I%20want%20to%20create%20one%20dashboard%20with%20many%20charts%2C%20that%20will%20be%20updated%20automatically%20by%20the%20given%20target%26nbsp%3Bresource%20-%20that%20can%20be%20changed%26nbsp%3Bfrom%20something%20like%20a%26nbsp%3Bdrop%20down%20list%20with%20all%20the%20target%20resources.%3C%2FP%3E%3CP%3ERight%20now%20I%20have%20the%20same%20dashboard%20for%20each%20target%20resource.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3CP%3EElad.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-214939%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E%5E%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EApplication%20Insights%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECustom%20Logs%20and%20Custom%20Fields%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%20Language%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EView%20Designer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-215087%22%20slang%3D%22en-US%22%3ERe%3A%20Dashboard%20performance%20issues%20and%20Creating%20a%20dashboard%20with%20dynamic%20target%20source%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215087%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Elad%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.%20To%20isolate%20the%20query%20runtime%20vs%20general%20dashboard%20load%20times%2C%20can%20you%20please%20wait%20for%20the%20dashboard%20to%20fully%20load%2C%20then%20press%20the%20%22refresh%22%20button%20in%20the%20upper-right%20corner%20of%20the%20chart%20that%20took%20a%20while%2C%20and%20compare%20how%20long%20it%20takes%20for%20the%20data%20to%20come%20back%20vs%20how%20long%20the%20query%20takes%20to%20run%20in%20the%20Analytics%20portal%3F%3C%2FP%3E%0A%3CP%3E2.%20This%20is%20not%20today%20possible%20through%20the%20UI%2C%20though%20something%20we'd%20like%20to%20offer%20in%20the%20future%2C%20together%20with%20other%20filtering%20capabilities.%20In%20the%20meanwhile%2C%20if%20you%20share%20your%20dashboard%20(even%20if%20just%20with%20yourself)%2C%20it'll%20become%20an%20ARM%20resource%2C%20backed%20by%20a%20JSON%20template.%20You%20can%20download%20this%20JSON%20template%2C%20modify%20the%20target%20resource%2C%20and%20re-upload%20it%20for%20having%20a%20dashboard%20with%20a%20different%20target.%20I%20know%20this%20is%20a%20lot%20more%20cumbersome%20and%20doesn't%20entirely%20meet%20your%20request%2C%20but%20this%20could%20be%20a%20good%20workaround%20until%20we%20have%20the%20full%20feature%20implemented.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

Two issues that I am dealing with application insights:

1. Dashboard performance - It takes a long time to load all the charts even when the queries are very simple. for example a simple query like:

let ids = customMetrics | where name == 'my_metric_name' | project customDimensions.id;

customMetrics | where name == 'another_metric_name' and customDimensions.id in (ids)

without much data loaded, can take about 30 seconds.

Maybe I am doing something wrong? is there maybe a way to index my customDimensions properties? 

 

2. Dynamic target resource - I have many target resources with the same metrics data structures, and I want to create one dashboard with many charts, that will be updated automatically by the given target resource - that can be changed from something like a drop down list with all the target resources.

Right now I have the same dashboard for each target resource.

 

Thanks in advance,

Elad.

1 Reply

Hi Elad,

 

1. To isolate the query runtime vs general dashboard load times, can you please wait for the dashboard to fully load, then press the "refresh" button in the upper-right corner of the chart that took a while, and compare how long it takes for the data to come back vs how long the query takes to run in the Analytics portal?

2. This is not today possible through the UI, though something we'd like to offer in the future, together with other filtering capabilities. In the meanwhile, if you share your dashboard (even if just with yourself), it'll become an ARM resource, backed by a JSON template. You can download this JSON template, modify the target resource, and re-upload it for having a dashboard with a different target. I know this is a lot more cumbersome and doesn't entirely meet your request, but this could be a good workaround until we have the full feature implemented.