How to connect Jira to PBI

[Anonymous]

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.

[EugeneLebedev]

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]

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]

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 .

[antonstorozhuk]

Hello @Anonymous 

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]

Hi @Anonymous ,

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.

[Anonymous]

Hello Henry!

Do you mean this Jira Connect Pack ?

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