Steps
- Go to view custom fields in JIRA
https://<yourdomainhere>.atlassian.net/secure/admin/ViewCustomFields.jspa - Find your custom field and choose settings > Screens
- Note down the custom field name JIRA uses to store the information
- 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 ) - Choose edit Queries
- Wait for the query to load up
- On the right side under applied steps click the cog icon
- Click to select the custom field using the name that we found in the JIRA url (step 3)
- Rename the field you just added if you want it friendlier in the PowerBI report later
- Click Close & Apply. This will run the query again which might take a little while
- You new field should be available to use under the GetIssues data set under fields
