Service and work management · data source guide
Jira data in Power BI
Connector status
No connector of its own in Microsoft's list
Jira has no connector in Microsoft's Power Query connector index. Teams use the Jira REST API through the Web connector, CSV exports, Atlassian's own data-sharing options, or a certified third-party connector.
Checked against Microsoft Learn's Power Query connector list on 5 November 2026. Connectors change; check the list before you build.
How to get Jira data into Power BI
In order of preference for a report that refreshes on its own.
- 1
CSV export for a first version
Export a filter's issues to CSV from Jira search and load it with Text/CSV. Include the fields you report on: issue type, status, created, resolved, story points, sprint and epic.
- 2
REST API with JQL
Use the search endpoint with a JQL filter and the fields parameter, paging through results. Power BI's Web connector can call a REST API, but paging, authentication tokens and scheduled refresh in the Service take care: dynamic URLs built from parameters may not refresh in the Service unless the base URL is static (use Web.Contents with RelativePath and Query).
- 3
Status history for flow metrics
Cycle and lead time need the dates issues entered each status, which come from the changelog. Without it, use created and resolved dates only.
- 4
Third-party connectors
Certified third-party connectors in Microsoft's list may cover Jira; check coverage and pricing with the vendor.
Typical Jira KPIs
Table and column names in the DAX are illustrative: rename them to match your model.
Throughput
Issues resolved per week.
Throughput = CALCULATE ( COUNTROWS ( Issues ), USERELATIONSHIP ( Issues[ResolvedDate], 'Date'[Date] ) )Lead time
Median days from created to resolved.
Lead Time (median d) = MEDIANX ( FILTER ( Issues, NOT ISBLANK ( Issues[ResolvedDate] ) ), DATEDIFF ( Issues[CreatedDate], Issues[ResolvedDate], DAY ) )Work in progress
Issues in an in-progress status category.
WIP = CALCULATE ( COUNTROWS ( Issues ), Issues[StatusCategory] = "In Progress" )Sprint completion
Story points completed divided by points committed at sprint start.
Sprint Completion % = DIVIDE ( [Points Completed], [Points Committed] )Bug ratio
Bugs as a share of resolved issues.
Bug Ratio = DIVIDE ( CALCULATE ( [Throughput], Issues[IssueType] = "Bug" ), [Throughput] )Modelling notes for Jira
- Custom fields have IDs (customfield_10016) that differ between sites; map them in one Power Query step.
- Story points are team-relative; don't compare them across teams.
- Issues move between sprints; sprint membership is many-to-many.
Templates for Jira data
Free page layouts with a background, theme JSON and PBIP project. Swap the sample tables for your own queries.
IT template
IT Service DeskPower BI IT service desk dashboard template (ITSM): open incidents, P1s, MTTR and SLA KPIs, incident trend by priority, SLA gauge and breach-risk table.
Project & PMO template
Project PortfolioPower BI project portfolio (PMO) dashboard template with RAG status KPIs, roadmap Gantt slot, value vs effort matrix, status register and budget by programme.
Project & PMO template
Construction Project ControlsDark Power BI construction project dashboard template: earned value S-curve, CPI and SPI, forecast at completion, change orders and site safety incidents.
IT template
Cloud Cost (FinOps)Dark Power BI cloud cost (FinOps) dashboard template: spend vs budget by team, spend by service, unit cost per 1,000 requests, commitment coverage and savings.
IT template
Vulnerability ManagementDark Power BI vulnerability management template: open findings by severity, remediation SLA, mean time to remediate, finding age and riskiest assets.
Power BI visuals for IT · Power BI visuals for Project Management · More by department: Project & PMO templates · IT templates
Visuals for Jira KPIs
Chart types that suit these KPIs, with data shapes and example prompts.
Visual
Gantt ChartProject schedules with phases, tasks, owners, and start/end dates; Resource capacity lanes (each person or team as a swimlane)
Visual
Box PlotOrder-value distributions by region; Ticket-resolution-time distributions by priority
Visual
Calendar HeatmapDaily sales or revenue intensity across the year; Website traffic patterns (day-of-week × week-of-year)
Visual
Sankey DiagramCustomer journey: acquisition channel → onboarding step → conversion or churn; Budget cascade: total revenue → segment → cost bucket → net margin
Jira and Power BI: questions
Is there an official Jira connector in Power BI?
Not in Microsoft's Power Query connector index (checked 5 November 2026). Use exports, the REST API, Atlassian's data options or a third-party connector.
How do I get cycle time?
Cycle time needs the date each issue entered and left 'In Progress', which comes from the issue changelog. Lead time (created to resolved) works from standard fields.
Related data sources
Other sources teams often combine with this one.
No connector of its own in Microsoft's list
ServiceNow in Power BIServiceNow data in Power BI
Connector in Microsoft's list
SharePoint lists in Power BISharePoint lists in Power BI with the SharePoint Online list connector
Connector in Microsoft's list
Excel in Power BIExcel data in Power BI
Jira is a trademark of its owner. Product names are used only to describe compatibility; VizForge is not affiliated with, endorsed by or sponsored by the owner or by Microsoft.
Design the Jira report page first
Lay out KPI cards and visual slots in the free Design Studio, then export the background, theme JSON and a PBIP project to bind to your data.
The design studio for Power BI. Free, in your browser, no sign-up.