Please help to convert json output from rest query from Influxdb to table in power bi

Hi @Giovanni_Luisotto , My json structure is as follows { “results”: [ { “statement_id”: 0, “series”: [ { “name”: “Electrical”, “tags”: { “resource_name”: “MainActivePowerTotal” }, “columns”: [ “time”, “mean” ], “values”: [ [ “2020-02-17T06:10:00Z”, null ], [ “2020-02-17T06:20:0…

Hello @LochanaMendis , Welcome :slight_smile: perhaps this thread or community user can provide you with additional help: [image] Sharing: Example Power BI Power Query to execute Flux query InfluxDB 2 (So many uses of “power” and “query” follow… for great justice) We curr…

I’ve found a way to read those data in a decent way, without using custom M code Please note that the json you pasted is not a valid json (at least to me) since it does not use the standard double quotes ("). Anyway I saved it to a flie and loaded it, below the code let Source = Json.Document(…

Convert influxdb json to power bi table

Giovanni_Luisotto February 17, 2020, 11:01pm 2

In order to help you I need at least the Json structure…
Also, which is the exact problem on the PowerBI/InfluxDB side?

Topic		Replies	Views
Sharing: Example Power BI Power Query to execute Flux query InfluxDB 2 flux , influxdb-cloud-2-0	4	10635	October 27, 2024
Parse JSON from Flux Query InfluxDB 2 flux , json	11	3432	October 21, 2022
Help to connect InfluxDB with PowerBI InfluxDB 2 influxdb , flux	22	10831	February 5, 2025
Influx 1.8 data to Power BI Assistance appreciated Dashboards	1	2867	October 20, 2020
Problem with pivot() in specifying rows and coloums InfluxDB 2	13	120	September 21, 2025

Convert influxdb json to power bi table

Related topics