Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
SELECT
flat.arrayvalue.categoryName as categoryName,
flat.arrayvalue.instanceName as instanceName,
e.context.location.continent as continent,
e.context.location.country as country,
e.context.location.clientip as clientIP,
e.context.location.province as province,
e.context.location.city as city,
e.context.data.eventTime 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
INTO
output
FROM
input AS e
CROSS APPLY GetElements(e.performanceCounter) as flat
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |