Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
EugeniaBochko
Advocate II
Advocate II

How to connect Jira to PBI

Hello!

I have tasks in the JIRA  in real time, where the team report their daily progress (There are columns Assignee, Task Name, Time Spent and so on ). Can I somehow export these tables to PBI to create real-time reports? We have a lot of projects, but I need only 1 to connect.

I tried “Jira_PowerBI_ContentPack”, this code 

But it didn’t work.

Are there any other options to connect Jira to PBI?

Please help.

6 REPLIES 6
EugeneLebedev
Helper III
Helper III

The most common solution is to use one of the apps on the atlassian website like Alpha Serve. They are free if you have less than 10 users but can be quite pricy for large teams since they price per Jira users. The most expensive subscription is $30,000 per year. The pricing per user is a bit controversial since you end up paying more for the same service as your team grows.

 

An alternative is to get a one-off service for installing the scipt that integrates Power BI to Jira. This way you pay once and never have to worry about the subscription. Here is one such option: https://vidi-corp.com/how-to-connect-jira-to-power-bi/

Asinaria
Regular Visitor

You can also connect it using the "Web -> Get Data" feature from Power BI with the JIRA API

 

In the URL Parts you'll paste the URL you are trying to fetch: EX: https://asinaria.atlassian.net/rest/api/2/search?jql=project=PROJECT_ID&maxResults=1000

 

In the HTTP request headers parameters. At the box in the left you'll need to write: "Authorization", and on the right box write "Basic "  and then  "user:api_token" using base64 encoding. You can use an online tool to encode it.

 

Here is a blog post that details how to do it: post-export-your-jira-issues-to-powerbi-without-extra-tools

 

Or if you prefer a video format here its a link: https://youtu.be/efHsp4O_mzA?si=ggwZJmgZshUXPSnk

kapinal
Regular Visitor

Hello there,

It's great to see your interest in integrating Jira with Power BI for real-time reporting. I understand the importance of streamlining project progress updates. The 'Jira_PowerBI_ContentPack' sounds promising, though it's unfortunate that it didn't work out as expected. Connecting data sources can sometimes be a bit tricky.

 

Please have a look this - Power BI Jira Connector .

Hello @EugeniaBochko 

I’d like to propose and alternative solution for you, you might want to try out our app - Power BI Connector for Jira: https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=cloud&tab=overvie... it's available for Jira Cloud / Server / Data Center.

We have a handy User/Admin Guide https://aserve.atlassian.net/wiki/spaces/PBCFJC/overview and fast/responsive support team at support@alpha-serve.com. Please let us know if you need any assistance.

Cheers!

Anton

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

v-henryk-mstf
Community Support
Community Support

Hi @EugeniaBochko ,

 

You can try below steps:

Prerequisites

  • Get Power BI Desktop. You can download it for free here.
  • 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

 

For more details, you can read below blog:

Connecting Jira to Power BI: 3 Easy Steps - Learn | Hevo (hevodata.com)


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


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

Hello Henry!

 

Do you mean this Jira Connect Pack ?

I got an error trying to connect my company's Jira.

EugeniaBochko_0-1665573003079.png

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.