...
Enter the URL copied above, and once connected, you can use Power BI's capabilities to create reports and dashboards based on your Jira data.
Sample report below
Security
The Data Feed feature uses JSON Web Tokens (JWT) for authentication. A JSON Web Token (JWT) in Jira is a secure way to authenticate and authorize access to APIs.
During server-side authentication with JWT, the system verifies the token's validity. If the provided token is invalid, the request will be denied as unauthorized.
JWT data is limited to identifiers and does not include any personal information.
Each token is generated when the JSON Data Feed link is created. It is unique, does not expire and is valid for 12 hours.
Sample JSON for “Time in Status” report
| Code Block |
|---|
[
{
"Issue": "Test Burndown up",
"Status": "To Do",
"Assignee": "Unassigned",
"Created": "2025-01-05 10:50:54",
"Key": "AG-255",
"audit": {
"To Do": {
"time": 380940,
"count": 2
},
"Done": {
"time": 125,
"count": 1
},
"In Progress": {
"time": 0,
"count": 0
},
"Open": {
"time": 0,
"count": 0
},
"In progress": {
"time": 0,
"count": 0
}
}
},
{
"Issue": "check is association",
"Status": "To Do",
"Assignee": "Unassigned",
"Created": "2024-12-25 11:22:52",
"Key": "AG-254",
"audit": {
"To Do": {
"time": 631693,
"count": 1
},
"Done": {
"time": 0,
"count": 0
},
"In Progress": {
"time": 0,
"count": 0
},
"Open": {
"time": 0,
"count": 0
},
"In progress": {
"time": 0,
"count": 0
}
}
}
] |