I need to connect to the Solarwinds API with PowerBI. I'm not a SW admin in any way. I'm just tasked with getting some reporting data from it.
I can successfully make calls to the SolarWinds/InformationService/v3/Json/Query endpoint from Postman with no problems.
When I make the same call from within a query in PowerBI I'm getting an error.
The call is baked into the query
= let
body = "{
""query"": ""SELECT m.Name, m.EntityDisplayName, m.Status, m.ContainerID FROM Orion.ContainerMemberSnapshots m WHERE m.ContainerID=190""
}",
Data= Web.Contents(""="application/json">server.domain.com:17778/.../Query",[Content=Text.ToBinary(body),Headers=[", #"AUTHORIZATION"="Basic xxxxx="]]),
DataRecord = Json.Document(Data),
Source=DataRecord
in
Source
Any assistance would be greatly appreciated.
