Forum Discussion

h4tt3n's avatar
h4tt3n
Helper V
5 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

For me the following code works: 

Source = Web.Contents(
"http://localhost/HOPEXGraphQL/api/ITPM",
[
Headers=[
#"Method"="POST",
#"Content-Type"="application/json",
#"Authorization"="Bearer " & gottoken,
#"X-Hopex-Context" = "{""EnvironmentId"":""M6LC(Gp3VzSP"",""RepositoryId"":""ihd7)1IVRXR9"",""ProfileId"":""757wuc(SGjpJ""}"
],
// Notice the quote escaping here
Content=Text.ToBinary("{""query"":""query{ application{ id name applicationType businessProcess{ id name} applicationOwner_PersonSystem{ id name } sentApplicationFlow_ApplicationParticipant{ id name } receivedApplicationFlow_ApplicationParticipant{ id name }} }""}")
]
),
#"JSON" = Json.Document(Source),
data = JSON[data]

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello,

    Would like to ask if you are still using Power BI and GraphQL? Does it still work after 2 years with the new verision of Hopex V5. We are trying to do the same thing that you are doing and coincidentally we are using Hopex GraphQL as well. Still did not manage to make it work. Would really appreciate it if you would send the code you are using to connect them.

    Thank you!