Convert influxdb json to power bi table

[Anaisdg]

Hello @LochanaMendis,
Welcome perhaps this thread or community user can provide you with additional help:

Sharing: Example Power BI Power Query to execute Flux query

(So many uses of “power” and “query” follow… for great justice) We currently use Influx OSS and InfluxCloud v1. Grafana, Chronograf, and Power BI are the main applications we run against InfluxDB. We’re preparing for an eventual transition to InfluxDB v2. One piece of the migration is updating our Power BI reports to use the InfluxDB v2 API. Unfortunately, Microsoft still does not offer native support for InfluxDB in their Power BI tool. So, raw Power Query code is necessary to submit queries …