Monday 14 August 2017

Adding JIRA Custom Fields into Power BI report

Steps

  1. Go to view custom fields in JIRA
    https://<yourdomainhere>.atlassian.net/secure/admin/ViewCustomFields.jspa
  2. Find your custom field and choose settings > Screens
  3. Note down the custom field name JIRA uses to store the information
  4. Open PowerBI desktop and open the JIRA project
    (If you dont have a JIRA project to start with you can get one from here which is a good start https://onedrive.live.com/?authkey=%21AH4_6OHXy6siE74&cid=E7E2C1CD5556023F&id=E7E2C1CD5556023F%21116639&parId=E7E2C1CD5556023F%21116638&action=locate )
  5. Choose edit Queries
  6. Wait for the query to load up
  7. On the right side under applied steps click the cog icon
  8. Click to select the custom field using the name that we found in the JIRA url (step 3)
  9. Rename the field you just added if you want it friendlier in the PowerBI report later


  10. Click Close & Apply. This will run the query again which might take a little while
  11. You new field should be available to use under the GetIssues data set under fields

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete