This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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
OK, Thanks @Anonymous!
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.