Monday.com Data Integration into Power BI and Power BI Service- Part 2

Here is the M query template for integrating monday.com data with Power BI and Power BI Service.

.

let

    Source = Web.Contents("https://api.monday.com/" & "v2",

    [

        Headers=[

            #"Method"="POST",

            #"Content-Type"="application/json",

            #"Authorization"="Bearer abcdefghijklmnopqrstuvwxyz"

            ],

            Content=Text.ToBinary("{""query"": ""{ boards(ids: [12345]) { name items_page { cursor items { name column_values { column { title type } ... on BoardRelationValue { linked_items { id name } } text } } } groups { title id } } }""}")

            ]

    ),

    #"JSON" = Json.Document(Source,65001),

    data = JSON[data]

in

	data

Monday.com Documentation: https://developer.monday.com/api-reference/docs/basics

This tutorial is a one-stop solution for all the issues faced in part 1 of the monday.com data integration in Power BI and Power BI Service.