Forum Discussion
h4tt3n
5 years agoHelper V
GraphQL query in Power BI?
Hello, I am trying to connect to a GraphQL api through Power BI and could use some advice. In the Postman API tool I have written a working query, like this: The query is above, and par...
amirshiloh
5 years agoAdvocate II
i found a tool that is really helpful from me: "PowerBI Query Generator for GitHub GraphQL API v4" :
https://jsfiddle.net/rockyintel/1sqm7dpf/
i entered my graphQL query
and got the following Power Query M formula which works ! in my query i am using x-api-key as the key name.
this is the output from the generator tool:
let
Source = Web.Contents(
"https://myURL",
[
Headers=[
#"Method"="POST",
#"Content-Type"="application/json",
#"x-api-key"="putMyKeyHere"
],
Content=Text.ToBinary("{""query"": ""{ list{ items{ id name } } }""}")
]
),
#"JSON" = Json.Document(Source),
data = JSON[data]
in
data
- watoncarlos4 years agoNew Member
Hello, i need the same, but i am a begginner. you can explain me how to connect Graph Ql to Power BI??