Auvik Power BI Templates have been updated to v2.0 to improve reporting accuracy and improve report load performance—especially for larger tenants and longer reporting periods. Version 1.6 used a single template; version 2.0 introduces two variants, each optimized for a different use case:
- Auvik Power BI Template 2.0 (Full)
- Auvik Power BI Template 2.0 (Performance)
Download the Auvik PowerBI templates from GitHub
Below outlines the changes separately for the Full and Performance templates:
Let’s begin with changes for the ‘Full’ template.
- Auvik Power BI Template 2.0 (Full)
(a) Data availability changes
The Auvik API provides Device Performance and Device Availability stats for any device it captures data for, including non Auvik-Managed devices.
To better reflect the intent of the report and optimize data download times, we now limit all of Device Stats data download to the following device types:
- Firewalls
- Routers
- Controllers
- Switches and L3 Switches
- Stacks
This applies to the following data sources:
Device Performance stats: Bandwidth, CPU, Memory, Storage, Packet Loss, etc.
Device Availability stats: Uptime, Outage.
(b) Alert count definition changes
We’ve updated alert metrics to include alerts without a DeviceID attached to it, such as Collector alerts. This means alert counts in PowerBI now accurately reflect the Auvik UI.
These new alert count definition has been implemented in the following KPIs:
-
QBR Dashboard
- Total Alerts Evolution
- Alerts Created Vs Resolved
- Alerts by Severity
- Resolved Alerts
- Inventory Management (no changes)
-
Service Report
- Alerts Created
- Alerts Resolved
- Alerts by Site
- Total Alerts Evolution
- Number of alerts by severity
- Device Performance (no changes)
We’ve also removed the ‘paused’ and ‘unpaused’ alert statuses from metrics as they’re more operational, and are meant for the Auvik UI only.
(c) Business metric changes
Average Network Uptime (%)
Now calculated using only Auvik-managed network devices (firewalls, routers, switches, L3 switches, stacks, controllers). This avoids skew from averaging all devices equally and accounts for redundancy by using the best-available device per critical type.
- Business definition: Average % of time a site is “up” for the period, using the most-available device in each critical type, and the least-available type overall.
- Technical definition: For each site-hour: take the max hourly uptime per device type → then the min across types → average over the report period.
Site Downtime Minutes (Minutes)
Now calculated using only Auvik-managed network devices (firewalls, routers, switches, L3 switches, stacks, controllers). This prevents inflated downtime from summing outages across many devices and accounts for redundancy within device types.
- Business definition: Total minutes a site is “down” for the period, based on the least-healthy critical device type, accounting for redundancy within each type.
- Technical definition: For each site-hour: take each device type’s minimum outage seconds across its devices, then take the maximum across device types, sum across the entire report period, and convert to minutes.
Note: Downtime is now shown in minutes (instead of seconds) for better business readability.
(d) UI and visual updates
Filter selection
We’ve made the report filters wider, now taking all of the available top space, so that when you’ve selected a site or a device with a longer name, it’s more clearly visible.
KPI colors
We’ve updated the color scheme, particularly for alerts, so that it’s more aligned with Auvik UI.
Now, let’s look into changes for the ‘Performance’ template.
-
Auvik Power BI Template 2.0 (Performance)
(a) Data availability changes
We’ve removed all Device Performance statistics, including:
- Device Bandwidth usage
- Device Memory (RAM) usage
- Device Storage usage
- Device CPU usage
- Packet Broadcast, Multicast, Unicast
And same way that the full 2.0 report, Device Availability Statistics are limited to Auvik-billable network devices. See list above..
(b) UI and visual updates
(i) QBR Tab
No changes
(ii) Inventory Management Tab
The following KPIs have been removed:
- Device bandwidth usage
- Peak CPU usage
- Peak RAM usage
- Peak Storage usage
They have been replaced by:
- Device Downtime (in minutes)
- Device Uptime (%)
(iii) Service Report Tab
The following KPI has been removed:
- Device bandwidth usage
It has been replaced with additional room for the previously existing metrics:
- Alerts by device type
- Devices with most alerts
- Resolved Alerts description
(iv) Device Performance tab
The Device Performance report tab has been completely removed, as it was built on all of the metrics that have been removed.