Forum Discussion
Connecting Power Bi with InfluxDB
- 11 months ago
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.
Hi kevin04102005 ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions, please feel free to reach out.We would be happy to help with any further assistance you may need.
Thank you AmiraBedh for your inputs to the query.