Here I'm trying to pull the data from Jira to power bi.

[kamal p]

Here every on is saying to retrive the data using Rest api. I'm new to this rest api, Using this rest api how can I retrieve the data from jira to power Bi . 

Please help me out 

[Petter Gonçalves]

Hello Kamal,

Welcome to Atlassian community!

In fact, you can use JIRA REST APIs to create script interacts and get any relevant information from JIRA.

Jus to point you in the right direction, what kind of information you are needing to get from JIRA? Are you trying to extract information from JIRA issues/Stories/Tasks?

Also, are you using JIRA Cloud? If the answer is yes, you can refer to the documentation below to know the parameter to get issues or any other possible information from JIRA:

- Get Issue - JIRA Cloud REST API

Let me know if this information answers your questions, Kamal.

[kamal p]

I'm using Jira service..

Here I'm using 3rd party driver's like Cdata, Zypsys etc but from these driver's I'm unable to pull the data as in Jira.

I'm trying to pull the data for all issues for sprints, projects to calculate velocity, active vs backlogs, Completereskin.

I need the data for the above.

How can I create the scripts for Jira Rest API to pull the data into power bi. Can you please help me out with this issue. I'm facing this issues from past 1 month

[Petter Gonçalves]

Hello Kamal,

Can you please let us know of kind of JIRA service you are using? JIRA can be configured on two platforms: Cloud or Server.

On JIRA Server you will host JIRA on your own domain and on JIRA Cloud your instance will be on Atlassian domain, which structure is xxxx.atlassian.net.

About the data that you want to retrieve from JIRA, it can be retrieved using JSON format (Rest API) or CSV format, however, I'm not sure about what formats are acceptable to import in Cdata or Zypsys. Could you provide us this information?

[kamal p]

Hello Petterson,

I'm using jira server platform.

In my organization we have your own domain not the atlassian. In my organization Jira admins has given me rest api but using this rest api how can I retrieve the data into power bi?

I have also tried using Driver's like Cdata but I'm seeing conflicts in data for example we have a 1515 ticket in sprint 1 , If the ticket 1515 is not Done in sprint 1 status is 'In progress '. The ticket 1515 is moved to sprint 2 , if ticket 1515 is done the status is 'Ready for Deployment'. 

Here is the problem, while I'm exporting the data into excel or power bi desktop, the data for ticket 1515 in sprint 1 is "ready for deployment". By using this data I'm able to find the committed and commitments for my department.