Sprint Changes in PowerBI

[Steve Tedeschi]

Appreciate some help / guidance on using a Jira and Power BI integration to build sprint reports for multiple dev teams. The OOTB Jira Sprint Reports show issues added / removed in a sprint, points committed v delivered, etc. for a given sprint (dev team).

I am trying build a report showing the following across multiple sprints (i.e., dev teams sprinting on the same schedule)

1. Number of issues added in a sprint
2. Number of issues removed from a sprint
3. Story points committed
4. Story points completed

I am able to reconcile the Sprint table with end of sprint data. Looking for a way to find changes within the sprint.

Thanks in advance!

Steve

[Mercy]

Power BI will only show sprint “snapshot” data from Jira’s database or REST API, not the historical changes that occur during a sprint. Jira doesn’t store sprint membership deltas in a dedicated table, so to report on issues added or removed mid-sprint you need to query the issue change history. In Jira Data Center, that data lives in the `changegroup` and `changeitem` tables, where field = `Sprint` indicates when an issue was added or removed. Joining those tables with the `jiraissue` and `AO_60DB71_SPRINT` tables lets you calculate how many issues entered or left each sprint and when.
If you prefer to use the REST API instead of direct SQL, the `/rest/api/2/issue/{issueKey}?