How to Get Data from Jira to Power BI

Getting your detailed project data out of Jira and into Power BI is the key to unlocking a consolidated view of your team's productivity and project health. Connecting these two platforms lets you move beyond Jira's native dashboards to build robust, custom reports that incorporate data from across your entire business. This guide will walk you through the most common methods for connecting Jira to Power BI, with step-by-step instructions to get you started.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Connect Jira to Power BI in the First Place?

While Jira has some solid built-in reporting features, they exist in a silo. Your project timelines, story points, and bug-fix rates don't happen in a vacuum - they impact sales pipelines, customer support tickets, and marketing campaign launches. By pulling Jira data into Power BI, you gain the ability to:

• Create a Single Source of Truth: Combine project management data with financial data from QuickBooks, sales data from Salesforce, and website data from Google Analytics. This gives you a complete picture of how engineering efforts impact business outcomes.
• Build Highly Customized Dashboards: Power BI offers far more flexibility in visualization and dashboard design than Jira. You can create reports tailored to specific stakeholders, from high-level executive summaries to granular developer performance dashboards.
• Track Advanced Metrics and KPIs: Calculate complex metrics that aren't available out-of-the-box in Jira. You can measure lead time, cycle time, defect-removal efficiency, and even correlate bug reports with customer support ticket volume.
• Automate Reporting: Once set up, your Power BI dashboards can refresh automatically. This ends the painful weekly routine of exporting CSVs and manually VLOOKUP-ing your way through spreadsheets just to give a status update.

Method 1: Using the Native Power BI Connector for Jira

The most straightforward way to connect Jira to Power BI is by using the built-in connector. This method pulls data directly via Jira’s API, allowing for scheduled refreshes to keep your reports up to date.

Step 1: Get Ready to Connect

Before you dive into Power BI, make sure you have the following:

• Power BI Desktop: You'll need the free desktop application installed on your computer.
• Your Jira URL: You need your company's specific Jira URL, which typically looks like https://your-company.atlassian.net.
• Jira Permissions: You’ll need a Jira account with permission to access the project data you want to analyze.

Step 2: Access the Jira Connector in Power BI

Open Power BI Desktop and follow these initial steps:

1. On the Home tab, click Get Data.
2. In the Get Data window, select Online Services from the list on the left.
3. Find and select Jira from the list of services and click Connect.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 3: Enter Your Jira URL and Connector Version

A dialog box will appear asking for your Jira URL. Paste it into the field. You'll also see a choice between two Connector versions:

• Connector Version 1.0 (Basic): This is the default and is best for basic imports. It provides common tables but gives you less control over what’s imported.
• Connector Version 2.0 (Advanced): This version is more powerful. It allows you to use Jira Query Language (JQL) to import only the specific issues you need. This is much more efficient if you're working with a large Jira instance with thousands of issues. For most use cases, starting with 2.0 is a good idea.

If you choose the advanced option, you can write a JQL query to filter data at the source. For example, to pull only open issues from a project named "WEB," you could use:

project = "WEB" AND status in ("To Do", "In Progress")

Step 4: Authenticate Your Jira Account

After clicking OK, Power BI will prompt you to sign in. Click the Sign in button and use your Atlassian account credentials. You may need to grant Power BI permission to access your Jira data. Once authenticated, click Connect.

Step 5: Navigate and Select Your Data

Power BI will now display the Navigator window, which shows a list of tables available from your Jira instance. This is your chance to pick which data you want to import.

You’ll see tables like:

• Issues: The heart of Jira. This table contains almost everything you need, like issue titles, descriptions, assignees, statuses, and more.
• Projects: A list of all your Jira projects.
• Users: Information about the users in your Jira instance.

For most reports, you'll want to start by selecting the Issues table. Check the box next to it and then click Transform Data. Do not click Load yet. Jira's raw data needs some cleaning up first.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 6: Clean and Transform Data in Power Query

Clicking "Transform Data" opens the Power Query Editor. This is where you’ll prepare your Jira data for analysis. The data from Jira's API is often nested in records and lists, so you'll need to expand columns to make the information usable.

