Power BI API - querying subitems in Powerbi

monday Apps & Developers
, , ,
1

Hey,
I have only been using Powerbi for a short time. The query to get data from Montag.com to Powerbi works, but I don’t know how to query subelements. I have tried a lot and read many articles here in the forum, but I can’t find a solution.

As I am very new to the subject, a detailed description would be helpful.

Thank you very much!

2

Hi @jalusu,

Welcome to the community!

Just as a head’s up - I am moving your post from the feature requests to the questions category so it gets to the right queue.

What subelements are you trying to query?

Best,
Rachel

3

Hey @rachelatmonday,

thanks! :slight_smile:

I would like to query all columns of a subitem.

Thanks for your help!

Best
Jann

4

Hello there @jalusu,

Regarding the GraphQL query generally speaking, can use something like this:

{
  items(ids: SUBITEMIDHERE) {
    name
    id
    column_values {
      text
      value
      column {
        id
        title
      }
    }
  }
}

Take into account that specific column types might require specific syntax’s. You can check them out here :smile:

You can also get it all together from the main item like this:

{
  items(ids: MAINITEMIDHERE) {
    subitems {
      id
      name
      column_values {
        text
        value
        column {
          id
          title
        }
      }
    }
  }
}

I do not have experience with PowerBI particularly but this is how the query can look like GraphQL-wise.

I hope that helps!

Cheers,
Matias