Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone!
I've been dealing with this for a long time, I need to make a dashboard with the data from Jira.
My connection with Jira works fine but every time that I refresh the data it takes many time and I don't need all the information from Jira. Only with the last 6 months would be enough.
I need to make a query against the api of Jira that gives me this information, anyone know how to do it?
Thanks!
expand "schema,names" startAt 0 maxResults 50 total 12454 issues 0 expand "operations,versionedRepr…nsitions,renderedFields" id "16605" self "http://jira.myname.com/rest/api/2/issue/16605" key "TZIR-1" fields issuetype {…} components [] timespent 111600 timeoriginalestimate null description null project {…} fixVersions [] aggregatetimespent 111600 resolution null aggregatetimeestimate 0 resolutiondate null updated "2017-01-19T08:38:44.000+0100" status {…} 1 {…} 2 {…} 3 {…} 4 {…}
@Anonymous,
Please contact JIRA support about how to add date parameter and expand parameter in its REST API to retrieve fields & data in a specific date range, then use Web connector in Power BI Desktop to connect to the API. There are articles about JIRA REST API for your reference.
JIRA REST API Tutorials
JIRA REST API examples
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.