Assistance with JIRA Data Integration into Power BI

john.basha

 

 

Hi Team,

I’m trying to understand the current setup of our JIRA instance: https://jira.mysitename.com/.

I previously worked on fetching JIRA data into Power BI about five years ago, and it was functioning well at that time. However, it seems like some changes have been made recently, and this URL appears to be different.

I need assistance with the following:

1. Understanding the current JIRA setup and any changes that might have occurred.
2. Guidance on how to pull JIRA data into Power BI using an API.
3. Clarification on whether there are any pricing implications for accessing JIRA data through the API.

Your support on this would be appreciated.

Tanwa Arewa

Accessing Jira REST API for connecting to Power BI is free. The process Create an API Token, use endpoint export to JSON file.

I believe you can import a JSON file into PowerBI using Power BI REST API 

 

1. Create an API Token - https://id.atlassian.com/manage-profile/security/api-tokens

2. Select Enpoint to use, and Python scripts for automation - Atlassian provide samples and additional note for parametres 

Endpoints for Boards - https://developer.atlassian.com/cloud/jira/software/rest/api-group-board/#api-group-board

Endpoints for Sprints - https://developer.atlassian.com/cloud/jira/software/rest/api-group-sprint/#api-group-sprint

Endpoints for JQL- https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-rest-api-3-search-jql-post

3. Use Basic Authentication - https://developer.atlassian.com/cloud/jira/software/basic-auth-for-rest-apis/