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.

Asinaria's avatar
Asinaria
Regular Visitor
2 years ago

Most likely is the way you are doing the Authorization part.

 

Be sure that under "HTTP request headers parameters". In the box at the left you have "Authorization". And on the left you have "Basic encoded_str", make sure there is a space. The enconded_str can be generated encoding "your_email:jira_token" with base64.

 

Here is a blog post detailing how to achieve this: post-export-your-jira-issues-to-powerbi-without-extra-tools

Or a video: https://youtu.be/efHsp4O_mzA?si=ggwZJmgZshUXPSnk