Forum Discussion
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 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
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.
6 Replies
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
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.
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
Hello Alex, Did you find solution to connect power BI and jira rest API with out JIRA Content Pack
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/
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"
