How to retrieve data from InfluxDB to Power BI with "Blank Query".

[Anonymous]

I have tried to connect data source from InfluxDB to Power BI using InfluxDB API.
(https://docs.influxdata.com/influxdb/v1.8/tools/api/#query-http-endpoint)
InfluxDB Version is v1.8.

But I couldn't connect to the data.
I also tried to connect by using M language. Do you know correct code to connect the InfluxDB data source with Power Query?

or Do I have to connect with OData? Anyway, I don't want to use OData because end users need to install Python or Pylet in their local machine.

(https://github.com/Synergetic-Engineering/odata-influxdb)

When I tried to connect, got error message as follows

DataSource.Error: Web.Contents failed to get contents from "http://<IP Address>:8086/query" (400): Bad Request
Datails:
DataSourceKind=web
DataSourcePath=http://<IP Address>:8086/query
Url=http://<IP Address>:8086/query

This is my M language code:

= let
    url = "http://<IP Address>:8086/query",
    Source = Json.Document(Web.Contents(url,[
        Headers = [#"Content-Type" = "application/vnd.flux",
        #"Authorization" = "Token <userID>:<Password>",
        db="<DB_Name>",
        q="SELECT * FROM <Measurement_Name>"
            ]

        ]
))
in
#"Source"

Thank you for your help in advance.

Best regards,
ak

[V-pazhen-msft · Accepted solution]

@Anonymous 
I was also think you can try using the web connector querying the influxdb api, seems not working.

With my research, I found power bi currently do not support connection with InfluxDB as refer to the Idea: Microsoft Idea · Open PowerBI to InfluxDB Databases. I can you should vote that idea hope power bi brings the feature ASAP.

Something might help: InfluxDB via REST API JSON - Microsoft Power BI Community

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.