Power BI API - querying subitems in Powerbi

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

Hey @rachelatmonday,

thanks! 🙂

I would like to query all columns of a subitem.

Thanks for your help!

Best
Jann

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 😀

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