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