What is the best method to integrate Jira cloud with power BI

[Rajesh Chittibomma]

Power BI team wants to make some reports by using Jira cloud data for that it would require to integrate Jira cloud with power BI. Can you please suggest what is the best method to integrate Jira cloud with power BI.

[theCode4_company]

Hi @Rajesh Chittibomma ,

To integrate Jira Cloud with Power BI, here are some methods to consider:

1. Export data to CSV or JSON: Import the exported data to Power BI. Keep in mind the standard Jira limitations for data export, and note that this process is more manual than automated.

2. Using REST API: This highly customizable method requires good coding skills. Here is a helpful link about this topic:
   How-to-connect-Power-BI-to-JIRA-using-Rest-API 

3. Marketplace apps: There are several solutions on the Atlassian Marketplace. If you are okay with using third-party integrations, we are happy to present our Exporter for Jira plugin. We offer a totally free version with some limitations and an almost unlimited PRO version. Using our solution, you can set up a connection between Jira and Power BI once, then schedule refreshes to keep your data up-to-date automatically.

We hope this helps with your request. If you have any questions regarding our app, we will be happy to assist.

Kind regards,
theCode4 Team

[Rajesh Chittibomma]

Hi @theCode4_company Free version can export only 1000 results right?

[theCode4_company]

Hi @Rajesh Chittibomma ,

Not at all. Currently, you can export up to 20,000 Issues, but only from standard Jira Work Management fields. Additionally, you can create up to 3 data sources per each section - Power BI, Tableau, Looker Studio, CSV or JSON.

Kind regards,
theCode4 Team

[Alex Koxaras _Relational_]

Hi @Rajesh Chittibomma and welcome to the community,

Best method is to use a 3rd party app which handles all the things about connection and mapping. You can search about these apps here https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=power%20bi

[Rajesh Chittibomma]

Hi @Alex Koxaras _Relational_ Thanks for update. What about Rest API's.

By using rest api we can retrieve data from Jira right? do you have any idea about PowerBI has a built-in functionality to handle data directly from Jira rest API?

[Alex Koxaras _Relational_]

You can retrieve data from jira using REST API, but I have no idea about Power BI. You can ask on their community (if they have one). But unfortunately I don't know about how Power BI handle the data.