Attention all users! The ICAM team has migrated all accounts to Entra ID. All accounts require the VA network for access. More information on this migration can be found at this link: Entra ID Migration
Currently Jira only allows for 2000 records to be downloaded to Power BI. This article describe a work around this limit.
Step-by-step guide
There is a two step process, utilizing Jira and Power BI:
- Jira
- Break up your JQL into multiple JQLs that return less than 2000 records each.
- Create a Power BI connector using a JQL.
- In order to retain the sequence of the columns/fields that get returned, copy the first Power BI connector and replace the JQL with the next JQL. Rename the connector to the appropriate name.
- Power BI
- Create a Data Source connection for each of the Power BI connectors.
- Each of the Data Sources will create a table; provide a name that makes sense regarding the grouping of data.
- Combine all the tables in one table. One of the ways this can be done is using the UNION function as shown in this example:
NewTable = DISTINCT(UNION('Issues0-30','Issues30-60','Issues60-90'))
- The combined table can be used to build out the reports.
Be mindful of the frequency of refreshing data from Jira.