Jira data in Power BI

Often, project or work related data exists in Jira and there is value in reporting/visualizing it in Power BI. Perhaps the reporting capabilities within Jira are not sufficient, there is value in extracting it to use in Power BI, or there is desire to combine the data from Jira with other data sources. The are commercial Jira plugins available for Power BI, but I’m going to roll our own. For this technique, you’ll need basic understanding of JIRA, JQL, Power

Read more

JIRA API Archeology and Zombies. Guidance for perplexed developers

Samples of API JIRA Nuances and Gotchas The JIRA REST API is a great tool for synchronizing data into downstream systems but is not without Zombies, Land Minds, and other gotchas. Sources of Zombie data in downstream systems Deletes and Archives will not be communicated through the REST APIs. Moving an issue from one to another Changing the issuetype of an issue Moving the issue to another project with a different issue type Possible solutions Use webhooks and stream all

Read more

JIRA Game – Show Me Your Unit Tests

Here’s a fun little game you can play with JIRA, Git, and Feature Branches. Ideally, each Agile team should be creating unit tests for each story… but are they? Well, let’s make it fun!  Let’s make a game-show where a team and one of there stories is selected at random. Next we look at the commits on the JIRA (linked to revision control by the JIRA #), do the changes have unit tests on them?   package showMeYourUnitTest import groovy.json.JsonSlurper

Read more