Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Realtime, or near realtime, server telemetry dashboards

I connected PowerBI to Application Insights using the available Application Insights service available in PowerBI.  This works great to view web page related dashboards.  However, I also want to create dashboards using performance counters to report on CPU usage, as an example.


I turned my focus to continous export and stream analytics.  I was able to get this POC to work, however I cannot figure out how to build a query that will pass through the performancecounter[0].percentage_processor_total.value.  It pukes on the [0] part. 

The end result here is to provide to the customer a realtime dashboard of user activity and server performance. 


I can envision a gauge showing cpu utilization on a dashboard.

Helper II
Helper II

Re: Realtime, or near realtime, server telemetry dashboards

I now have data pushing into PowerBI, however I still need to figure out how to manipulate the data.  The utilization stats are all in 0.0####### format.  I need to figure out how to create a cpu utilization gauge.  Ideas how to do this?

Helper II
Helper II

Re: Realtime, or near realtime, server telemetry dashboards

    flat.arrayvalue.categoryName as categoryName,
    flat.arrayvalue.instanceName as instanceName,
    e.context.location.continent as continent, as country,
    e.context.location.clientip as clientIP,
    e.context.location.province as province, as city, as eventTime,
    flat.arrayvalue.available_bytes.value as availableBytes,
    flat.arrayvalue.percentage_processor_total.value as percentageProcessorTotal,
    flat.arrayvalue.request_execution_time.value as requestExecutionTime,
    flat.arrayvalue.process_private_bytes.value as processPrivateBytes,
    flat.arrayvalue.io_data_bytes_per_sec.value as ioDataBytesPerSec,
    flat.arrayvalue.percentage_processor_time.value as percentageProcessorTime,
    flat.arrayvalue.requests_per_sec.value as requestsPerSec,
    flat.arrayvalue.number_of_exceps_thrown_per_sec.value as numberOfExcepsThrownPerSec
    input AS e
CROSS APPLY GetElements(e.performanceCounter) as flat

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!