JuryA
5/14/2019 - 2:22 PM

Loading GraphQL data (GitHub API v4) into PowerBI

Loading GraphQL data (GitHub API v4) into PowerBI

// This script shows how to use M language (Power Query Formula Language) 
// to read data from GitHub API v4 using a POST request.
// This can come in handy when building PowerBI reports that utilize GraphQL endpoints for loading data.

let
    Source = Web.Contents(
	"https://api.github.com/graphql",
	[
		Headers=[
			#"Method"="POST",
			#"Content-Type"="application/json",
			#"Authorization"="Bearer <your_personal_token_here>"
		],
    // Notice the quote escaping here
		Content=Text.ToBinary("{""query"": ""{   organization(login: \""github\"") { name  }}""}")
	]
    ),
    #"JSON" = Json.Document(Source)
in
    #"JSON"