Hi,
I am trying to connect PowerBI with influx DB on M language in PowerBI.
let
body = Text.ToBinary("
‘from(bucket:"“test2"”)
|> range(start: -12h)
|> filter(fn: (r) => r._measurement == ““temperature””)
|> aggregateWindow(every: 1h, fn: mean)’
“),
url = “http://20.xx.xx.xx:8086”,
options = [
Headers = [
Authorization=” Token pcSpeRixxxxxxxxxxxxxxxxxxxxxxxxxxpN1QQ2oQTuQ==",
Accept=“application/json”,
Content=“application/json”],
RelativePath=“api/v2/query”,
Query=[org=“xxxxx”],
Content=body
],
result = Web.Contents(url, options)
in
result
but it shows this error:
Web.Contents with the Content option is only supported when connecting anonymously.
Any feedback on this? How can I connect PowerBI to query data from InfluxDB?
