How to connect to JIRA REST API

[Anonymous]

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 it's not working at all, although I've tried several suggestions from the community.

I would like to avoid using a pre-built connector from the Power BI Service marketplace, as I would rather like to build my own connection to learn how it works.

When I use the following URL in the web browser I get results:

But if I try the same URL using the power bi web source or odata feed source, i constantly get the following error:

Could someone help me out?

Thanks and regards

[Brunner_BI]

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"

[Aryna]

Hi, I found solution that might be interesting for you. Here is a script that integrates Power Bi into Jira: https://vidi-corp.com/how-to-connect-jira-to-power-bi/

[Asinaria]

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 

[Ashwitha]

Hello Alex, Did you find solution to connect power BI and jira rest API with out JIRA Content Pack

[ltopchyi]

Hi,

You can take a look at this article on connecting Jira to Power BI with REST API & ready apps as alternative: https://www.alphaservesp.com/blog/connect-jira-and-power-bi-desktop-jira-api-vs-add-ons/ 

You may find it helpful.

Liubov

[v-rongtiep-msft · Accepted solution]

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.