Power BI Connector for Jira

Build 26.0.9770

BoardConfiguration

Displays the configuration settings of agile boards, including filters, estimation type, and card layout.

View-Specific Information

SELECT

The connector uses the Jira API to process filters based on the BoardId column. The connector processes all other filters client-side.

You must specify a BoardId to retrieve results.

For example, the following queries are processed server-side:

SELECT * FROM BoardConfiguration WHERE BoardId = 10022;

Columns

Name Type References SupportedOperators Platform Description
BoardId [KEY] Integer Boards.Id = The unique identifier of the board whose configuration is being returned. This value is used to query specific boards.
ColumnConfig String The configuration settings for the columns displayed on the board. Includes the order of columns, mapped issue statuses, and any applied constraints such as minimum or maximum issue counts. Constraint types include: 'none', 'issueCount', and 'issueCountExclSubs' (excluding subtasks).
Filter String A reference to the saved filter associated with the board, which determines the set of issues shown.
Name String The name assigned to the board, typically defined by users to describe the board's purpose or project.
CustomFieldIdRank Integer The internal ID of the custom field used for issue ranking within the board. This is often used to control issue order in backlog and active sprints.
Self String The URL that links to the board resource in the Jira API. This is useful for programmatic access or navigation.
SubQuery String A Jira Query Language (JQL) subquery used by the board to further refine the issue set beyond the main filter.
Type String The type of board, such as 'scrum' or 'kanban', which determines how issues are displayed and managed.
EstimationDisplayName String The human-readable name of the field used for issue estimation, such as 'Story Points' or 'Original Estimate'.
EstimationFieldId String The ID of the field used to provide estimates on the board. This links to a specific custom or system field.
EstimationType String Indicates the method of estimation used for the board. Accepted values include: 'none' (no estimation), 'issueCount' (based on issue count), or 'field' (based on a specific custom field such as story points).

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770