How to get JIRA project data and use it in Power BI without the help of connectors? (with no cost)

[charitha.r]

I need to create a Power BI report to summarise all the issues in a project. Is there a way i can do it without using Power BI connectors? (no cost involved)

Please let me know. I need to know the full process.

Thanks in advance!

[theCode4_company]

Hi @charitha.r 

One way to achieve this is by utilizing Jira’s REST API. This method allows you to pull data directly from Jira into Power BI at no cost. You can try to find a detailed guide on how to do this in this topic.

However, if you find this method too complex or time-consuming, we’d like to mention that our company, theCode4, has developed a powerful tool for connecting Jira to Power BI called Data Processor for Jira. It has an absolutely Free version, which is available not only for instances with fewer than 10 users. While it does have some limitations, it should be sufficient for basic needs like summarizing project issues.

You will find it in the Atlassian Marketplace.

Feel free to try it out and let us know if you have any questions or need further assistance.

Have a nice day!

[charitha.r]

Thank you!

[theCode4_company]

Found another newer topic about using REST API that might help:
https://community.atlassian.com/t5/Marketplace-Apps-Integrations/How-to-connect-Power-BI-to-JIRA-using-Rest-API-and-without-third/qaq-p/2255960

All the best!

[charitha.r]

Hello @theCode4_company 

I got Data Processor for JIRA downloaded from admin team, however I cannot see it in the connectors.
Is there any steps that I am missing here. If I click on apps-> connector nothing is working, screen goes plain white!

please advise.

[theCode4_company]

Hi @charitha.r 

Firstly, please check with your admins to ensure that they have provided you with the necessary permissions. You can find more information in our documentation: Administration Documentation.

If the issue persists, please request support through our portal: Support Portal.

All the best!

[theCode4_company]

Oh, and btw, thanks for choosing Data Processor for your needs :) We're looking forward to hearing your feedback after some initial experience, and we'd be very grateful for a short review!

Happy data diving!

[charitha.r]

Thank you, also is there a supporting document that i can follow to get JIRA data into power BI? I need all issue list in a project. 
Please send if there is documentation supporting that

[theCode4_company]

Sure, we have a very detailed Documentation. Please refer to the User Guide: https://thecode4.atlassian.net/wiki/spaces/DPFJ/pages/2293788/User+Guide

And for more detailed instructions follow these pages step-by-step:

• https://thecode4.atlassian.net/wiki/spaces/DPFJ/pages/2261402/Create+Microsoft+Power+BI+data+source
• https://thecode4.atlassian.net/wiki/spaces/DPFJ/pages/2195818/Create+Jira+API+Token
• https://thecode4.atlassian.net/wiki/spaces/DPFJ/pages/2294231/Export+to+Microsoft+Power+BI

You can always reach our Support Team and ask for the demo if you have any issues.

Keep in touch!

[charitha.r]

Thank you so much for all the documentations sent!

I created the data source, created API token, added it to connector.

I tried putting the OData feed link in Power BI with Basic credentials of my JIRA id and API token, it is not working as it is not authenticating. 

Do I need any specific permission? I am not an admin however I have given the administration guide which you had sent me for IT support team.
Please advise.

[charitha.r]

Getting this warning

[theCode4_company]

Hi @charitha.r ,

Thank you for reaching out for help. Could you please email us at support@thecode4.com? We need to investigate the issue further.

[charitha.r]

I was able to export the data, Thank you!