Power BI API and Domotz – How to create custom network reports and analytics 

January 22,2021 in  Engineering
by Andrea Azzarà

This tutorial will cover how you can create beautiful custom reports and analytics in Power BI Desktop using the Domotz custom connector.  Learn how to use the Power BI API and Domotz network monitoring system to create custom reports on speed tests, RTD information, SNMP sensor charts, network and device status and more. 

Power BI API network device history and speed test reports

This tutorial will cover how you can create beautiful custom reports and analytics in Power BI Desktop using the Domotz custom connector.  Learn how to use the Power BI API and Domotz network monitoring system to create custom reports on speed tests, RTD information, SNMP sensor charts, network and device status and more. 

Introduction to using the Power BI API and the Domotz connector

Power BI is a business analytics tool by Microsoft. It helps access data from hundreds of sources (Dynamics 365, Salesforce, Azure SQL DB, Excel, SharePoint and more). With Power BI you can transform and clean the data into a data model and create charts or graphs to provide visuals of the data. 

Power BI integrates seamlessly with existing applications so that organizations can create personalized dashboards starting from data aggregated through different sources. The technical skills required to create dashboards and reports on those data, including the data coming from the Domotz platform are minimal: no specialized technical support is required. On the other hand, a powerful natural language interface and the use of intuitive graphical designer tool make the platform very easy to be used.

In this way, practically anyone in the organization can easily create and securely publish business related reports to the rest of the organization. Starting from today, these reports can also include data coming from the Domotz platform.

The Domotz custom connector allows you to gather data from the Domotz public API and create visually rich reports. 

Download the Domotz connector to get started with Power BI and Domotz.

What kind of reports can you create using the API?

Basically everything that can be obtained through the Domotz Public API can be included in a Power BI. 

This means reports can include speed tests, round trip delay information and SNMP sensors charts. You can also create reports on the status of networks and devices over time. For instance you could create a timeline of up/down events for the network.

How to install the Domotz connecter for Power BI 

First you need to enable support for custom connectors. Create a folder with the following path (if it does not exist): \User\Documents\Microsoft Power BI Desktop\Custom Connectors and copy the file domotz.mez there.

Start Power BI Desktop and from Options → Security → Data Extensions select Allow any extension to load without validation or warning.

Then when you select Get data you will find the domotz (Beta) extension. 

Power BI API - Create custom network reports

To complete the configuration you will need to provide the API Endpoint and API Key (obtained from the Domotz Portal, under Settings -> API Keys).

Power BI API getting the API keys

When the configuration is complete you will have access to a subset of (read-only) endpoints of the Domotz Public API. Keep in mind that some data might require some transformation (expanding nested objects, data conversion) before being usable from Power BI visualization tools.

Power BI API - navigator

In the following image you can see a visualization example of data obtained from the Public API. The example includes the agents list (on a map) with their status, and two charts for network speed and device round trip delay.

Power BI API network device history and speed test reports

In this tutorial, we’ve covered how to install and use the Domotz Custom Connector for the Power BI API. 

With little effort you can create beautiful custom reports and analytics based on the data Domotz collects for you. 

Further reading: