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.

[JackTheDev]

Hi,

I've built a Jira to PBI connector and can give some info about it. From what I can tell, the "easiest" way is using Power BI's OData connector. The main issue is that the data you get from the Jira API is regular JSON. Since OData is a protocol you can't just convert the JSON data to OData, you'll need to build an OData service and create a mapping of Jira fields to OData types. This is by far the most difficult part. Jira's system fields are predictable, for example their "Created" field is a datetime field and would map to the OData type of "Edm.DateTimeOffset". The custom fields are more difficult, jira field endpoint /rest/api/3/fields gives some metadata about the field, like what type of data it will store but I haven't always found this to be accurate.

You'll also need the data from the field endpoint I mentioned above to convert the field name from the field ID that the API uses (ex: customfield_12345) to what the actual field name is (ex: Story Points). If the actual field name contains certain characters like the '#' character, then you'll have to rename these because Power BI will throw an error if column names contain this. I ran into a lot of gotchas like this, but this was for a general connector that can handle every type of field, in your case I don't think it would be as difficult, but again the OData protocol will likely be your biggest hurdle. Hopefully that provides some insight into the process!

I'll plug our app in case someone wants to check it out: 

https://marketplace.atlassian.com/apps/1238345/power-bi-connector?hosting=cloud&tab=overview

Feel free to reach out to us at support@pallas-apps.com

Best,
Jack

[John5566]

You can connect Jira to Power BI using the Jira REST API with Power Query or third-party connectors. If the Jira Power BI Content Pack didn’t work, try tools like Skyvia for a no-code integration. It can sync specific projects easily. Read more here

[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

[Jair1901]

How can I change the maximum number of results?

[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.