Loading GraphQL data (monday.com API v2) into PowerBI

monday-GraphQL-PowerBI.m

// Playing around with a PowerBI query to pull data from monday.com into PowerBI
// This can come in handy when building PowerBI reports that utilize GraphQL endpoints for loading data.

let
    Source = Web.Contents(
	"https://api.monday.com/v2",
	[
		Headers=[
			#"Method"="POST",
			#"Content-Type"="application/json",
			#"Authorization"="<your_personal_token_here>"
		],
    // Notice the quote escaping here
		Content=Text.ToBinary("{""query"": ""{ boards (ids: <your board ID here>) { items { name id column_values (ids:["<your column id here>"] { id title value } } } }""}")
	]
    ),
    #"JSON" = Json.Document(Source)
in
    #"JSON"