suriyapong
(suriyapong)
1
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.

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.
Max
1 Like
leorocha
(leo motta rocha)
2
Hi, I don’t know if you still need help, but try using this query!
(board as text) =>
let
Key = <you token>
Source = Web.Contents("https://api.monday.com/",
[
RelativePath = "v2",
Headers=[
#"Method"="POST",
#"Content-Type"="application/json",
#"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)
in
#"Converted to Table"