Trying to make a Power BI dashboard for Unifi Controller

This page summarizes the projects mentioned and recommended in the original post on /r/Ubiquiti
Ubiquiti Unifi Golang InfluxDB grafana-dashboard

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

  • unifi-poller

    Application: Collect ALL UniFi Controller, Site, Device & Client Data - Export to InfluxDB or Prometheus

    • First you need to get your site data. Let's assume you are using UDM Pro and you have a single site. https://github.com/unifi-poller/unifi-poller is a free tool that's loads data in influx db. influx db is a time based data but you would need relational database for your Power BI dashboard. You can use ETL tools, SSIS or Azure Data Factory to get your data from influx db and load it into SQL Server. Play with Power BI with data loaded in SQL Server.

  • unificontrol

    A high-level Python interface to the Unifi controller software

    • https://github.com/nickovs/unificontrol - I’ve used this in my own tools to connect with the UniFi REST API

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • How to collect historical PoE power usage for a port on a US 8 150W

    1 project | /r/UNIFI | 6 Dec 2023

  • Best way to view real time switchport traffic?

    1 project | /r/UNIFI | 14 Sep 2023

  • Folks who are using Unifi for routing, can you please help me understand how you are managing, handling, and debugging FW rules when Unifi does not log the necessary data?

    1 project | /r/Ubiquiti | 20 Apr 2023

  • WAN Usage For 1 Year. How accurate are the Dream Machine traffic analytics?

    1 project | /r/Ubiquiti | 14 Apr 2023

  • Gaming Lounge Suggestions

    1 project | /r/sysadmin | 19 Nov 2022