Forum Discussion
Connecting Power Bi with InfluxDB
Hello all,
i just started a project where i send data to InfluxDB. in this database are values and timestamps.
I would like to visualize them with a dashboard in Power Bi or more likely in a report.
Tested many ways via ChatGpt but never got it to work. Is it possible to visualize data from InfluxDB (Database) with Power Bi?
Thanks for taking your time.
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.
4 Replies
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.Hi kevin04102005 ,
Just wanted to check if you got a chance to review the suggestions provided and whether that helped you resolve your query?
Thank you for using Microsoft Community ForumHi kevin04102005 ,
I hope the explaination provided, has addressed your query.
Since we didnt hear back, we would be closing this thread.
If you need any assistance, feel free to reach out.
Thank you
