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

Malingo March 20, 2024, 3:39pm 20

Hi @Anaisdg,
Do you have an update on how far you have come with the PowerBI integration? And can you already give an estimate on when we can expect this?

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	10639	October 27, 2024
Connecting Power BI with InfluxDB V2	0	1543	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