Power BI as dashboard and Power Pivots for Home assistant

Configuration Frontend
1

I have seen people using InfluxDB and Grafana with Home Assistant. I am not familiar with that

Power BI desktop is a free enterprise class tool. I managed to sync my HA default DB (Hass.IO) in RP3 with Power BI

“You need to install a SQLite ODBC driver (look here: http://www.ch-werner.de/sqliteodbc) on your local machine. Then “Get Data” - “ODBC” and enter “database=C:\mysqlite.db” as connection string. This works at least for the PowerBI Desktop”

Power BI can set auto sync of database.

I use State table to analyse and troubleshoot in Excel via Power Pivot and

I am still learing Power BI and it has very good visualization via graphs etc

Is anyone using PowerBI with Home Assistant rather than Grafana?

Most of the people with data science background would be familiar with PowerBI

2 Likes
2

Power BI is a business analytics service provided by Microsoft.

Blech.

3

Very interesting. Can you provide some more information on how you got this working?

Thanks!

4

Glad to see others making this connection. I too am very familiar with PowerBI and wanted to work with my HA data in there. I used a different approach though:

I used the Recorder integration to load data into an MSSQL DB . (this is well documented at https://www.home-assistant.io/integrations/recorder/#ms-sql-server), from there you are able to visualize through PowerBI or an sort of visualization tool that works with MSSQL.