Power BI API - Want to query subitem (all column not only subitem name) in PowerBi

I watched this youtube and he show the query to get data from Monday.com to Powerbi
PowerBI/Monday.com M Query at 308233441ac17b72e817280753eb3bc6d6b18ddb · DataMuallem/PowerBI · GitHub

It works fine but the subitem value is come with subitemname1,subitemname2 in subitem column. but I need 1 subitem row with others subitem’s column.

Screenshot 2023-01-17 173757

What I need is 1 parent table with parent ID and 1 table for all subitems
(with parent ID)
or another alternative way.

I don’t have any query knowledge so please suggest with more detail.

Thank you in advance.

1 Like

Hi, I don’t know if you still need help, but try using this query!

(board as text) => 

	    Key = <you token>

    Source = Web.Contents("https://api.monday.com/",
        RelativePath = "v2",
            #"Authorization"= Key
            Content=Text.ToBinary("{""query"": ""{ boards(ids: "& board &") { items (limit: 25, page: 1){  id subitems{name column_values{ title text }} } } }""}")
    #"JSON" = Json.Document(Source,65001),
    data = JSON[data],
    boards = data[boards],
    boards1 = boards{0},
    items = boards1[items],
    #"Converted to Table" = Table.FromList(items, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
    #"Converted to Table"