Power BI templates for Domotz

May 12,2021 in  Engineering, How Tos
by Michael Beconcini

Learn all about Power BI templates for Domotz. Domotz Public APIs can be leveraged to create beautiful and interactive reporting dashboards on Power BI.

Power Bi Templates Network Highlights

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 include four dashboards:

 

  • Network Highlights
  • Network Inventory
  • Device Performance
  • SNMP/TCP

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 of 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:

Power Bi Templates - popup

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 

Power Bi Templates Network Highlights

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), 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:

Power Bi Templates Network Insights

Power Bi Templates Network insights 5

Remember that speed test and event history data are limited to the time period selected before the data load. 

Network Inventory

Power Bi Templates Network device Inventory

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 by time.

Device Performance

Power Bi Templates Device Performance

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 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

Power Bi Templates - SNMP TCP service monitoring

Power BI Templates SNMP service monitoring

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 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 page or template level using the “Filters” section, or you can edit or create visualization leveraging the list of fields available in the “Fields” section.

Customizing your Power Bi Templates

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 which contains the structure like a .pbix file, but without data