Here are some of the most common transformations you'll perform:

• Expand the fields Column: This is a crucial step. The fields column is a "Record" column that contains most of your key issue data like Status, Priority, Assignee, Reporter, Start Date, Due Date, and Custom Fields. Click the double-arrow expand icon in the column header. Uncheck "Use original column name as prefix" to keep your column names clean (e.g., Status instead of fields.Status). Select the fields you need and click OK.
• Expand Nested Fields: Some of the fields you just expanded might also be records. For example, Status and Priority are often records containing properties like name and id. You'll need to expand them again to get the actual text value (e.g., "In Progress").
• Change Data Types: Power BI might interpret date fields like created or updated as text. Select these columns and use the Data Type dropdown on the Home tab to change them to a Date/Time format.
• Remove Unnecessary Columns: Your query will likely have dozens of columns you don't need. Right-click the headers of columns you won't use and select Remove to keep your data model efficient.

When you're happy with the shape of your data, click Close & Apply in the top-left corner.

Method 2: Exporting from Jira to CSV or Excel

If you don’t have the right permissions to use the connector, or if you just need a quick, one-off report, you can always fall back on the classic CSV export method.

Step 1: Filter Your Issues in Jira

Go to your Jira instance and use the search functionality to find the issues you want to analyze. Use either the Basic search or, for more control, switch to Advanced searching with JQL.

For example, to find all bugs resolved in the last month for the "MobileApp" project, you could use:

project = "MobileApp" AND issuetype = "Bug" AND status = "Done" AND resolved >= -30d

Step 2: Export a CSV File

Once your filter returns the desired issues, look for the Export button (usually in the top-right corner). Click it and select Export Excel CSV (all fields) or (current fields). This will download a CSV file to your computer.

Heads Up: Jira's standard CSV export is often limited to 1,000 issues at a time. If you need more, you may need to break your export into multiple batches or look for an app on the Atlassian Marketplace that allows for larger exports.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 3: Import the CSV into Power BI

Now, head back to Power BI Desktop:

1. Go to the Home tab and click Get Data.
2. Select Text/CSV.
3. Browse your computer to find the CSV file you just downloaded from Jira and click Open.
4. Power BI will preview the data. Click Transform Data to open the Power Query Editor for any cleaning, or click Load if it looks good to go.

This method is simple but has a major drawback: the data is static. If you want to update your report, you'll have to repeat the export and import process manually.

Tips for Success with Jira Data

Whichever method you choose, keep these tips in mind to make your reporting a success:

• Start Small: Don't try to import all data from all projects at once. Start with a single project and only the essential fields. You can always go back and add more data later.
• Learn Basic JQL: Even a little JQL goes a long way. Learning simple filters for project, status, and issue type will help you pull only the data you need, making your reports much faster and more manageable.
• Create a Date Table: For any time-based analysis (like comparing created vs. resolved issues over time), create a dedicated calendar table in Power BI and relate it to your date fields from Jira. This unlocks powerful time-intelligence DAX functions.
• Understand Your Custom Fields: Most organizations have a ton of custom fields in Jira. These will appear in the fields record and often require extra transformation steps. Make a note of their IDs and names to find them more easily in Power Query.

Final Thoughts

Pulling your project data from Jira into Power BI gives you the analytical power to go beyond default reports and truly understand your team's velocity and its impact on the wider business. By using either the native connector for live, automated reporting or a CSV export for quick analysis, you can build dashboards that provide deep, actionable insights.

While connecting these tools directly is powerful, the setup and data transformation process can be intimidating for those who aren't data experts. At Graphed, we remove that complexity entirely. We've simplified the entire workflow by letting you connect all of your data sources - including Jira, Salesforce, Google Analytics, and more - in a few clicks. Instead of wrestling with Power Query, you can just ask questions in plain English like, "Show me a chart of bugs created versus resolved by sprint for the mobile app team," and get a live, interactive dashboard built for you instantly.