Learn all about Power Bi templates for Domotz.
Our first blog post on this topic explained how to connect Power Bi with Domotz to create your own reports.
To help you get started with Power Bi templates and Domotz, we have also created an out-of-the-box Power BI template, which includes four dashboards:
- Network Highlights
- Network Inventory
- Device Performance
The Domotz Power Bi template is accessible open source here.
It is designed to help you get some insights about your monitored networks but can also be customized to meet your reporting needs.
Run Domotz Power BI templates
You can run the Domotz Power BI templates on your computer or a server through the Power BI Desktop app or through Power BI Pro. Please, be sure to run a version of Power BI by February 2021 or later.
Before opening the template, make sure that you have installed the Domotz connector and configured the Domotz API endpoint and key as described in Power BI API – Create custom network and device reports.
When opening the template, a popup message will ask the time interval of the historical data to be retrieved:
You can simply click the “Load” button leaving empty the form and the historical data of the last 7 days will be retrieved. Otherwise, when specifying the time interval, please take care of respecting the following limits:
- size of the time interval at most of 30 days
- “Date From” not before 2 months ago
The date format to use is “MM/DD/YYYY” or “DD/MM/YYYY” depending on the settings of the system used.
The import and processing of the data should now start and you will see the following screen:
Load time (as well API consumption) depends on the number of agents and sensors.
Domotz Power BI template contents
Domotz Power BI template reports data about your Domotz Agents and their different levels of hierarchy in separate dashboards.
Each dashboard contains reports and filters which are interactive: you can act on the filter or click a specific item in a report to filter all the reports in the dashboard.
Network Highlights reports data about your Agents: their current status and location, their downtime during the selected period, the average speed test of their networks (AGENT SPEED TEST), and the events registered (AGENT EVENT HISTORY).
In AGENT DOWNTIME, AGENT SPEED TEST, and AGENT EVENT HISTORY if you right-click on one agent data, you can drill down by time to visualize the downtime events or the historical trend:
Remember that speed test and event history data are limited to the time period selected before the data load.
In Network Inventory you see the composition of your networks by device vendor (COUNT BY VENDOR), model (COUNT BY MODEL), and type (COUNT BY TYPE) distinguished by importance (VITAL or FLOATING).
It is also reported how many devices were discovered over time (DEVICE FIRST DISCOVERY) with the possibility to drill down over time.
Device Performance may help you in finding which of your devices is slow in terms of RTD (RTD AVERAGE MEDIAN) and which one has lost the most packets in the latest transmission (LATEST LOST PACKET PERCENTAGE). It also reports the downtime of important devices.
If you want to troubleshoot your device in Domotz WebApp, you can click on the Device filed in the table and it will link you to its page.
SNMP/TCP reports data retrieved from your sensors. The latest values are reported in the tables, while in the chart you see the historical data over time of the numeric value type SNMP sensors.
A useful way to visualize data about your sensors is to filter in turn for a set of the same type you are interested in. Remember that you can also use the table as a filter by clicking over the sensor’s rows of your interest.
Customizing your Power BI templates
As every Power BI template, even the Domotz one can be customized and adapted to better fit your needs.
You can set a global filter at the page or template level using the “Filters” section, or you can edit or create a visualization leveraging the list of fields available in the “Fields” section.
For example, you may want to add/remove some fields from the tabular views of the Domotz template or create a chart view containing only a certain set of sensors (e.g., all the printer supply levels).
When you have finished your customization you can save it as a .pbit or .pbix file:
- .pbix is a file that contains the structure (data sources, data manipulations, the data model, reports) along with the actual data
- .pbit is a template file that contains the structure like a .pbix file, but without data