Forum Discussion
Connecting Power Bi with InfluxDB
Hello !
There’s no native Power BI connector for InfluxDB.
In PQ, you can call the InfluxDB API where you post a Flux query to /api/v2/query and parse the CSV in PBI. https://community.influxdata.com/t/sharing-example-power-bi-power-query-to-execute-flux-query/11200
InfluxDB 3 exposes an Apache Arrow Flight SQL endpoint with ODBC/JDBC drivers. You need to install the Flight SQL ODBC driver, create a DSN, then use PBI ODBC but you will be able only to use the import https://docs.influxdata.com/influxdb3/core/tags/flight-sql/
CData has a paid connector that you can try it maybe.
Hello !
There’s no native Power BI connector for InfluxDB.
In PQ, you can call the InfluxDB API where you post a Flux query to /api/v2/query and parse the CSV in PBI. https://community.influxdata.com/t/sharing-example-power-bi-power-query-to-execute-flux-query/11200
InfluxDB 3 exposes an Apache Arrow Flight SQL endpoint with ODBC/JDBC drivers. You need to install the Flight SQL ODBC driver, create a DSN, then use PBI ODBC but you will be able only to use the import https://docs.influxdata.com/influxdb3/core/tags/flight-sql/
CData has a paid connector that you can try it maybe.