Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to connect to JIRA REST API

Good afternoon community,   I'm trying to connect from Power BI Desktop to JIRA Cloud, in order to get a list of issues of a particular project, but I'm having a big headeache with the API call, as...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please refer to the steps to connect to Jira.

    Prerequisites

    • Get Power BI Desktop. You can download it for free.
    • A Power BI Pro account.
    • An Atlassian account that you can use to log in to JIRA.

    Steps to Move Data from JIRA to Power BI

    Step 1: Generate an API Token

    Step 2: Download and Install the JIRA Content Pack

    Step 3: Add the API Token to the Jira Power BI Content Pack

     

    There are a few limitations of manually transferring data from Jira to Power BI.

    • There is no documentation or support provided for this app.
    • The connection has a 100 records limitation that occurs on the JIRA side since the JIRA content pack in Power BI Service relies on JIRA API.
    • The app is prone to data-volume-related problems. Accessing a large JIRA dataset using a Power BI report based on this app will cause the app to fail. 
    • Dataset refresh takes a long time.
    • It takes a long time to process data even if you don’t load all of the fields into your report

    More deteils: Connecting Jira to Power BI: 3 Easy Steps 

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Brunner_BI's avatar
Brunner_BI
Impactful Individual
2 years ago

Here is a snippet of an M code we have been using to pull data from the Jira REST API

 

I assume you already got the personal access token from the Jira website?

 

let

// Define the API endpoint to get issues assigned to a project

url = "https://###JIRA API URL###/rest/api/latest/search?jql=project="&Project_key_2&"&maxResults="&max_results,

 

// Define the personal access token

token = #"Access Token",

 

// Define the headers with the personal access token

headers = [

#"Authorization"="Bearer " & token,

#"Accept"="application/json"

],

options = [

Headers=headers

],

 

// Make the API call and retrieve the response

response = Web.Contents(url, options),

 

// Convert the response to a table

json = Json.Document(response),

// Convert the response to a table

issues = json[issues],

#"In Tabelle konvertiert" = Table.FromList(issues, Splitter.SplitByNothing(), null, null, ExtraValues.Error)

in

#"In Tabelle konvertiert"