Hello, can someone help connect PowerBI to influxdb. I am trying with WEB connector from PowerBI, and i receive data for example for this command: http://localhost:8087/health but i can´t query a bucket data, can you help me? thanks

I think the only option you have is to use the WebConnector with InfluxDB API

Now, I am looking on how to write data from Power Bi to InfluxDB but a couple of months ago I wanted to query data from InfluxDB to power BI. I managed to accomplish the later thanks to the example on this post : Sharing: Example Power BI Power Query to execute Flux query - InfluxDB 2 - InfluxData …

Well @fercasjr thank you so much. This realy help me. It realy works.

I am a total beginner and do not understand the documentation. what should I do to query an Influxdb to PowerBI? I tried to set the WebConnector like this: [grafik] The connection did not work and I am not sure where to put the query. Can anybody help?

you can’t do it like that. I don’t remember exactly where but you need to create a “custom” connection using the advanced query editor. I found the mail that I sent to a college (I don’t have access to the power BI stuff but back then we were able to make it work) . To be able to execute queries …

here is an some example M-code to pull data through the Influx api using the webconnector. Open a blank query, open the advanced editor and paste this code into it. Edit the details for your connection: let // // // // inputs // // // influx_org = "<YOUR_INFLUX_ORG>" , influx_uri = "<YOUR…

thanks a lot. The script seems to work. Unfortunately there seems to be some rights issues: [grafik] using the exact same credentials Grafana is able to connect. Any ideas? edit: after reading a bit across the net there may be an issue with SSL authentification. Does Power BI need SSL?

PowerBI doesn’t support SSL. Without knowing more about your current architecture I can’t recommend any solutions. this query is still working for a local deployment. You could push your data to the cloud and access through the api there. PS: You should block out your IP address when posting.

PowerBI doesn’t support SSL Fine with me. As I am within my network Iwouldn’t use SSL. Without knowing more about your current architecture I can’t recommend any solutions I tried to describe my architecture at least for a basic understanding. What are the stats I should share? this query i…

What permissions are you using for the data source settings?

Help to connect InfluxDB with PowerBI

InfluxDB 2

Kevin_T October 26, 2023, 4:01pm 14

The token used has full read and write access

Topic		Replies	Views
Influx 1.8 data to Power BI Assistance appreciated Dashboards	1	2871	October 20, 2020
Sharing: Example Power BI Power Query to execute Flux query InfluxDB 2 flux , influxdb-cloud-2-0	4	10644	October 27, 2024
Connecting Power BI with InfluxDB V2	0	1545	July 28, 2021
Convert influxdb json to power bi table	4	3720	February 19, 2020
Influx and PowerBI Dashboards	0	1092	November 13, 2018

Help to connect InfluxDB with PowerBI

Related topics