Power BI Domotz custom connector provides an easy way to fetch data from Domotz and create custom reports in Power BI.
Create a folder with the following path if it does not exist:
\User\Documents\Microsoft Power BI Desktop\Custom Connectors
and copy the file bin/debug/domotz.mez
in that folder.
Start Power BI Desktop and from Options -> Security -> Data Extensions
select Allow any extension to load without validation or warning
Select Get data
and you will find domotz (Beta)
extension. To complete the configuration you will need to provide
the API Endpoint and API Key (obtained from the Domotz Portal). 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.
Building the project requires Visual Studio and the Power Query SDK.
Please note that this is a beta version of the Power BI Domotz Connector which is still undergoing final testing. The connector and all content found in this repository are provided on an "as is" and "as available" basis.
Domotz Developers - Domotz API Documentation
Domotz Portal - subscribe and get an API-Key
Get Data
Configuration
API Navigator
Visualization Example